Connection to remote server as sysdba is not possible
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Connection to remote server as sysdba is not possible

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Connection to remote server as sysdba is not possible

    i am trying to connect to remote server

    SQL> connect sys/change_on_install@wizerp
    Connected.

    SQL> connect sys/change_on_install@wizerp as sysdba
    ERROR:
    ORA-01017: invalid username/password; logon denied

    Warning: You are no longer connected to ORACLE.

    Can u guide me what could be the reason for not connecting as sysdba but it is connecting successfuly without sysdba

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what version are you running

  3. #3
    Join Date
    Sep 2006
    Posts
    114
    Quote Originally Posted by davey23uk
    what version are you running
    8.1.7 at client from where want to connect to remote server which is also at 8.1.7

  4. #4
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    hi...found in google...i dont have metalink

    Symptom:
    When attempting to connect to Oracle the following error is returned:

    ORA-01017: invalid username/password; login denied

    Possible Causes and Remedies:
    Normally this error indicates that either the username is not a recognised username or that the password is incorrect.

    If this error is encountered when no username or password have been specified (i.e. when trying to use operating system authentication) then operating system authentication may not have been set-up correctly. In this case:

    Consult the notes for ORA-01004: default username feature not supported.

    The user is not set-up to use operating system authentication.

    Check that the prefix used when defining the Oracle account is the same as that specified by ‘OS_AUTHENT_PREFIX’ in the init-ora file. The default is ‘OPS$’.

    Check the value of the registry key ‘OSAUTH_PREFIX_DOMAIN’. In Oracle 7 this is located at ‘HKEY_LOCAL_MACHINE\ SOFTWARE\ ORACLE’, and for Oracle 8 at ‘HKEY_LOCAL_MACHINE\ SOFTWARE\ ORACLE\ HOMEn’. If this parameter does not exist in the registry the default is ‘FALSE’ in Oracle prior to 8.1.x, from 8.1.x onwards the deafult is ‘TRUE’. If set ‘TRUE’ then ensure that the user name defined using Oracle security manager is of the form ‘OPS$\’. If the registry key is not set then it should be of the form ‘OPS$’. If the key ‘OSAUTH_PREFIX_DOMAIN’ does not exist and you wish to create it, it should be created of type ‘REG_EXPAND_SZ’.

    Check that the initialisation parameter ‘REMOTE_OS_AUTHET’ has been explicity set ‘TRUE’.

    Less likely to be a cause, but check also that the server and client are both running the same version of Oracle.

    Some tools do not support the use of operating system authentication. This includes the Oracle GUI tools. If a connection can be made using operating system authentication with the command line server manager (svrmgr30) then it is likely to be that the tool does not support it. Some possibilities to try (none of these are guaranteed to work, but each has been found to work with some tools):

    enter ‘@’ as the username.

    enter ‘/’ as the username and do not provide a password. Some applications (possibly depending on the version of Oracle connecting to) may require a space before and after the slash.

    enter ‘/@’ as the username and do not provide a password.

    If this error is encountered when a username and/or password have been specified then the cause is likely to be one of the following:

    Check that an Oracle account has been created for the specified username.

    Check that the Oracle account is not ‘OPS$...’. If it is then Oracle is using operating system authentication for the account. Try logging in specifying no username or password. In this case the NT account name must be the same as the Oracle account name (less the ‘OPS$’).

    If the Oracle account exists and the account is not named 'OPS$...’ then the password must be incorrect.

    If this error is encountered whilst trying to connect to Oracle as SYSOPER (but connecting as NORMAL works fine) then the account lacks the SYSOPER privilege. To obtain SYSOPER privilege run Oracle security manager and grant the system privilege SYSOPER to the Oracle account. Note:

    The database must not be running in parallel server mode and the password file must not be shared.

    If the database is running in parallel server mode or the password file is shared then only SYS or INTERNAL can have SYSOPER privilege.
    Behind The Success And Failure Of A Man Is A Woman

  5. #5
    Join Date
    Sep 2006
    Posts
    114
    Dear Sir,
    we are not using os authentication
    i still have not found the solution with ur post
    and perhaps i didn't clear about my query

    My Query Was

    SQL> connect sys/change_on_install@wizerp as sysdba
    ERROR:
    ORA-01017: invalid username/password; logon denied

    Warning: You are no longer connected to ORACLE.

    SQL> conn sys/change_on_install@wizerp
    Connected.


    Why connection sys as sysdba is not possible?
    this is query i put on forum
    Can u guide me in this regard?
    i hope u won't mind it and help me

  6. #6
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72

    Wink

    Hi,
    Are u using password file? login as sys and try this 'Grant sysdba to sys;'
    Also run this query select * from v$pwfile_users. Then try to login as sys as sysdba

  7. #7
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    And assuming that you are using a password file; what is REMOTE_LOGIN_PASSWORDFILE set to on the database where you are trying to connect?
    Assistance is Futile...

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