I have 2 different databases DB01 and DB02 on a Win2k Server.
When I try connect to DB01 whru SQLPlus from a Workstation, I get this :
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
I dont have this problem with DB02.
I have set ORACLE_SID=DB01 in Registry. If I remove this and restart the server, the database does not come up. When I get bring the database up from Svrmgrl, every thing works fine. When I have have ORACLE_SID=DB01, the database starts but the "shared Mem realm" problem occurs.
Wy dont I have any problems with DB02.
Sridhar R Patnam
Dear first let us know which Oracle version you are using.
If oyu are using Oracle 8i then before issuing svrmgrl write this on command prompt
c:\ set oracle_sid=DB01
/* this should display DB01 */
Hope it should work fine with this. Just try this...
"Greatest Rewards come only with Greatest Commitments!"
Problem will reoccur after a restart of server. The work is in development phase and restarting is a common thing here. I want things to be ok in my absence.
Sridhar R Patnam
1. Set SQLNET.AUTHENTICATION_SERVICES=(NTS) to SQLNET.AUTHENTICATION_SERVICES=(NONE) in SQLNET.ORA
2. Change the user that starts the OracleService to the Oracle DBA user who is defined to the Windows domain.
Go to Control Panel, Services, select the OracleService, right click and select properties, select the Log On tab. Click on the Account radio button and fill in the domain qualified dba user and password (e.g. ORACLE-UK\ORADBA) and click the okay button.
Life is a journey, not a destination!
Also do a run on regestary editor and go to HKEY USERS select software and for oracle services set the properties to true.
VenDe ChukPeen Zuri
Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think
Click Here to Expand Forum to Full Width