-
TOAD Error
Hi,
I am trying to connect to a database catpr (with useername/ password) -which is Oracle 10g Release 10.2.0.1.0 on a unix server from my windows XP PC using TOAD. I edited the tnsnames.ora file. I checked the service with tnsping. That test succeeded. On the windows PC i have 2 oracle clients. 2 Oracle Homes are:
1.OraHome92
2.OraClient10g_home1
When i opened TOAD, at the TOAD server Login screen i entered the database name, username, password. At the Installed clients sub-window i am able to see connect using dialog box in that i have the below 2 options.
(Oracle Root)
OraHome92
I selected (Oracle Root) from that dialog box & i clicked connect.
I am getting the following errors:
ORA-01034: Oracle not available
ORA-27101: Shared memory realm does not exist
SVR4 Error: 2: No such file or directory
After i got this error i logged into the oracle database on the unix machine to check whether it is available or not. I am able to successfully login to that database on the unix machine using putty tool.
I am trying to connect to Oracle 10g Release 10.2.0.1.0 (catpr database on the unix machine) from the oracle client -home OraHome92, i think 9i Release 2 from the windows machine.
The (Oracle Root) Environment variables are:
ORACLE_HOME=c:\oracle\ora92
ORACLE_SID=
NLS_LANG=NA
SQLPATH=
C:\oracle\ora92\BIN is in system PATH
C:\oracle\ora92\BIN does exist
client dll found oci.dll
oci.dll version 9.2.0.1.0
(Oracle Root) is valid
HOME0 Environment variables are:
ORACLE_HOME_NAME=OraHome92
ORACLE_HOME=c:\oracle\ora92
ORACLE_SID=
NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH=
C:\oracle\ora92\BIN is in system PATH
C:\oracle\ora92\BIN does exist
client dll found oci.dll
oci.dll version 9.2.0.1.0
HOME0 is valid
These env variables are seen from TOAD by clicking the right side button at the Connect Using dialog box. When i clicked i got Oracle Home Editor.
Please tell me how to connect using TOAD. I have couple of databases which i need to connect. All the databases are up & running on the unix box.
thanks
-
toad
Can you log in through sqlplus from the PC?
If not, check to see if the listener is up and running on the unix box.
-
Thanks for answering. His question was posted on several other Web sites, some with numerous copies.
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
|
|