cannot connect as sys

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

---

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?

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

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.

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.

Thank u Gnanraj,

I shall get back to u shortly on this.,

Regards,

K.Diwakar

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