Home » RDBMS Server » Server Administration » Error Message: ORA-01078
Error Message: ORA-01078 [message #49899] Sat, 16 February 2002 22:35 Go to next message
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>

Report message to a moderator

Re: Error Message: ORA-01078 [message #49904 is a reply to message #49899] Sun, 17 February 2002 06:47 Go to previous messageGo to next message
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

Report message to a moderator

Re: Error Message: ORA-01078 [message #49913 is a reply to message #49899] Sun, 17 February 2002 22:08 Go to previous messageGo to next message
Henry Tran
Messages: 2
Registered: February 2002
Junior Member
Thanks for your help.

I did start the service before trying to starting up the instance, but still no luck!

ht

Report message to a moderator

Re: Error Message: ORA-01078 [message #49919 is a reply to message #49899] Mon, 18 February 2002 08:16 Go to previous message
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.)

Report message to a moderator

Previous Topic: Data File size
Next Topic: Re: Braindumps of ORACL8 & 8i Available
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Aug 06 15:04:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.