Startup of a newly installed Database
496951Oct 23 2006 — edited Oct 24 2006Hi,
1. If I use startup command with no further clause to specify pfile location, I got error like this:
ora-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/920/dbs/initMY_ORACLE.ora'
2. So then I followed the Administration Guide document to try specifying the pfile location. I found one in admin directory. So I entered:
startup pfile = /opt/oracle/admin/(DBNAME)/pfile/init(SIDNAME).ora.9202006221750
Then I see the instance was started, but followed by error:
ORA-01990: error opening password file ''/opt/oracle/920/dbs/orapw'
ORA-27037: unable to obtain file status
Linux error: 2: No such file or directory
Additional information: 3
In the dbs dirctory there is a file called orapw(SIDNAME), but I cannot use Text Editor to open the file.
3. I then tried setting pfile = /opt/oracle/920/dbs/spfile(SIDNAME).ora, but got this error:
LRM-00123: invalid character 0 found in the input file
ORA-01078 failure in processing system parameters
4. I also tried setting pfile = /opt/oracle/920/dbs/init.ora and saw the instance was started, but still with error:
ORA-00205: error in identifying controlfile, check alert log for more info. So I went to check them in /opt/oracle/admin/(DBNAME)/bdump. There are two files: alert_MY_ORACLE.log and alert_(SIDNAME).log. The first one has the current info listing my startup actions 5 minutes ago. The second one lists the installation actions 3 days ago. I think this is strange because was the default SID name or the DBName during installation and I did changed it to my own (SIDNAME). I assume the most recent actions should be in alert_(SIDNAME).log, not alert_MY_ORACLE.log file.
So, what is wrong? Or what did I do wrong?
In the item 2 above, is it possile to change oracle's default path for the password file from '/opt/oracle/920/dbs/orapw' to '/opt/oracle/920/dbs/orapw'(SIDNAME)'?
For item 4, does the fact that Oracle write to alert_MY_ORACLE.log instead of alert_(SIDNAME).log mean somewhere in the system got the DBNAME or SID name confused? If so, how can I fix it?
Sorry for being so long ...