Re: How to add an entry to TNSNAMES.ORA?
- From: "Gokhan Gerezlioglu" <gokhangerezlioglu@xxxxxxxxxxx>
- Date: Wed, 5 Nov 2008 15:34:25 +0200
you dont need to reboot when you add any entry to the tnsnames.ora,
just check tnsname via tnsping in the command promt
tnsping test1_10.121.34.56
"A. Farber" <Alexander.Farber@xxxxxxxxx> wrote in message
news:1652e95d-33c9-4eca-a9b4-b4fb366ce215@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,
if I add the following entry to the TNSNAMES.ORA:
test1_10.121.34.56 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.121.34.56)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test1)
(SERVER = DEDICATED)
)
)
how could I activate it please without rebooting.
I'm using Oracle 9i Release 9.2.0.8.0 at CentOS 4.7
Linux machine (which is compatible to RHEL 4.7).
Also I wonder what are the commands to startup
and shutdown Oracle, the installation CD hasn't
created the /etc/init.d/oracle script for some reason.
Currently I have to "lsnrctl start" and then set ORACLE_SID
and sqlplus as sysdba to startup every instance.
Thank you
Alex
.
- References:
- How to add an entry to TNSNAMES.ORA?
- From: A. Farber
- How to add an entry to TNSNAMES.ORA?
- Prev by Date: changing nls parameters on database level
- Next by Date: log file sync vs log file parallel write probably not bug 2669566
- Previous by thread: How to add an entry to TNSNAMES.ORA?
- Next by thread: Re: How to add an entry to TNSNAMES.ORA?
- Index(es):
Relevant Pages
|
