connect as sysdba
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: connect as sysdba

  1. #1
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32

    connect as sysdba

    Can any senior member help me:
    1) I connected from my workstation to oracle database usiing sqlplus window by giving /nolog@utl1 as user value which gave the sql> as shown below
    2) When I am connecting to utl1 database as sysdba as shown below I am getting an error, but when I am connecting as sys it is connecting without any problem. Why is it so?
    NOTE: It can be seen that I set the timing to make it evident that the commands have been issued immediately one after other and no alterations were made in between
    When I am trying to connect from sqlplus window I am getting the error as shown below:

    SQL*Plus: Release 8.1.7.0.0 - Production on Tue Oct 29 14:19:18 2002

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

    SQL>
    SQL> set time on
    14:19:24 SQL> connect sys/sysau19@utl1 as sysdba
    ERROR:
    ORA-01017: invalid username/password; logon denied


    14:19:39 SQL> connect sys/sysau19@utl1
    Connected.
    14:19:52 SQL> show user
    USER is "SYS"
    14:19:54 SQL>

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    what is setting of remote_login_passwordfile?? Set is to EXCLUSIVE and make a new password file. It will work...

  3. #3
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32

    connect as sysdba

    Sameer,

    Help from you please.
    value of remote_login_password_file=none. There is no password file created for this database. I have given below output when I directly logon to the Unix Box and I am able to logon as seen below

    au19ora:UTL1> svrmgrl

    Oracle Server Manager Release 3.0.5.0.0 - Production

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

    Oracle8 Enterprise Edition Release 8.0.5.2.2 - Production
    With the Partitioning and Objects options
    PL/SQL Release 8.0.5.2.1 - Production

    SVRMGR> connect sys/sysau19 as sysdba
    Connected.
    SVRMGR> connect / as sysdba
    Connected.

  4. #4
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    If you work on server using server manager it will work.. but from client side it won't...

    See what I have done ... do as following...

    SQL> connect sys/pass@orcl as sysdba
    ERROR:
    ORA-01017: invalid username/password; logon denied
    SQL> connect sys/pass@orcl
    Connect durchgeführt.
    SQL>
    SQL> show parameter remote
    NAME TYPE VALUE
    ------------------------------------ ------- -------------------
    remote_dependencies_mode string TIMESTAMP
    remote_login_passwordfile string NONE
    remote_os_authent boolean FALSE
    remote_os_roles boolean FALSE
    SQL>
    SQL>disconnect
    Verbindung zu Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option
    JServer Release 8.1.7.0.1 - Production beendet

    shutdown database, edit init.ora file set remote_login_passwordfile = EXCLUSIVE. Create new password file using orapwd .. If old one exists then rename it..

    orapwd file=orapwORCL entries=10 password=pass

    start database again..

    SQL> connect sys/pass@orcl as sysdba
    Connect durchgeführt.
    SQL>
    SQL> show user
    USER ist "SYS"
    SQL> show parameter remote
    NAME TYPE VALUE
    ------------------------------------ ------- -------------------
    remote_dependencies_mode string TIMESTAMP
    remote_login_passwordfile string EXCLUSIVE
    remote_os_authent boolean FALSE
    remote_os_roles boolean FALSE
    SQL>disconnect
    Verbindung zu Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.1 - Production beendet

  5. #5
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32
    u mean to say that if we want to connect to a database from a client as sysdba we should be compulsorily using password file. In such cases shall the password file be on the client also or not

  6. #6
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Originally posted by tharakab
    u mean to say that if we want to connect to a database from a client as sysdba we should be compulsorily using password file. In such cases shall the password file be on the client also or not
    For remote authentication you must have password file and password file is always on the server and not at clientside

  7. #7
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32
    Sameer,

    I am aware that password file should be on the server. But I read in the documentation that u need to have init.ora and password file on the client side, if u have to remotely startup/shutdown database. with that in the background I have asked if the pwdfile is to be on the client (for connecting as sysdba also). Hence clarify the same

    Thank you for the patiently answring my qns.

    Sameer I have a similar doubt which I am posting in a new thread. Can u also pl. answer it.

    Thanks in advance

  8. #8
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Where did you read.. To shutdown database you should have init.ora and password file at clienside also.. This is new to me.. what is the logic of having init.ora at client side..

    It must be on server side only.. First try what I have suggested then you will come to know if it requres at client side or not...

  9. #9
    Join Date
    Jan 2001
    Posts
    2,828
    Originally posted by Sameer
    Where did you read.. To shutdown database you should have init.ora and password file at clienside also.. This is new to me.. what is the logic of having init.ora at client side..

    It must be on server side only.. First try what I have suggested then you will come to know if it requres at client side or not...
    well some database tools like oracle enterprise manager require that you copy the init.ora file from the server to the client to to shutdown or start up of the database..

    regards
    Hrishy

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