Home » RDBMS Server » Networking and Gateways » about listener.ora,tnsnames.ora (Oracle 10.2,window)
about listener.ora,tnsnames.ora [message #346298] Mon, 08 September 2008 02:30 Go to next message
raj_roshan_009
Messages: 29
Registered: May 2008
Junior Member
Hi all,

Oracle:-10.2
OS:-Wimdow

i had deleted the "listner.ora" and "tnsnames.ora" file from
C:\oracle\..\10.2.1\db_3\NETWORK\admin

and then Reload the Listner.

But still when i try to connect the database,it connects.

WHY??

Please guide me.

Regards
Roshan.
Re: about listener.ora,tnsnames.ora [message #346309 is a reply to message #346298] Mon, 08 September 2008 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are not mandatory files.
It depends on what you did.
Listener no more needs listener.ora when it is started, and this latter is useless on a client.

Regards
Michel
Re: about listener.ora,tnsnames.ora [message #346312 is a reply to message #346309] Mon, 08 September 2008 03:04 Go to previous messageGo to next message
raj_roshan_009
Messages: 29
Registered: May 2008
Junior Member
Hi,

What is the condition,so that configuration of the listner.ora and tnsnames.ora file is mandatory.

Regards
Roshan.
Re: about listener.ora,tnsnames.ora [message #346355 is a reply to message #346312] Mon, 08 September 2008 05:45 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Listener.ora file required when restart the listener services.

TNSNAMES.ora file is must be exist for connect to database server from any client.

LISTENER.ORA file is always and only exist in ORACLE SERVER SIDE.

TNSNAMES.ORA file is always required for only ORACLE CLIENT SIDE.

Re: about listener.ora,tnsnames.ora [message #346413 is a reply to message #346298] Mon, 08 September 2008 08:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Quote:

Listener.ora file required when restart the listener services.


NOT true for V10.2 & above. It will default to to port 1521 & database(s) will automagically autoregister.

Re: about listener.ora,tnsnames.ora [message #346417 is a reply to message #346413] Mon, 08 September 2008 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If we are strictly speaking, tnsnames.ora is also not required on client, you can give the full description in connect string.

Regards
Michel
Re: about listener.ora,tnsnames.ora [message #346973 is a reply to message #346417] Wed, 10 September 2008 04:50 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

@Michal,
...If we are strictly speaking, tnsnames.ora is also not required on client, you can give the full description in connect string. ...
Right but it is just an alternative.


@Ana,

SQL> select * from v$version where rownum =1;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod

---Stop Listner Services
SQL> host lsnrctl stop

LSNRCTL for 32-bit Windows: Version 10.2.0.4.0 - Production on 10-SEP-2008 13:28
:20

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=spiorapr.Sterling.local)
(PORT=1521)))
The command completed successfully

'--getting error
SQL> conn scott/tiger@hgc
ERROR:
ORA-12541: TNS:no listener



Warning: You are no longer connected to ORACLE.

--start listener services
SQL> host lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.4.0 - Production on 10-SEP-2008 13:29
:14

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.4.0 - Production
System parameter file is D:\oracle\product\10.2.0\db_1\network\admin\listener.or
a
Log messages written to D:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=spiorapr.Sterling.local)
(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc
)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=spiorapr.Sterling.local)
(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.4.0 - Produ
ction
Start Date 10-SEP-2008 13:29:16
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=spiorapr.Sterling.local)(PORT=1521))
)
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

--remove listener.ora file from file system.

SQL> host del D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora


--it is connected without problem becuase after listener is start "LISTENER.ORA" file is not required.

SQL> conn scott/tiger@Hgc
Connected.


---Restart listener services
SQL> host lsnrctl stop
LSNRCTL for 32-bit Windows: Version 10.2.0.4.0 - Production on 10-SEP-2008 13:30
:22

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully

SQL> host lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.4.0 - Production on 10-SEP-2008 13:30
:28

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.4.0 - Production
Log messages written to D:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=spiorapr.Sterling.local)
(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.4.0 - Produ
ction
Start Date 10-SEP-2008 13:30:30
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=spiorapr.Sterling.local)(PORT=1521))
)
The listener supports no services
The command completed successfully

SQL> conn scott/tiger@Hgc
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


BUT this time i accept Ana your right...


Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

---need to manually register.
SQL> alter system register;
System altered.

SQL> conn /@hgc as sysdba
Connected.

NOTE: HGC is TNS_ENTRY.


NOT true for V10.2 & above

NOT true for V10.1 also Smile (TESTED)


Previous Topic: Check concurrent connection limit
Next Topic: Not able to connect to Oracle
Goto Forum:
  


Current Time: Thu Mar 28 21:14:02 CDT 2024