OraFAQ Forum: Windows » Oracle 11g Installation Blues

Home » Infrastructure » Windows » Oracle 11g Installation Blues (Windows XP Professional)

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

Oracle 11g Installation Blues [message #429576]

Wed, 04 November 2009 10:58

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

Report message to a moderator

Re: Oracle 11g Installation Blues [message #429615 is a reply to message #429576]

Wed, 04 November 2009 14:31

Littlefoot
Messages: 21823
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>

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:37:06 CST 2025