Home » Infrastructure » Windows » How to get the password post installation of Oracle (Oracle 10g database, 10.2.0.4.0)
How to get the password post installation of Oracle [message #514098] Fri, 01 July 2011 08:01 Go to next message
atgramesh
Messages: 23
Registered: January 2011
Junior Member
Hi All,

Hope this mail finds you well.

I have installed Oracle 10g on Windows 7 64 bit today by own from the following link with data.

http://www.oracle.com/technetwork/database/10204-winx64-vista-win2k8-082253.html

1. At the start of my installation

Global Database Name : oracl
Password : my own password

2. At last i got the message "The installation of Oracle Database 10g was successful."

I have tried logon with

User Name as scott with tiger with Host String as oracl
User Name as scott with tiger
User Name as system with manager with Host String as oracl
User Name as system with manager

But i am unable to login to SQL. Please guide me.

Thanks in advance.

Note: In between installation, i have not set any password.

Warm Regards,
Ramesh V
Re: How to get the password post installation of Oracle [message #514100 is a reply to message #514098] Fri, 01 July 2011 08:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On the server with the account that installs the product, use sqlplus with connection "/ as sysdba" and change the passwords.

Regards
Michel
Re: How to get the password post installation of Oracle [message #514102 is a reply to message #514100] Fri, 01 July 2011 08:23 Go to previous messageGo to next message
atgramesh
Messages: 23
Registered: January 2011
Junior Member
Thanks Michel for your prompt reply. Smile

I have logged in successfully to SQL through RUN application as "sqlplus / as sysdba".
Re: How to get the password post installation of Oracle [message #514104 is a reply to message #514102] Fri, 01 July 2011 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not use this connection for normal operations, it is only for maintenance (startup/shutdown/recovery) or urgency.

Regards
Michel
Re: How to get the password post installation of Oracle [message #514105 is a reply to message #514104] Fri, 01 July 2011 08:48 Go to previous messageGo to next message
atgramesh
Messages: 23
Registered: January 2011
Junior Member
Ok. I do remember as this is a system user. After login, i have created a user in my name. Smile
Re: How to get the password post installation of Oracle [message #569106 is a reply to message #514098] Sat, 20 October 2012 08:21 Go to previous messageGo to next message
ravi1251991
Messages: 1
Registered: October 2012
Location: america
Junior Member

I have following error to login in sql plus

user is locked.

so what can i do to unlock the user.



Re: How to get the password post installation of Oracle [message #569107 is a reply to message #569106] Sat, 20 October 2012 08:48 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
alter user xxx account unlock;
Re: How to get the password post installation of Oracle [message #569112 is a reply to message #569106] Sat, 20 October 2012 10:10 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your DBA to unlock it (using Thomas statement).

Regards
Michel
Previous Topic: Unable to delete SMON trace file
Next Topic: Oracle Service doesn't start
Goto Forum:
  


Current Time: Thu Mar 28 03:35:47 CDT 2024