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

Thread: connect as sysdba

  1. #11
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by akhadar
    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    c:\set oracle_sid = ricd

    SQL> conn / as sysdba
    ERROR:
    ORA-12560: TNSrotocol adapter error


    Warning: You are no longer connected to ORACLE.
    SQL> conn /@ricd as sysdba
    Connected.

    According to ur post, i suspect u are setting oracle_sid in command prompt and opening a sqlplusw session and entering user credentials.

    That is wrong.

    I suspected because

    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production
    after the banner you logged into SQLPLUSW, where from you got command prompt in that?


    c:\set oracle_sid = ricd

    SQL> conn / as sysdba
    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  2. #12
    Join Date
    May 2001
    Posts
    736
    Sorry for the confusion as it was end of the day i was little hurry in working and pasting the things.Here are the latest results
    1.On a server where only one instance is there.Remember even i didn't set the SID.

    Microsoft Windows 2000 [Version 5.00.2195]
    (C) Copyright 1985-2000 Microsoft Corp.

    C:\Documents and Settings\akhadar>cd\

    C:\>sqlplus /nolog

    SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 16 07:27:46 2003

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

    SQL> conn / as sysdba
    Connected.
    SQL> select * from global_name;

    GLOBAL_NAME
    --------------------------------------------------------------------------------

    RICT.CRB.SE.COM.SA

    SQL> exit
    Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    C:\>

    2.On the server where there are 2 instances

    Microsoft Windows 2000 [Version 5.00.2195]
    (C) Copyright 1985-2000 Microsoft Corp.

    C:\Documents and Settings\akhadar>cd\

    C:\>set oracle_sid=ricd

    C:\>echo %oracle_sid%
    ricd

    C:\>sqlplus /nolog

    SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 16 07:30:40 2003

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

    SQL> conn / as sysdba
    ERROR:
    ORA-12560: TNSrotocol adapter error


    SQL> conn /@ricd as sysdba
    Connected.
    SQL> select * from global_name;

    GLOBAL_NAME
    --------------------------------------------------------------------------------

    RICD.CRB.SE.COM.SA

    SQL> disc
    Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production
    SQL> exit

    C:\>set oracle_sid=ricd1

    C:\>echo %oracle_sid%
    ricd1

    C:\>sqlplus /nolog

    SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 16 07:31:59 2003

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

    SQL> conn / as sysdba
    ERROR:
    ORA-12560: TNSrotocol adapter error


    SQL> conn /@ricd1 as sysdba
    Connected.
    SQL> select * from global_name;

    GLOBAL_NAME
    --------------------------------------------------------------------------------

    RICD1.WORLD

    SQL> disc
    Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production
    SQL> exit

    C:\>

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