-
i have configured my database with mts option. but only local host can connected to it(sqlplus scott/tiger@testdb), on other machine, sqlplus can't connected to my database. why? below message is my config files in server and client , i need help.
thanks.
#################################
#listener.ora in database server
#################################
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.228)(PORT = 9137))
(PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 9138))
(PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)
)
)
)
CONNECT_TIMEOUT_LISTENER = 2
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = testdb.legend.com)
(ORACLE_HOME = /app/oracle/product/release/8.1.5)
(SID_NAME = testdb)
)
)
#################################
#init.ora in database server
#################################
mts_dispatchers = "(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))(DIS=2)(SES=254)(CON=254
)(TIC=15)(POO=NO)(MUL=NO)(LIS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.
228)(PORT=9137))))"
mts_dispatchers = "(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))(DIS=2)(SES=254)(CON=254
)(TIC=15)(POO=NO)(MUL=NO)(LIS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.
228)(PORT=9138))))"
mts_max_dispatchers = 100
mts_servers = 2
mts_max_servers = 20
#################################
#tnsnames.ora in client machine
#################################
testdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.228)(PORT = 9137))
)
(CONNECT_DATA =
(SERVICE_NAME = testdb.legend.com)
)
)
#################################
#error messgae in client machine
#################################
sqlplus
Enter user-name: scott/tiger@testdb
ERROR:
ORA-12545: Connect failed because target host or object does not exist
note: network is available and ip address is valid.
-
ftp your tnsnames.ora file from your server to Client and try.
ie. update your client tnsnames.ora with your server tnsnames.ora
Good Luck
-
Try this:
TNSPING (or TNSPING80 depending on your client version)
First try this:
TNSPING testdb
see what happens and report. If fails try
TNSPING testdb.legend.com
Also rename sqlnet.ora (if it's there) on client machine to something else(to make it invisible to Oracle) and retry.
-
hi, Chandra and JDoyle:
Thank your help !
Chandra, I compared tnsnames.ora in client side and server side, find unique different is tnsnames.ora of server using hostname in "address" section, but in client, it using ip address in "address" section. i must to be add alias of server machine to /etc/hosts of clients , then i can connected to database. but when i removed that alias and changed alias to ip address , same error occured. why? i must be resolve this problem.
JDoyle, i also renamed sqlnet.ora to other. but it also can't connected to my database.
