Home » RDBMS Server » Server Administration » listener.ora
icon11.gif  listener.ora [message #185168] Mon, 31 July 2006 06:01 Go to next message
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 #185214 is a reply to message #185168] Mon, 31 July 2006 10:11 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Show us the tnsnames.ora and listener.ora on your server and the tnsnames.ora on your client.
Re: listener.ora [message #185241 is a reply to message #185214] Mon, 31 July 2006 12:49 Go to previous messageGo to next message
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 Go to previous message
joy_division
Messages: 4644
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

Previous Topic: how to create tablespace
Next Topic: Listeners Conflict due to 10g Grid Control
Goto Forum:
  


Current Time: Sat Dec 10 16:30:34 CST 2016

Total time taken to generate the page: 0.10332 seconds