novicedbaUK
asked on
ORA-12545
Hi all
I am having a problem with my test database. I am trying to restore the production databases cold backup over the test database. However, I am getting ORA-12545: Connect failed because target host or object does not exist, when I try to connect. I have created a password file on this environment too. I am using Oracle9 and AIX 5. I am ble to ping to the host name and ip address from other machines. The hostname is also present in the host file. I do not understand what could be wrong. My tnsnames is below
MCSPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aix-scratch)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MCSPROD.xxxxxxx.com)
)
)
Thanks
I am having a problem with my test database. I am trying to restore the production databases cold backup over the test database. However, I am getting ORA-12545: Connect failed because target host or object does not exist, when I try to connect. I have created a password file on this environment too. I am using Oracle9 and AIX 5. I am ble to ping to the host name and ip address from other machines. The hostname is also present in the host file. I do not understand what could be wrong. My tnsnames is below
MCSPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aix-scratch)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MCSPROD.xxxxxxx.com)
)
)
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello
My tnsnames is below
MCSPRD01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aix-scratch)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MCSPRD01.midlandscoop.com)
)
)
My listener is below
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aix-scratch)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /orascratch/oracle/oui)
(PROGRAM = extproc)
)
)
My sqlnet.ora is below
# SQLNET.ORA Network Configuration File: /orascratch/oracle/oui/net
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
I really hope that someone can help
Thanks
My tnsnames is below
MCSPRD01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aix-scratch)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MCSPRD01.midlandscoop.com)
)
)
My listener is below
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aix-scratch)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /orascratch/oracle/oui)
(PROGRAM = extproc)
)
)
My sqlnet.ora is below
# SQLNET.ORA Network Configuration File: /orascratch/oracle/oui/net
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
I really hope that someone can help
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
If you are using hostname to resolve connect descriptor then you need to modify listener.ora with hostname that is hosting database.
I can provide more information if you post sqlnet.ora and listener.ora file here.