ASMS 2009
defining a connection string
Document Actions
this is how you can define a connection string to another database
1. write you listener.ora file
<my listener> = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<my host>)(PORT=<my port>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE NAME=<my service>)))
2. start lsnctrl
LSNRCTL> set current_listener <my listener>
Current Listener is <my listener>
LSNRCTL> set password
Password: hfhfkdshfkds
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<my host>)(PORT=<my port>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE NAME=<my service>)))
STATUS of the LISTENER
------------------------
Alias <my listener on the remote site>
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 12-SEP-2006 22:45:30
Uptime 0 days 0 hr. 18 min. 18 sec
Trace Level off
Security ON: Password or Local OS Authentication
SNMP ON
Listener Parameter File /oracle/10g/network/admin/listener.ora
Listener Log File /oracle/10g/network/log/listener.log
Listening Endpoints Summary...
3. now save the config with the set password
LSNRCTL> save_config
that should be all now you can connect with your sql plus or rman.
sqlplus *****/*****@<my listener>
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 12 16:54:39 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
<my listener> = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<my host>)(PORT=<my port>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE NAME=<my service>)))
2. start lsnctrl
LSNRCTL> set current_listener <my listener>
Current Listener is <my listener>
LSNRCTL> set password
Password: hfhfkdshfkds
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<my host>)(PORT=<my port>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE NAME=<my service>)))
STATUS of the LISTENER
------------------------
Alias <my listener on the remote site>
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 12-SEP-2006 22:45:30
Uptime 0 days 0 hr. 18 min. 18 sec
Trace Level off
Security ON: Password or Local OS Authentication
SNMP ON
Listener Parameter File /oracle/10g/network/admin/listener.ora
Listener Log File /oracle/10g/network/log/listener.log
Listening Endpoints Summary...
3. now save the config with the set password
LSNRCTL> save_config
that should be all now you can connect with your sql plus or rman.
sqlplus *****/*****@<my listener>
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 12 16:54:39 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Created by
zwluxx
Last modified 2006-09-12 11:57 PM
Last modified 2006-09-12 11:57 PM
