Oracle 11gR2

call_krushna · 07-27-2011, 09:38 AM

Hi everbody,

I have installed Oracle 11gR2 .Its succefully installed.But I am not able to login.I have set password for the defalut db users.None of the users are working .Anybody know,What is default username and password for oracle 11gR2 and how to change password.

application Oracle11gR2

Os RHEL 5.5 (64bit entreprise)

Regards
Krushna

radoulov · 07-27-2011, 10:26 AM

Set the environment (ORACLE_HOME, ORACLE_SID, PATH), then run:

Code:

sqlplus / as sysdba

Then you can change the passwords with:

Code:

alter user <username> identified by '<password>';

You should also check the account status (and unlock them if needed).

call_krushna · 07-28-2011, 07:33 AM

Quote:

Originally Posted by radoulov

Set the environment (ORACLE_HOME, ORACLE_SID, PATH), then run:

Code:

sqlplus / as sysdba

Then you can change the passwords with:

Code:

alter user <username> identified by '<password>';

You should also check the account status (and unlock them if needed).

Thanks for the info.

How to start the oracle service .Oracle is not working after rebooting the pc.

OS :- Redhat entreprise 5.6

radoulov · 07-28-2011, 07:45 AM

Code:

sqlplus / as sysdba <<< startup

Regarding the service startup/shutdown automation in 11gR2 you could use Oracle restart. If you didn't install the GI (Grid Infrastructure) you could try to configure dbstart/dbshut (if they are still present

). Check Tim Hall site (look at the bottom of the page for the recent versions) and the official Oracle documentation for further details.