| about listener.ora,tnsnames.ora [message #346298] |
Mon, 08 September 2008 02:30  |
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 #346973 is a reply to message #346417] |
Wed, 10 September 2008 04:50  |
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  (TESTED)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
