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
singhshashi05@gmail.com
Messages: 2
Registered: October 2009
Junior Member
Hello,

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.


Thanks,
OracleQuest
Re: Oracle 11g Installation Blues [message #429615 is a reply to message #429576] Wed, 04 November 2009 14:31 Go to previous message
Littlefoot
Messages: 21806
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 10.2.0.1.0 - 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 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

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


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

SQL> alter user mike account unlock;

User altered.

SQL> connect mike/lion
Connected.

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


Current Time: Thu Mar 28 05:04:42 CDT 2024