-
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
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
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"
Click HERE to vist my website!
-
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?
Never give up !
Nanda Kumar - Vellore
-
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
Last edited by diwakar; 03-20-2003 at 12:43 AM.
-
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>
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.
Last edited by ggnanaraj; 03-20-2003 at 01:37 AM.
-
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.
Last edited by ggnanaraj; 03-20-2003 at 01:34 AM.
-
Thank u Gnanraj,
I shall get back to u shortly on this.,
Regards,
K.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
Last edited by diwakar; 03-25-2003 at 02:03 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|