| Re: How to create a connect string without editing Tnsnames.ora? [message #69556] |
Thu, 31 January 2002 06:08 |
José Luis Delgado Solano
Messages: 9
Registered: January 2002
|
Junior Member |
|
|
I apologize for answering late...
Since many people asked me by email, how to create the connect string without tnsnames...
Here is the answer... enjoy it!
Steps:
1. Ensure the server is running an Net8 listener
2. In the server LISTENER.ORA
configuration file use the
'hostname' as the GLOBAL_DBNAME parameter.
Eg:
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC= (SID_NAME=MY_SID)
(GLOBAL_DBNAME=myhostname.domain.com)
(ORACLE_HOME=/app/oracle/product/8.1.7)
)
)
3. Ensure the listener will listen
on port 1521 (TCP/IP)
Eg:
(PROTOCOL=TCP)(HOST=myhostname.domain.com)
(PORT=1521)
4. IMPORTANT step:
You need to RESTART (or reload) your listener
to apply the changes and everything work.
5.- (Optional) Ensure you put this line to your
sqlnet.ora file:
NAMES.DIRECTORY_PATH = (HOSTNAME)
6. From a client machine you can connect
to this database using
the alias 'myhostname.domain.com'.
Eg: sqlplus scott/tiger@myhostname.domain.com
Note: You should have and /etc/hosts entry for
myhostname at least... in order to have this configuration to work!
Hope this helps!
Regards!
any comments, feel free to send an email to:
joseluis_delgado@yahoo.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
