Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TOAD Error

User01Jun 9 2006 — edited Jun 23 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2009
Added on Jun 9 2006
6 comments
8,900 views