 listener.ora [message #185168] |
Mon, 31 July 2006 06:01  |
alzuma
Messages: 46
Registered: July 2006
Location: CA
|
Member |
|
|
i have two seperate oracle instances on a 2-diff users unix host, i made two seperate listeners with diff ports for them in each user under its /..../network/admin?
i modified the client tnsnames.ora to connect from sqlplus on first or the second instances , it give me error
" ORA-12537: TNS:connection closed "
but when connect from the user sqlplus unix machine , no problem it connect , the problem in remote connection??
can anybody give me explanation or another senario to do this
|
|
|
|
|
|
| Re: listener.ora [message #185241 is a reply to message #185214] |
Mon, 31 July 2006 12:49  |
alzuma
Messages: 46
Registered: July 2006
Location: CA
|
Member |
|
|
1- listener_posttest (server- located in $Oracle_home/network/admin of instance1)
------------------------------
PostTest =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCPostTest))
(ADDRESS= (PROTOCOL= TCP)(Host= ruxdevdb.sp.local )(Port= 1521))
)
SID_LIST_PostTest =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /u01/oracleTest/posttestdb/9.2.0)
(SID_NAME = PostTest)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracleTest/posttestdb/9.2.0)
(PROGRAM = extproc)
)
)
STARTUP_WAIT_TIME_PostTest = 0
CONNECT_TIMEOUT_PostTest = 10
TRACE_LEVEL_PostTest = OFF
LOG_DIRECTORY_PostTest = /u01/oracleTest/posttestdb/9.2.0/network/admin
LOG_FILE_PostTest = PostTest
TRACE_DIRECTORY_PostTest = /u01/oracleTest/posttestdb/9.2.0/network/admin
TRACE_FILE_PostTest = PostTest
ADMIN_RESTRICTIONS_PostTest = OFF
IFILE=/u01/oracleTest/posttestdb/9.2.0/network/admin/PostTest_ruxdevdb/listener_ifile.ora
2- listener_postdb (server- located in user2_base_dir/network/admin of instance2)
---------------------------
postdb =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCpostdb))
(ADDRESS= (PROTOCOL= TCP)(Host= ruxdevdb.sp.local )(Port= 1522))
)
SID_LIST_postdb =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /u01/oracleTest/posttestdb/9.2.0)
(SID_NAME = postdb)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracleTest/posttestdb/9.2.0)
(PROGRAM = extproc)
)
)
STARTUP_WAIT_TIME_postdb = 0
CONNECT_TIMEOUT_postdb = 10
TRACE_LEVEL_postdb = OFF
LOG_DIRECTORY_postdb = /u01/postdb/network/admin
LOG_FILE_postdb = postdb
TRACE_DIRECTORY_postdb = /u01/postdb/network/admin
TRACE_FILE_postdb = postdb
ADMIN_RESTRICTIONS_postdb = OFF
3- tnsnames (server- located in .../network/admin of instance1)
-------------------------------------------------------
PostTest=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=RUXDEVDB.sp.local)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=PostTest)
(INSTANCE_NAME=PostTest)
)
)
PostTest_806_BALANCE=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=RUXDEVDB.sp.local)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=PostTest)
(INSTANCE_NAME=PostTest)
)
)
PostTest_FO=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=RUXDEVDB.sp.local)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=PostTest)
(INSTANCE_NAME=PostTest)
)
)
PostTest_LOCAL=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=RUXDEVDB.sp.local)(PORT=1521))
)
PostTest_BALANCE=
(DESCRIPTION=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=RUXDEVDB.sp.local)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=PostTest)
)
)
PostTest_REMOTE=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=RUXDEVDB.sp.local)(PORT=1521))
)
)
extproc_connection_data =
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPostTest))
)
(CONNECT_DATA=
(SID=PLSExtProc)
(PRESENTATION = RO)
) )
IFILE=/u01/oracleTest/posttestdb/9.2.0/network/admin/PostTest_ruxdevdb/PostTest_ruxdevdb_ifile.ora
4- tnsnames (client)
-------------------------------------------------------
posttest =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.1.60)(PORT = 1521))
(CONNECT_DATA = (SID = PostTest))
)
postdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.1.60)(PORT = 1522))
(CONNECT_DATA = (SID = postdb))
)
note : i defined TNS_ADMIN=/u01/postdb/network/admin
in user2 (postdb) in its .profile
/u01/postdb = user2_base_dir
|
|
|
|
| Re: listener.ora [message #185243 is a reply to message #185168] |
Mon, 31 July 2006 13:00 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| alzuma wrote on Mon, 31 July 2006 07:01 |
i have two seperate oracle instances on a 2-diff users unix host, i made two seperate listeners with diff ports for them in each user under its /..../network/admin?
|
I wasn't quite clear on this. Do you have two separate unix hosts or two separate users?
If it's one host, what does this command give?
ps -aef | grep lsnr
If it's on two separate hosts, run the same command on both hosts.
If it's one a single host, don't have separate users to hold the listener.ora files. Put both listeners in the same listener.ora and when you start the listener, start it like:
lsnrctl start PostTest
and
lsnrtctl start postdb
[Updated on: Mon, 31 July 2006 13:04] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
