Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Navigator not connected for oracle 11 Client

venkatJun 8 2012
Hi Team,

i used sql navigator 5.5 to connect database then it shows error that is "ORA-12541: TNS:no listener".

If connected local database, its connecting properly.

Actually, I have Installed Oracle 11g release 1. Client. Now i have connected local database and checked. then Database connected.
C:\Users\duvvuriv>sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Jun 8 14:47:30 2012

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

Enter user-name: / as sysdba

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

SQL> set lines 300
SQL> select name,open_mode,log_mode from V$database;

NAME OPEN_MODE LOG_MODE
--------- ---------- ------------
ORCL READ WRITE NOARCHIVELOG

Please suggest,

Thanks & Regards,
Venkat
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2012
Added on Jun 8 2012
0 comments
547 views