This discussion is archived
1 2 Previous Next 26 Replies Latest reply: Jan 23, 2013 11:11 PM by piku RSS

can not log into sys as sysdba

piku Newbie
Currently Being Moderated
continuation of

Can not able to log in into sys as sysdba

As by mistake I have marked that answered so Have open a new thread.
Pls help

thanks in advance
  • 1. Re: can not log into sys as sysdba
    986120 Explorer
    Currently Being Moderated
    Login as oracle owner

    $ export ORACLE_BASE=<oracle_base>
    $ export ORACLE_HOME=<oracle_home>
    $ export ORACLE_SID=skydb


    Now start sqlplus. Hope it will work.
  • 2. Re: can not log into sys as sysdba
    Sunny kichloo Expert
    Currently Being Moderated
    You should close that thread also
  • 3. Re: can not log into sys as sysdba
    piku Newbie
    Currently Being Moderated
    @Sunny

    How to close.but its not been resolved[answered] by anybody.
  • 4. Re: can not log into sys as sysdba
    piku Newbie
    Currently Being Moderated
    @Bala

    No .Its still not working. :(
  • 5. Re: can not log into sys as sysdba
    Azar Pro
    Currently Being Moderated
    what is the error coming, and can you please paste the command of how did you set the oracle home path?
  • 6. Re: can not log into sys as sysdba
    Niket Kumar Pro
    Currently Being Moderated
    piku...your database is not in running state,,,,

    ps -ef|grep pmon

    it will show oracle processes......and no oracle process is running on it.

    first check permissions on oracle directories....after that start oracle database check on google how to start oracle database....
    set parameter as suggested by bala before starting off database.....
  • 7. Re: can not log into sys as sysdba
    986120 Explorer
    Currently Being Moderated
    Try this,

    $ sqlplus "/ as system"

    sql> passwd sys

    now create new password for sys.

    --
    Bala.
  • 8. Re: can not log into sys as sysdba
    piku Newbie
    Currently Being Moderated
    @bala

    when I am giving below command its showing these
    SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 23 14:59:47 2013
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    
    SQL*Plus: Release 11.2.0.1.0 Production
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.
    
    Usage 1: sqlplus -H | -V
    
        -H             Displays the SQL*Plus version and the
                       usage help.
        -V             Displays the SQL*Plus version.
    
    Usage 2: sqlplus [ [<option>] [{logon | /nolog}] [<start>] ]
    
      <option> is: [-C <version>] [-L] [-M "<options>"] [-R <level>] [-S]
    
        -C <version>   Sets the compatibility of affected commands to the
                       version specified by <version>.  The version has
                       the form "x.y[.z]".  For example, -C 10.2.0
        -L             Attempts to log on just once, instead of
                       reprompting on error.
        -M "<options>" Sets automatic HTML markup of output.  The options
                       have the form:
                       HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]
                       [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
        -R <level>     Sets restricted mode to disable SQL*Plus commands
                       that interact with the file system.  The level can
                       be 1, 2 or 3.  The most restrictive is -R 3 which
                       disables all user commands interacting with the
                       file system.
        -S             Sets silent mode which suppresses the display of
                       the SQL*Plus banner, prompts, and echoing of
                       commands.
    
      <logon> is: {<username>[/<password>][@<connect_identifier>] | / }
                  [AS {SYSDBA | SYSOPER | SYSASM}] [EDITION=value]
    
        Specifies the database account username, password and connect
        identifier for the database connection.  Without a connect
        identifier, SQL*Plus connects to the default database.
    
        The AS SYSDBA, AS SYSOPER and AS SYSASM  options are database
        administration privileges.
    
        <connect_identifier> can be in the form of Net Service Name
        or Easy Connect.
    
          @[<net_service_name> | [//]Host[:Port]/<service_name>]
    
            <net_service_name> is a simple name for a service that resolves
            to a connect descriptor.
    
            Example: Connect to database using Net Service Name and the
                     database net service name is ORCL.
    
               sqlplus myusername/mypassword@ORCL
  • 9. Re: can not log into sys as sysdba
    piku Newbie
    Currently Being Moderated
    @Azar

    Oracle Home and Oracle Base are already set. I am just set the Oracle_SID.
    I have also checked the Oracle Home and Base directories by echo command.All are ok.

    Thanks
  • 10. Re: can not log into sys as sysdba
    Sunny kichloo Expert
    Currently Being Moderated
    If you want to change password of SYS use this
    [oracle@2XSSFD1 ~]$ sqlplus /nolog
    
    SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 23 10:08:45 2013
    
    Copyright (c) 1982, 2007, Oracle.  All rights reserved.
    
    SQL> connect / as sysdba
    Connected.
    SQL>
    Once connected you can change password by using below mentioned command.

    SQL>alter user sys identified by new_password;

    Also this link will help

    http://rolfje.wordpress.com/2007/01/16/lost-oracle-sys-and-system-password/
  • 11. Re: can not log into sys as sysdba
    piku Newbie
    Currently Being Moderated
    Dear sunny

    using
    sqlplus /nolog
    i can able to log into the sql prompt.but can not connect to sysdba.
    otherwise i know the alter tricks.
    do you is there any other way please.

    thanks for your reply.
  • 12. Re: can not log into sys as sysdba
    986120 Explorer
    Currently Being Moderated
    @Sunny

    He is telling that "sys" is not connected. Then how it is possible.

    @piku

    try this

    sql> sqlplus system/<system passwd>@skydb

    then alter sys user by what Sunny told.
  • 13. Re: can not log into sys as sysdba
    Sunny kichloo Expert
    Currently Being Moderated
    You can create new password file if possible.

    Look into the second method from the link that i have posted above.
  • 14. Re: can not log into sys as sysdba
    Aman.... Oracle ACE
    Currently Being Moderated
    piku wrote:
    Dear sunny

    using
    sqlplus /nolog
    i can able to log into the sql prompt.but can not connect to sysdba.
    otherwise i know the alter tricks.
    do you is there any other way please.
    What's the error that's coming?

    Show us the output of doing
    sql> connect / as sysdba
    Aman....
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points