Error Message: ORA-01078 [message #49899] |
Sat, 16 February 2002 22:35 |
Henry Tran
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
Hi,
Please help!
I tried to create a second database TESTDB beside the default ORCL on a WINS 2000 Server box. Thus, after shutting down the default db, I did the followings to create the Service and tried to start the instance but I got the error message (at the end of the following)
***************************************
C:>set oracle_sid = TESTDB
C:>oradim -new -sid TESTDB -intpwd admin -startmode auto -pfile C:OracleadminTESTDBpfileinitTESTDB.ora
C:>svrmgrl
Personal Oracle8i Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SVRMGR> connect internal/oracle
Connected.
SVRMGR> show sga
ORA-01034: ORACLE not available
SVRMGR> startup nomount pfile=C:OracleadminTESTDBpfileinitTESTDB.ora
LRM-00109: could not open parameter file 'C:OracleadminTESTDBpfileinitTESTDB.o
a'
ORA-01078: failure in processing system parameters
SVRMGR>
|
|
|
Re: Error Message: ORA-01078 [message #49904 is a reply to message #49899] |
Sun, 17 February 2002 06:47 |
Kassim Kasmani
Messages: 25 Registered: January 2002
|
Junior Member |
|
|
You wrote:
//LRM-00109: could not open parameter file 'C:OracleadminTESTDBpfileinitTESTDB.o
a'
//
I couldn't help but notice a spelling typo. Instead of ORA you have typed OA for the extention of your initiazation file.
__________________________
Kassim Kasmani
Yahoo Messenger: kassim13
|
|
|
|
Re: Error Message: ORA-01078 [message #49919 is a reply to message #49899] |
Mon, 18 February 2002 08:16 |
Jadie
Messages: 64 Registered: January 2002
|
Member |
|
|
Following the steps:
1. Using an old parameter file to create a new initTESTDB.ora. Be sure to edit the parameters properly.
2. Run command:
oradim -new -sid TESTDB -intpwd admin -startmode
auto -pfile C:OracleadminTESTDBpfileinitTESTDB.ora
3. set oracle_sid=testdb
4. SVRBGR> connect internal
password:
5: SVRMGR> startup nomount
(make sure the initTESTDB.ora exists.)
|
|
|