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?
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.
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.
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.
Red Hat Linux release 7.1 (Seawolf)
Kernel 2.4.2-2 on an i686
Last login: Wed Mar 19 16:22:01 from 192.168.64.193
You have new mail.
[oracle@parrot oracle]$ sqlplus
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
Looking forward to hear further from you in this regard.
I have posted this as a seperate thread in this forum.