-
Hi,
I have installed Oracle Personal Edition on windows 2000.
I get ORA-27101: shared memory realm does not exist; ORA-01034: ORACLE not available when i try to connect to the database through SQL*Plus: Release 8.1.7.0.0 - Production . I checked the tnsnames.ora for correct sid.
Though i must mention that i also have a client version of oracle Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production on my machine, which has the database on the network. This seems to be working fine.
Both the above versions are installed different directory and i am trying to access them from their directory only.
Can someone please help me resolve this conflict that i am entangled in.
Thanks in advance.
-
Comment out the line
SQLNET.AUTHENTICATION_SERVICES= (NTS)
in %ORACLE_HOME%/network/admin/sqlnet.ora
inosov
Brainbench MVP for Oracle DBA
-
RE:
Hi,
Thanks for the reply.
I tried what you mentioned. But i am still getting the same error. I need help!
-
Could you explain this?
What does NTS mean?
Why and how this will work?
Thanks.
Queyon Zeng
-
The tns.ora that i have ..
C:\OraclePersonal\network\admin\tnsnames.ora has following...
MYORACPN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MyOracPn)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
The Oracle Service is running fine too. Please help!
-
Open a DOS prompt, set ORACLE_SID and try to run svrmgrl:
c:> set ORACLE_SID=
c:> svrmgrl
Can you use svrmgrl this way, startup and shutdown database etc?
If yes, verify that ORACLE_SID is set correctly in registry.
inosov
Brainbench MVP for Oracle DBA
-
RE:
I get ORA-12560: TNS:Protocol adapter error whe i run the set command.
-
Pls try again (due to typo error):
Open a DOS prompt, set ORACLE_SID and try to run svrmgrl:
c:> set ORACLE_SID= your_SID (!)
c:> svrmgrl
Can you use svrmgrl this way, startup and shutdown database etc?
If yes, verify that ORACLE_SID is set correctly in registry.
inosov
Brainbench MVP for Oracle DBA
-
RE:
I get following error:ORA:12154 : TNS:Could not resolve service name.
Also i noticed in the registry the following:
software/ORACLE/ALL HOMES has 2 different homes. One for the version (HOME0)which has oracle db on the network and HOME1 which has the Personal Edition Oracle8i
Under software/ORACLE/ORACLE_HOMES , there is ONLY ONE sublisting that is ORACLE0 which is referring to the network version.
I suspect that that the reference is only to one Oracle_home although the Personal version is installed correctly with its own Oracle_home (HOME1) and respective attributes.
I don't know what to do ?
Thanks for your active help. I appreciate that.
-
RE:
I don't get the TNS unresolved error this time. The server mgr through dos seems to be working fine. I don't know what i can do at the registry level, as i mentioned earlier that the default home recognized is only one.
Someone please help!
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|