| Oracle not available [message #53498] |
Tue, 24 September 2002 11:23  |
Pascal
Messages: 7
Registered: October 2001
|
Junior Member |
|
|
Hi,
I need some help loggin onto my Oracle db. I installed Oracle 8i on winnt with 64mb and when I try to log on I get:
"Oracle not available"
"The shared memory realm does not exist."
when I log on as internal/Oracle I get
"connected to an idle instance"
So I go into svrmgrl and try to start up the database
svrmgrl>connect internal/oracle
connected.
svrmgrl>startup nomount
The shared realm already exists
svrmgrl>startup mount
The shared realm already exists
svrmgrl>startup open pfile ="pathtofileinit.ora"
The shared realm already exists.
svrmgrl>show sga
Oracle not available
svrmgrl>select * from v$database;
Oracle not available.
So everything else I do gives me the Oracle not available. Someone told me to rem out the authentication line in sqlnet.ora and reduce the number of processes in init.ora which I did but so far it's a no go.
Please help!!!
Thanks.
|
|
|
|
| Re: Oracle not available [message #53499 is a reply to message #53498] |
Tue, 24 September 2002 11:38  |
Gilson Sirvas
Messages: 6
Registered: September 2002
|
Junior Member |
|
|
Hi Pascal
try this
Fisrt you must sure that your services are up and runing, if you don't have this services you can't start your database, if your services are running probably your database is up and runing too. But if your database is down follow this
At the command prompt
set ORACLE_SID=[[SID]]
svrmgrl
connect internal
startup
If you continue having the same problem, I suggest review the alert log file to see the complete error messages.
If you don't find the services you can recreate them, using oradim utility
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
