cannot connect as sys - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: cannot connect as sys

  1. #11
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  2. #12
    Join Date
    May 2002
    Posts
    108
    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

  3. #13
    Join Date
    May 2002
    Posts
    193
    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.

  4. #14
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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.

  5. #15
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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.

  6. #16
    Join Date
    May 2002
    Posts
    193
    Thank u Gnanraj,

    I shall get back to u shortly on this.,

    Regards,

    K.Diwakar

  7. #17
    Join Date
    May 2002
    Posts
    193

    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
  •  


Click Here to Expand Forum to Full Width