This is the error that my client receives when try to connect to the database. It used to work OK before. I tried to reboot the machine because tha database was supposed to start automatically but I got the same message.
The documentation for this type of error suggests that I should wait until the database is completely started, but I gor this message for about 3 days.
04-19-2001, 11:33 AM
Here is a thread from oracle metalink that talks about a similar issue:
This is only an opinion.
Posting from oracle metalink:
We used on platform Wintel, NT 4 Server and Workstations,
Oracle Server 7.3.4.
We used database instance.
We recreate this database with some changes.
And here start our trouble.
When Oracle service and instance is startup through Control
panel, we are not to able connect to database
(for example: SqlPlus -> ORA-01034 ORACLE not available,
ORA-09243 smsget attaching to SGA, OSD-04101 invalid SGA:
SGA not initialized; this message we took after one hour
When I start SVRMGR in this point, I get this result:
Connect ... -> Connects to an idle instance.
Shutdown ... -> ORA-01012 not loged on
Startup ... -> LCC-00161 Oracle error parameter [NULL]
ORA-01031 Insufficient privileges
When Oracle instance is startup through Instance manager,
all is right, executing same command with same parameters
Here is InitSEPS.ORA
db_name = SEPS
db_files = 100
Change the SID in the Registry:
1. Run REGEDT32 and go to HKEY_Local_Machine on Local_Machine.
2. Go to Software.
3. Go to Oracle.
4. Look for ORACLE_SID and verify it is set to the SID to which the you are trying to connect. If not, double click on ORACLE_SID and modify the string.
With the wrong value in the registry, and not specifying the
right one during connect, the software was trying to start up an SGA for a database which does not exist. You may want to try recreating the password file. Connect as
internal and issue a startup with complete path to the PFILE.
from the command prompt:
svrmgr23> connect internal/password
svrmgr23> startup pfile=