Home » RDBMS Server » Server Utilities » Re: How to create a connect string without editing Tnsnames.ora?
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
Previous Topic: Re: How to create a connect string without editing Tnsnames.ora?
Next Topic: HELP I NEED HELP WITH ORACLE
Goto Forum:
  


Current Time: Fri Mar 29 04:28:38 CDT 2024