13 Replies Latest reply: May 9, 2009 11:48 PM by Sonic RSS

    Forgot SYSDBA username and password

    Sonic
      Dear members


      I have installed Oracle 10g Express Edition couple of months back on my machine.Now I need to install Oracle Warehouse Builder 10g release 2 for which I need to provide Oracle 10g EE SYSDBA Username and Password which I am unable to recollect now.Is there way I can findout these credentials and proceed with my OWB installation?
        • 1. Re: Forgot SYSDBA username and password
          SatishKandi
          Refer

          http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/users_secure.htm#sthref290
          • 2. Re: Forgot SYSDBA username and password
            Sonic
            When I try to connect as SYSDBA i get following error message.
            D:\Documents and Settings\BAR>sqlplus /nolog
            
            SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 8 13:55:57 2009
            
            Copyright (c) 1982, 2005, Oracle.  All rights reserved.
            
            SQL> connect /as sysdba
            ERROR:
            ORA-12560: TNS:protocol adapter error
            
            SQL> alter user system identified by manager;
            SP2-0640: Not connected
            
            
            
            SQL>
            • 3. Re: Forgot SYSDBA username and password
              SatishKandi
              You have not set the SID

              Try with

              CMD>SET ORACLE_SID=XE
              CMD>sqlplus / as sysdba

              and post the results.
              • 4. Re: Forgot SYSDBA username and password
                Madrid
                Remember that by default you can connect using the SYSDBA role because OS authentication is enabled. You don't need the SYS password to have it changed if you open an OS prompt and type:

                sqlplus / as sysdba

                SQL>

                Once connected, just issue the command above referred.


                ~ Madrid
                http://hrivera99.blogspot.com
                • 5. Re: Forgot SYSDBA username and password
                  Sonic
                  i think this time the user has been altered.Thanks satish for your input
                  D:\Documents and Settings\BAR>set ORACLE_SID=XE
                  
                  D:\Documents and Settings\BAR>sqlplus / as sysdba
                  
                  SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 8 14:03:30 2009
                  
                  Copyright (c) 1982, 2005, Oracle.  All rights reserved.
                  
                  
                  Connected to:
                  Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
                  
                  SQL> alter user system identified by manager;
                  
                  User altered.
                  
                  SQL>
                  • 6. Re: Forgot SYSDBA username and password
                    Sonic
                    After altering the user I try to go ahead with my OWB Release 2 installation.But, I get an error with message Network Adapter Could Not Establish Connection.What could be wrong now?

                    The installation screens are posted here
                    http://www.oracle.com/technology/obe/10gr2_owb/owb10gr2_gs/owb/lesson1/start01.htm
                    • 7. Re: Forgot SYSDBA username and password
                      SatishKandi
                      Can you post your listener.ora and tnsnames.ora?
                      • 8. Re: Forgot SYSDBA username and password
                        Sonic
                        Contents of listener.ora
                        SID_LIST_LISTENER =
                          (SID_LIST =
                            (SID_DESC =
                              (SID_NAME = PLSExtProc)
                              (ORACLE_HOME = D:\oraclexe\app\oracle\product\10.2.0\server)
                              (PROGRAM = extproc)
                            )
                            (SID_DESC =
                              (SID_NAME = CLRExtProc)
                              (ORACLE_HOME = D:\oraclexe\app\oracle\product\10.2.0\server)
                              (PROGRAM = extproc)
                            )
                          )
                        
                        LISTENER =
                          (DESCRIPTION_LIST =
                            (DESCRIPTION =
                              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
                              (ADDRESS = (PROTOCOL = TCP)(HOST = anvesh)(PORT = 1521))
                            )
                          )
                        
                        DEFAULT_SERVICE_LISTENER = (XE)
                        and tnsnames.ora
                        XE =
                          (DESCRIPTION =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = anvesh)(PORT = 1521))
                            (CONNECT_DATA =
                              (SERVER = DEDICATED)
                              (SERVICE_NAME = XE)
                            )
                          )
                          
                          EXTPROC_CONNECTION_DATA =
                          (DESCRIPTION =
                            (ADDRESS_LIST =
                              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
                            )
                            (CONNECT_DATA =
                              (SID = PLSExtProc)
                              (PRESENTATION = RO)
                            )
                          )
                        
                        ORACLR_CONNECTION_DATA = 
                          (DESCRIPTION = 
                            (ADDRESS_LIST = 
                              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) 
                            ) 
                            (CONNECT_DATA = 
                              (SID = CLRExtProc) 
                              (PRESENTATION = RO) 
                            ) 
                          ) 
                        APPDEV = 
                          (DESCRIPTION = 
                            (ADDRESS_LIST = 
                              (ADDRESS = (PROTOCOL = TCP)(HOST = 70.63.134.203)(PORT = 1521)) 
                            ) 
                            (CONNECT_DATA = 
                              (SERVICE_NAME = APPDEV) 
                            ) 
                          )
                        
                        
                        VISLINUX = 
                          (DESCRIPTION = 
                            (ADDRESS_LIST = 
                              (ADDRESS = (PROTOCOL = TCP)(HOST = 75.182.95.214)(PORT = 1521)) 
                            ) 
                            (CONNECT_DATA = 
                              (SERVICE_NAME = VISLINUX) 
                            ) 
                          ) 
                          
                        • 9. Re: Forgot SYSDBA username and password
                          SatishKandi
                          Can you post output of

                          CMD> lsnrctl status
                          CMD> lsnrctl services
                          CMD> tnsping XE (with the assumption that you are trying to connect to XE database with this installation for repository)
                          • 10. Re: Forgot SYSDBA username and password
                            Sonic
                            D:\Documents and Settings\BAR>lsnrctl status
                            
                            LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 08-MAY-2009 14:30
                            :06
                            
                            Copyright (c) 1991, 2005, Oracle.  All rights reserved.
                            
                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                            STATUS of the LISTENER
                            ------------------------
                            Alias                     LISTENER
                            Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
                            ction
                            Start Date                08-MAY-2009 11:04:24
                            Uptime                    0 days 3 hr. 25 min. 43 sec
                            Trace Level               off
                            Security                  ON: Local OS Authentication
                            SNMP                      OFF
                            Default Service           XE
                            Listener Parameter File   D:\oraclexe\app\oracle\product\10.2.0\server\network\a
                            dmin\listener.ora
                            Listener Log File         D:\oraclexe\app\oracle\product\10.2.0\server\network\l
                            og\listener.log
                            Listening Endpoints Summary...
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=anvesh)(PORT=1521)))
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=anvesh)(PORT=8080))(Presentation=HTT
                            P)(Session=RAW))
                            Services Summary...
                            Service "CLRExtProc" has 1 instance(s).
                              Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                            Service "PLSExtProc" has 1 instance(s).
                              Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                            Service "XEXDB" has 1 instance(s).
                              Instance "xe", status READY, has 1 handler(s) for this service...
                            Service "XE_XPT" has 1 instance(s).
                              Instance "xe", status READY, has 1 handler(s) for this service...
                            Service "xe" has 1 instance(s).
                              Instance "xe", status READY, has 1 handler(s) for this service...
                            The command completed successfully
                            
                            D:\Documents and Settings\BAR>lsnrctl services
                            
                            LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 08-MAY-2009 14:30
                            :26
                            
                            Copyright (c) 1991, 2005, Oracle.  All rights reserved.
                            
                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                            Services Summary...
                            Service "CLRExtProc" has 1 instance(s).
                              Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                                Handler(s):
                                  "DEDICATED" established:0 refused:0
                                     LOCAL SERVER
                            Service "PLSExtProc" has 1 instance(s).
                              Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                                Handler(s):
                                  "DEDICATED" established:0 refused:0
                                     LOCAL SERVER
                            Service "XEXDB" has 1 instance(s).
                              Instance "xe", status READY, has 1 handler(s) for this service...
                                Handler(s):
                                  "D000" established:35 refused:0 current:35 max:1002 state:ready
                                     DISPATCHER <machine: ANVESH, pid: 2580>
                                     (ADDRESS=(PROTOCOL=tcp)(HOST=anvesh)(PORT=1028))
                            Service "XE_XPT" has 1 instance(s).
                              Instance "xe", status READY, has 1 handler(s) for this service...
                                Handler(s):
                                  "DEDICATED" established:42 refused:0 state:ready
                                     LOCAL SERVER
                            Service "xe" has 1 instance(s).
                              Instance "xe", status READY, has 1 handler(s) for this service...
                                Handler(s):
                                  "DEDICATED" established:42 refused:0 state:ready
                                     LOCAL SERVER
                            The command completed successfully
                            
                            D:\Documents and Settings\BAR>tnsping XE
                            
                            TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 08-MAY-2
                            009 14:30:38
                            
                            Copyright (c) 1997, 2005, Oracle.  All rights reserved.
                            
                            Used parameter files:
                            C:\OraHome_2\network\admin\sqlnet.ora
                            
                            
                            Used TNSNAMES adapter to resolve the alias
                            Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = anvesh)(
                            PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))) EXTPROC
                            _CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KE
                            Y = EXTPROC_FOR_XE)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) )
                            )
                            TNS-12533: TNS:illegal ADDRESS parameters
                            
                            D:\Documents and Settings\BAR>
                            • 11. Re: Forgot SYSDBA username and password
                              Sonic
                              yes I am trying to connect to XE for the installation of my Repository
                              • 12. Re: Forgot SYSDBA username and password
                                SatishKandi
                                XE =
                                  (DESCRIPTION =
                                    (ADDRESS = (PROTOCOL = TCP)(HOST = anvesh)(PORT = 1521))
                                    (CONNECT_DATA =
                                      (SERVER = DEDICATED)
                                      (SERVICE_NAME = XE)
                                    )
                                  )
                                  
                                  EXTPROC_CONNECTION_DATA =
                                  (DESCRIPTION =
                                    (ADDRESS_LIST =
                                      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
                                    )
                                    (CONNECT_DATA =
                                      (SID = PLSExtProc)
                                      (PRESENTATION = RO)
                                    )
                                  )
                                The TNSNAMEs.ORA has blank spaces before EXTPROC_CONNECTION_DATA. Remove them, save the file and try again.
                                • 13. Re: Forgot SYSDBA username and password
                                  Sonic
                                  yes I have removed the space and saved the file too.But,I was still getting the error as Account is Locked.So i had run the following query
                                  SQL> alter user system identified by manager account unlock;
                                  
                                  User altered.
                                  
                                  SQL> alter user sys identified by manager account unlock;
                                  
                                  User altered.
                                  Now everything seems to be working well with my installation.Thankyou for your input.