| SPFILE problem ! [message #63491] |
Mon, 11 October 2004 00:05  |
Naveen
Messages: 75
Registered: June 2001
|
Member |
|
|
I have a small problem with creating the SPFILE, can someone help me ?
These are the commands i had issued :-
1. startup nomount
2. create SPFILE from PFILE ;
Then i got an error :-
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:ORACLEORA92DATABASEINITORCL.ORA'
Ever since this happened i am unable to connect to ORACLE under any schema !
I get the following error : -
SQL> conn scott/tiger
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Warning: You are no longer connected to ORACLE.
WHY DOES THIS HAPPEN AND HOW CAN I OVERCOME IT ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
