-
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.
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
|
Click Here to Expand Forum to Full Width
|