Home » Infrastructure » Windows » Oracle 11g Installation Blues (Windows XP Professional)
Oracle 11g Installation Blues [message #429576] Wed, 04 November 2009 10:58 Go to next message
Messages: 2
Registered: October 2009
Junior Member

I have installed Oracle 11g on my XP OS.And I am facing the following problems

1) When i try to open the SQL Developer
(Oracle-Ora11g_home1 -> Application Development -> SQL Developer)

a)A prompt comes that asks for java.exe(enter the full path for java exe)

b) When I provide it with that c:\Program Files\Java\jre6\bin\java.exe. It says it cannot find a j2se sdk intalled in that path.

2> When I try to open the SQL Plus.
(Oracle-Ora11g_home1 -> Application Development -> SQL Plus)

a)A command prompt open up and ask for loginid and password

b)When i provide it it (the one that I had created at the time of installation) it says account has been locked

c)When I try to connect with login name SYS and the password that I had changed at the time of installation it says
connection with sys should be with SYSDBA or SYSOPER

I have no idea where I am going wrong. Please help me.

Re: Oracle 11g Installation Blues [message #429615 is a reply to message #429576] Wed, 04 November 2009 14:31 Go to previous message
Messages: 21759
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So, do as instructed! (as you aren't going to read the documentation).
- connect as SYS as SYSDBA
c:\temp>sqlplus sys/syspassword as sysdba

SQL*Plus: Release - Production on Sri Stu 4 21:27:53 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, OLAP and Data Mining options


- unlock the account which is now locked
SQL> connect mike/lion
ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.
SQL> connect sys/syspassword as sysdba

SQL> alter user mike account unlock;

User altered.

SQL> connect mike/lion

Previous Topic: Good configuration for oracle
Next Topic: batch file windows environment
Goto Forum:

Current Time: Tue Mar 21 13:00:51 CDT 2023