Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    1,245

    Unanswered: Connect as sysdba (Oracle 8.1.7.4)

    Server:
    Oracle 8.1.7.4
    AIX 5.1

    Client:
    Windows XP (SP2)
    Oracle 10gR2 client install

    I'm trying to figure if (and how) I can connect to my Oracle database(s) as sysdba from my workstation.

    Currently when I try connecting as:
    connect sys/password@instance as sysdba

    I get an error message indicating insufficient privileges.

    I get a similar error message when attempting to connect using:
    connect system/password@instance as sysoper

    I suspect this is because my Windows domain account is not a member of the dba group on the AIX server. When I SSH in to the Unix server, I su over to a privileged account and connect using:
    conn / as sysdba

    As things stand, this (SSH into the Unix server) is the only way I have to connect to the database as sysdba. If it were the only server, it would not be a big deal, but there are about 10 servers that are similarly configured.

    Before I go attempting to make a bunch of changes, I wanted to double check some things:
    • The AIX server is not domain aware; does that make this effort futile?
    • The AIX server will not likely become domain aware anytime in the near future, could I use a local account on my PC that is constructed identically to the privileged account on the AIX box (same name, same password)?
    • What should the value of SQLNET.AUTHENTICATION_SERVICES be in SQLNET.ORA? Should it be (ALL)?
    • Is there some other security mechanism at work here (eg, Unix permissions on the server restricted to a privileged account on the Unix server?)


    I don't think that I will be permitted to install Oracle Advanced Security; I'm not sure I know enough about it at this point to assure that it would resolve the issue.

    Sorry for the dumb questions; I have done all of this in an all-Windows environment, but this is my first heavy exposure to Oracle on a Unix server.

    Regards,

    hmscott

    Edit to add: I am currently going through the checklist in Metalink 69642.1. Any hints or thoughts, however, would be appreciated.
    Last edited by hmscott; 08-14-07 at 22:21.
    Have you hugged your backup today?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    [/code]

    SQL> show parameter remote

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    remote_archive_enable string true
    remote_dependencies_mode string TIMESTAMP
    remote_listener string
    remote_login_passwordfile string EXCLUSIVE
    remote_os_authent boolean FALSE
    remote_os_roles boolean FALSE
    SQL>
    [/code]
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Does Enterprise Manager have any problems connecting as SYSDBA? If it can, then you just need to find the right incantation. If not, it is possibly a server thing. Any test servers at all you can play with?

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by anacedent
    [/code]

    SQL> show parameter remote

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    remote_archive_enable string true
    remote_dependencies_mode string TIMESTAMP
    remote_listener string
    remote_login_passwordfile string EXCLUSIVE
    remote_os_authent boolean FALSE
    remote_os_roles boolean FALSE
    SQL>
    [/code]
    That was it. No entry for remote_login_passwordfile.

    Unfortunately, that requires a restart, so it's going to have to wait on a lot of the databases.

    Thank you anacedent.

    Regards,

    Hugh
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •