1 2 Previous Next 26 Replies Latest reply: Jan 24, 2013 1:11 AM by piku RSS

    can not log into sys as sysdba

    piku
      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
          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
            You should close that thread also
            • 3. Re: can not log into sys as sysdba
              piku
              @Sunny

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

                No .Its still not working. :(
                • 5. Re: can not log into sys as sysdba
                  Azar
                  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
                    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
                      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
                        @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
                          @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
                            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
                              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
                                @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
                                  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....
                                    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