OraFAQ Forum: Windows » How to get the password post installation of Oracle

Home » Infrastructure » Windows » How to get the password post installation of Oracle (Oracle 10g database, 10.2.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get the password post installation of Oracle [message #514098]

Fri, 01 July 2011 08:01

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

Report message to a moderator

Re: How to get the password post installation of Oracle [message #514100 is a reply to message #514098]

Fri, 01 July 2011 08:11

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to get the password post installation of Oracle [message #514102 is a reply to message #514100]

Fri, 01 July 2011 08:23

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".

Report message to a moderator

Re: How to get the password post installation of Oracle [message #514104 is a reply to message #514102]

Fri, 01 July 2011 08:41

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do not use this connection for normal operations, it is only for maintenance (startup/shutdown/recovery) or urgency.

Regards
Michel

Report message to a moderator

Re: How to get the password post installation of Oracle [message #514105 is a reply to message #514104]

Fri, 01 July 2011 08:48

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

Report message to a moderator

Re: How to get the password post installation of Oracle [message #569106 is a reply to message #514098]

Sat, 20 October 2012 08:21

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.

Report message to a moderator

Re: How to get the password post installation of Oracle [message #569107 is a reply to message #569106]

Sat, 20 October 2012 08:48

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

alter user xxx account unlock;

Report message to a moderator

Re: How to get the password post installation of Oracle [message #569112 is a reply to message #569106]

Sat, 20 October 2012 10:10

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ask your DBA to unlock it (using Thomas statement).

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 17:09:08 CST 2025