sktripuraneni
asked on
ORA-12545: Connect failed because target host or object does not exist
Hello all,
Im trying to connect to an Oracle server but im not sure where i have gone wrong and i get the above message when i try to test the connection using the Net8 Assistant.
Following is my tnsnames.ora file
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\NETWORK\AD MIN\tnsnam es.ora
# Generated by Oracle configuration tools.
SMTEST.OKLADOT.state.ok.us =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.36.36.151)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = smdb)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ODOTTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = training)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ODOTTEST)
)
)
Then i have added an entry in the listener.ora file
# LISTENER.ORA Network Configuration File: C:\oracle\ora81\NETWORK\AD MIN\listen er.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stripraneni)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stripraneni)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = SMTEST)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = SMTEST)
)
(SID_DESC =
(GLOBAL_DBNAME = SMTEST.OKLADOT.state.ok.us )
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = smdb)
)
)
Do i need to do anything else in order for me to connect to the server
When i try to tnsping it is running fine and im getting an OK(130) message.
So where exactly am i going wrong
Thanks
Im trying to connect to an Oracle server but im not sure where i have gone wrong and i get the above message when i try to test the connection using the Net8 Assistant.
Following is my tnsnames.ora file
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\NETWORK\AD
# Generated by Oracle configuration tools.
SMTEST.OKLADOT.state.ok.us
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.36.36.151)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = smdb)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ODOTTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = training)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ODOTTEST)
)
)
Then i have added an entry in the listener.ora file
# LISTENER.ORA Network Configuration File: C:\oracle\ora81\NETWORK\AD
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stripraneni)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stripraneni)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = SMTEST)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = SMTEST)
)
(SID_DESC =
(GLOBAL_DBNAME = SMTEST.OKLADOT.state.ok.us
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = smdb)
)
)
Do i need to do anything else in order for me to connect to the server
When i try to tnsping it is running fine and im getting an OK(130) message.
So where exactly am i going wrong
Thanks
One error I see is that you have EXTPROC0 instead of EXTPROC in tnsnames.ora and listener.ora
1. if you have the file sqlnet.ora in the same dir as tnsnames & listener rename it.
2. if this does not work change the line SERVICE_NAME = ODOTTEST in tnsnames as SID = ODOTTEST
2. if this does not work change the line SERVICE_NAME = ODOTTEST in tnsnames as SID = ODOTTEST
ASKER
I tried renaming the sqlnet.ora and it did not work, i then changed the Service name as sid , it did not work either. Also about the environment variable set.. wat exactly should i do for that..
Adding another point ODOTTEST is working fine, Im not able to connect the very first configuration which is
SMTEST.OKLADOT.state.ok.us
Thanks
Adding another point ODOTTEST is working fine, Im not able to connect the very first configuration which is
SMTEST.OKLADOT.state.ok.us
Thanks
please check if your database is up ?
tnsping tests only listener that can be up but actual database is down so tnsping does not detect this problem.
tnsping tests only listener that can be up but actual database is down so tnsping does not detect this problem.
please check if your database is up ?
tnsping tests only listener that can be up but actual database is down so tnsping does not detect this problem.
tnsping tests only listener that can be up but actual database is down so tnsping does not detect this problem.
please check if your database is up ?
tnsping tests only listener that can be up but actual database is down so tnsping does not detect this problem
tnsping tests only listener that can be up but actual database is down so tnsping does not detect this problem
Hi sktripuraneni
Update your hosts file, with the IP of the server and the server name alongwith your domain name. If you are using WINODWS this file exists in WINNT/system32/drivers on Unix it is in the /etc directory...
HTH,
Suresh
www.aspiredba.com
Update your hosts file, with the IP of the server and the server name alongwith your domain name. If you are using WINODWS this file exists in WINNT/system32/drivers on Unix it is in the /etc directory...
HTH,
Suresh
www.aspiredba.com
ASKER
Actual Database is up and running . im still not able to figure out what exactly i need to do
Can anyone tell me the actual steps i need to follow to connect , maybe i have done something wrong?
Thanks
Can anyone tell me the actual steps i need to follow to connect , maybe i have done something wrong?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I finally got it , it was that the Service name in the tnsnames.ora on the client is not correctly configured. Follwoing configuration worked for me
SMTEST.OKLADOT.state.ok.us =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.36.36.151)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = smdb.okladot.state.ok.us)
)
)
Thanks all of your for ur comments. I did not find the required answer however jim144 and bduim provided me means to find this answer so im going to share the points between them
SMTEST.OKLADOT.state.ok.us
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.36.36.151)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = smdb.okladot.state.ok.us)
)
)
Thanks all of your for ur comments. I did not find the required answer however jim144 and bduim provided me means to find this answer so im going to share the points between them
Also you might check if the default domain is the same, I have had problems with that.