cannot connect as sys

Printable View

03-19-2003, 03:35 AM
diwakar

cannot connect as sys

Dear Sir,

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.

Could anyone throw some light on this.

Regards,

K.Diwakar
03-19-2003, 04:14 AM
Orca777

Hi, look here ...

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 [email protected] as sysdba
Enter password:
Connected.
SQL>

the diff is that i entered the pwd later.
Orca

:cool:
03-19-2003, 04:39 AM
ggnanaraj

Re: cannot connect as sys

Quote:

Originally posted by diwakar

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.

When you telnet to the box hosting the database, you need not give the connect string (provided you have only one service on the box).

Just give...

connect dcbl/dcbl

HTH.
03-19-2003, 04:40 AM
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
03-19-2003, 04:42 AM
ggnanaraj

Quote:

Originally posted by diwakar
SQL> connect sys@dcbl as sysdba
Enter password:
Connected to an idle instance.

Give ...

startup

HTH.
03-19-2003, 04:43 AM
jovery

Quote:

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
03-19-2003, 06:15 AM
Orca777

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!

on unix-shell :

Code:

set | grep -i oracle

Orca

:cool:
03-19-2003, 08:05 AM
shailendra

check the service name "dcbl" again
c:\> tnsping dcbl and see wheather it is working or not?

Shailendra
03-19-2003, 08:32 AM
nandu

Check your client connect string !

Diwakar,

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

- Nandu
03-19-2003, 08:58 AM
diwakar

Mr Jovery,

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 :

$ set | grep -i oracle
IST_DBUSED=oracle
LD_LIBRARY_PATH=/oasis/ist73/lib:/oracle/oracle9/app/oracle/product/9.0.1/lib:/u
sr/openbin/lib:/oasis/ist73/lib:/usr/devlpr/ist/lib:
ORACLE_BASE=/oracle/oracle9
ORACLE_HOME=/oracle/oracle9/app/oracle/product/9.0.1
ORACLE_SID=oasis
PATH=/oasis/ist73/ositeroot/bin:/usr/local/bin:/opt/SUNWspro/bin:.:/oasis/ist73/
bin:.:/bin:/etc:/usr/bin:/usr/sbin:/opt/rsc/bin:/usr/ccs/bin:/usr/ucb:/oracle/or
acle9/app/oracle/product/9.0.1/bin:/oracle/oracle9/app/oracle/product/9.0.1/lib:
/usr/openwin/bin:/usr/dt/bin:/oasis/ist73/bin:/oasis/ist73/lib:/oasis/ist73/form
s:/oasis/ist73/sql:/usr/4lib:/oasis/ist73:/usr/local/bin:/oasis/ist73/ositeroot/
bin:/oasis/ist73/ositeroot/cfg:/usr/sbin:/opt/SUNWspro/bin:/usr/bin:
_=oracle_sid=oasis
oracle_sid=oasis
$

Regards,

K.Diwakar
03-19-2003, 09:14 AM
jovery

Quote:

Originally posted by diwakar
Mr Jovery,
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.

I accept that is what you said in you first post, but in your later example

Quote:

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
03-19-2003, 09:19 AM
nandu

Is it a problem for you to check your tnsnames.ora in the client
and verify if it connects to the appropriate DB?

Or is it a problem for you to say "startup" to the connected idle instance and ensure if that is the desired database?
03-20-2003, 12:31 AM
diwakar

Dear All,

The problem that I need to get through with now is to connect as SYS-DBA. I would like to mention again that Iam able to connect through other users from sqlplus, but through telnet even this is not possible. Could anyone analyse the output of the command:

set | grep -i oracle

that I have posted before?

Dear Nandu,

Pls gothrough the post completely to get an idea as to what the problem is and the options that have been tried out. The problem is to connect to the desired database as SYS user as- sysdba.

Dear Mr.Jovery,

I mention again that the database is up and connecting to the desired database as sys as sysdba is one of the proiblems. Pls gothrought the post completely.

Regards,

K.Diwakar
03-20-2003, 01:27 AM
ggnanaraj

Quote:

Originally posted by diwakar
The problem that I need to get through with now is to connect as SYS-DBA. .....
...The problem is to connect to the desired database as SYS user as- sysdba.

...the database is up and connecting to the desired database as sys as sysdba is one of the proiblems.

Go to the box where your database is running and do the following after invoking sql*plus ...

Code:

TST: SYS> conn / as sysdba Connected. TST: SYS>

Quote:

Red Hat Linux release 6.2 (Zoot)
Kernel 2.2.14-5.0 on an i686
login: oracle
Password:
Last login: Wed Mar 19 09:32:53 from sun101.ctg.siptech.co.in
sql[oracle@eagle oracle]$ sqlplus

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Mar 20 10:32:30 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SQL>

HTH.
03-20-2003, 01:29 AM
ggnanaraj

Quote:

Originally posted by diwakar
I would like to mention again that Iam able to connect through other users from sqlplus, but through telnet even this is not possible.

Be sure to telnet to the unix box as the software owner of oracle(use the same OS username that was used to install Oracle on the box). Now login as any user to the database using sql*plus.

Code:

telnet 192.168.64.23 Red Hat Linux release 7.1 (Seawolf) Kernel 2.4.2-2 on an i686 login: oracle Password:xxx Last login: Wed Mar 19 16:22:01 from 192.168.64.193 You have new mail. [oracle@parrot oracle]$ sqlplus username:dbcl password:dbcl

HTH.
03-20-2003, 01:45 AM
diwakar

Thank u Gnanraj,

I shall get back to u shortly on this.,

Regards,

K.Diwakar
03-25-2003, 01:25 AM
diwakar

Connect as SYS user- possible without PWD??

Dear Gnanraj,

Your idea has finally paid off. Oracle dosent even verify the password that we give for SYS.

But right now I have a different kind of a problem (opposite to the one that I faced before). In one of the database, Iam able to connect as sys user with SYSDBA privs even though that user is not even in the group DBA ( I checked the group the user is assigned to with the ID command).

SUN OS 5.8

Oracle 9.0.1

Looking forward to hear further from you in this regard.

I have posted this as a seperate thread in this forum.

K.Diwakar