Could anyone point out the reason for the errors that I get:
SQL> sho user
user is "DCBL"
SQL> connect sys/change_on_install@dcbl as sysdba
ERROR:
ORA-12154: TNS:could not resolve service name
Warning: You are no longer connected to ORACLE.
SQL> connect dcbl/dcbl@dcbl
Connected.
You can see that Iam not able to connect as sysdba but as user DCBL for the same service. This happens while trying to connect through SQLPLUS on my PC(Windows).
When I do it through telnet, I get the same error:
SQL> connect dcbl/dcbl@dcbl
ERROR:
ORA-12154: TNS:could not resolve service name
Warning: You are no longer connected to ORACLE.
But through telnet I cannot connect even as the user DCBL as I did so in the previous case.
SQL*Plus: Release 9.2.0.2.0 - Production on Wed Mar 19 09:14:10 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: system/manager
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
SQL> connect sys@db1.win as sysdba
Enter password:
Connected.
SQL>
Dear Sir,
Even your option had been tried before and the output is as follows:
SQL> connect sys@dcbl as sysdba
Enter password:
Connected to an idle instance.
SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-01012: not logged on
Originally posted by diwakar Dear Sir,
Even your option had been tried before and the output is as follows:
SQL> connect sys@dcbl as sysdba
Enter password:
Connected to an idle instance.
SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-01012: not logged on
SQL>
So how to go about from this point??
Regards,
K.Diwakar
Your connected to an idle instance, start the DB before you select from DD views.
HTH
Jim
Oracle Certified Professional "Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Hi,
First : thank you for your politness but just call me ORCA;
Second : TELNET
It could be that telnet starts another shell then your local unix-console. due to this the environment for oracle could be unkown, so be sure that your oracle-environment is the same via local or telnet-session!
Through telnet getting connected to an idle instance via SYS means, your DB is not started yet. Pls check if the connect string 'dbcl' in the client is pointing to the right database. If the instance has not been started, you can in no way get connected from a client as connect dcbl/dcbl@dcbl
I think you have not read the previous section of my post. I have clearly stated that Iam able to login as user DCBL which means that the database is up.
Iam not able to connect as any user through telnet, able to connect as user DCBL through SQLPLUS directly.
Dear Orca777,
Iam pasting the output of the command: set | grep -i oracle
What I could infer from this is that the SID is OASIS and not DCBL. But I have given the command: export oracle_sid=dcbl. But this is of no use. I have little knowledge on UNIX. Pls advice me on the same :
Reply With Quote
Bookmarks