SYS connect
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: SYS connect

  1. #1
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94

    SYS connect

    Hi all,
    I've configured password file with orapwd and I have problem when connecting with sys :
    sqlplus sys/sys_password@service_name

    any idea what's wrong.

    //Hamhey

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    And if you append your connection with --as sysdba then you can connect?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    Hi,
    Connection with niether of
    sqlplus sys/change_on_install@service_name
    sqlplus sys/change_on_install@service_name as sysdba
    are not possible

    //Hamhey

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    If you are trying to connect to DB as SYSDBA from the server where DB exist, then Password File is of no use.

    If from Client you want to make connection to DB as SYSDBA, then Password file will be of use..

    Where are you connecting from, if at server side,
    conn / as sysdba is enough.

    Provided the user (OS) is in the ORA_DBA group & SQLNET authentication mode is NTS.

    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"

  5. #5
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Originally posted by abhaysk
    If you are trying to connect to DB as SYSDBA from the server where DB exist, then Password File is of no use.
    Sure it is.
    You cannot connect like "user/pass@db as sysdba" without a password file.

    Hamhey, what responses do you get on those connects?
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  6. #6
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    Hi
    Well, I have a password file and connecting as other users defined as sysdba in the password file are able to be connected like:

    test/pass@service_name
    connect test/pass as sysdba

    which I would prefer without connect test/pass
    to connect to RMAN catalog for instance.

    and the user sys/change_on_install cannot connect to database even with password file using:

    sqlplus sys/change_on_install@service_name

    //Hamhey

  7. #7
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Originally posted by hamhey
    and the user sys/change_on_install cannot connect to database even with password file using:

    sqlplus sys/change_on_install@service_name
    What is the error message?
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  8. #8
    Join Date
    May 2001
    Posts
    736
    C:\>SVRMGRL

    Oracle Server Manager Release 3.1.7.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    SVRMGR> CONNECT AKHADAR AS SYSDBA
    Password:
    Connected.
    SVRMGR> SELECT * FROM V$PWFILE_USERS;
    USERNAME SYSDB SYSOP
    ------------------------------ ----- -----
    INTERNAL TRUE TRUE
    SYS TRUE TRUE
    AKHADAR TRUE TRUE
    TEST TRUE FALSE
    4 rows selected.
    SVRMGR> DISCONNECT
    Disconnected.
    SVRMGR> EXIT
    Server Manager complete.

    C:\>rman target / nocatalog

    Recovery Manager: Release 8.1.7.0.0 - Production

    RMAN-06005: connected to target database: RICT (DBID=148945032)
    RMAN-06009: using target database controlfile instead of recovery catalog

    RMAN> exit

    C:\>rman target akhadar@rict nocatalog
    target database Password:

    Recovery Manager: Release 8.1.7.0.0 - Production

    RMAN-06005: connected to target database: RICT (DBID=148945032)
    RMAN-06009: using target database controlfile instead of recovery catalog

    RMAN> exit


    --Observe now as i commented out the SQLNET.AUTHENTICATION_services=NTS in SQLNET.Ora

    C:\>rman target / nocatalog

    Recovery Manager: Release 8.1.7.0.0 - Production

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-04005: error from target database: ORA-01031: insufficient privileges

    Don't worry about catalog as iam using controlfile itself as catalog for test purpose.

    So check your sqlnet.ora both on your seperate catalog database and also target database.

    u have not followed the link which i posted in other thread.When u are connecting to RMAN with a user having SYSDBA privileges u need not mention specifically as SYSDBA while connecting.

    Noteon't duplicate your questions in multiple threads.Stick to one post.As u are making other members confused with your incomplete questions.
    Last edited by akhadar; 06-11-2003 at 07:09 AM.

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by TomazZ
    Sure it is.
    You cannot connect like "user/pass@db as sysdba" without a password file.
    If you have read my post completely, i mentioned

    "Provided the user (OS) is in the ORA_DBA group & SQLNET authentication mode is NTS."

    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"

  10. #10
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Still, you cannot connect like "user/pass@db as sysdba" without a password file.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

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