Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Closed TopicStart new topic
> Forgot password
warehouser
post Aug 27 2007, 05:01 PM
Post #1


Advanced Member
***

Group: Members
Posts: 42
Joined: 3-April 06
Member No.: 3,989



I have an Oracle 9i developer database on my Windows workstation. I havent used it in a couple weeks and forgot my Sysdba login password. Please advise how I can reset it or get into the database?
Go to the top of the page
 
+Quote Post
Steve
post Aug 27 2007, 05:22 PM
Post #2


Advanced Member
***

Group: Members
Posts: 618
Joined: 22-January 06
From: Virginia Beach, VA
Member No.: 3,560



If you log in as a user with the ORA_DBA group, you will be able to get into your instance without a password. Usually the user on your machine that installed Oracle will work.

Just do this at a command prompt (after setting ORACLE_HOME and ORACLE_SID)

sqlplus "/ as sysdba"

Once you've done that, you can "alter user sys identified by xxxxx" to change the SYS password (replace xxxxx with the new one) and use the orapwd utility at the command line to change the password file.

http://www.dba-oracle.com/concepts/setting_roles.htm

"If you intend to allow remote users to connect internal, you need to set the REMOTE_LOGIN_PASSWORDFILE option in your database parameter file to either EXCLUSIVE or SHARED. The user will then connect in server manager with the AS SYSDBA or AS SYSOPER clause at the end of the CONNECT command (CONNECT SYS AS SYSDBA). The privileges assigned to SYSDBA correspond to those for OSDBA. The privileges assigned to SYSOPER correspond to OSOPER. The operating system verifies the password provided using an external operating system file. This external file is generated using the ORAPWD utility. When the password for the INTERNAL or SYS accounts are changed with the ALTER USER command, the changes are mapped to the operating system password file. "


--------------------
Steve Karam
Sr. Consultant - Burleson Consulting
Oracle 10g Certified Master / Oracle ACE
http://www.OracleAlchemist.com
steve@orcldba.com
Go to the top of the page
 
+Quote Post
warehouser
post Aug 27 2007, 06:10 PM
Post #3


Advanced Member
***

Group: Members
Posts: 42
Joined: 3-April 06
Member No.: 3,989



Thanks, I just have to do this using Dos command line:

sqlplus "/ as sysdba"

then do this:
alter user sys identified by mynewpassword

Then how do I get the orapwd file or do I put this in the Dos command line?
orapwd=%ORACLE_HOME%\DATABASE\pwd%oracle-sid%.ora password=%sys-password%

I do not intend to allow remote users to connect internal to my workstation development database.
Go to the top of the page
 
+Quote Post
dave
post Aug 28 2007, 02:49 AM
Post #4


Advanced Member
***

Group: Members
Posts: 5,206
Joined: 8-October 04
Member No.: 785



then you dont need a password file, but anyway the alter system command will update the password file
Go to the top of the page
 
+Quote Post
sowmyamanmathan
post Feb 2 2011, 11:11 AM
Post #5


Newbie
*

Group: Members
Posts: 1
Joined: 2-February 11
Member No.: 44,637



Hi
I am using oracle 9i sql plus.I forgot my username,password.When I tried you are suggestion...
I entered sqlplus "/ as sysdba"....bt it asks me to enter a password ...what shld i do now?
Go to the top of the page
 
+Quote Post
SteveC
post Feb 2 2011, 11:21 AM
Post #6


Advanced Member
***

Group: Members
Posts: 2,835
Joined: 11-March 08
Member No.: 18,933



Are you logged in as a user in the ORADBA group?

QUOTE
If you log in as a user with the ORA_DBA group, you will be able to get into your instance without a password. Usually the user on your machine that installed Oracle will work.

Just do this at a command prompt (after setting ORACLE_HOME and ORACLE_SID)

sqlplus "/ as sysdba"

Once you've done that, you can "alter user sys identified by xxxxx" to change the SYS password (replace xxxxx with the new one) and use the orapwd utility at the command line to change the password file.

http://www.dba-oracle.com/concepts/setting_roles.htm
Go to the top of the page
 
+Quote Post
burleson
post Feb 3 2011, 03:34 PM
Post #7


Advanced Member
***

Group: Members
Posts: 11,425
Joined: 26-January 04
Member No.: 13



Hi Sowmyamanmathan,

>> what shld i do now?

I could tell you how to hack in, but that would not be responsible to share that info.

You need to open an SR with MOSC. Oracle will verify that you own the database and tell you how:

http://support.oracle.com

Good Luck!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 28th August 2014 - 10:25 PM