OraFAQ Forum: Server Administration » Re: Oracle Personal Edition 8i startup password problem

Home » RDBMS Server » Server Administration » Re: Oracle Personal Edition 8i startup password problem

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

Re: Oracle Personal Edition 8i startup password problem [message #51012]

Fri, 19 April 2002 20:23

kamal
Messages: 12
Registered: February 2002

Junior Member

Hi all
I got the same problem .i had used all password which is define oracle documentation but nothing happend.

Report message to a moderator

Re: Oracle Personal Edition 8i startup password problem [message #51014 is a reply to message #51012]

Sat, 20 April 2002 03:31

rita
Messages: 41
Registered: April 1998

Member

If you are using 8.1.6 version then there is no password for internal user. try that. it should work.

I hope this helps you!!!!!

Report message to a moderator

Re: Oracle Personal Edition 8i startup password problem [message #51016 is a reply to message #51012]

Sat, 20 April 2002 04:59

kamal
Messages: 12
Registered: February 2002

Junior Member

Hi Rita,
Thanks for reply but i am using oracle8.1.7 personal edition.i had try all password .

Report message to a moderator

Re: Oracle Personal Edition 8i startup password problem [message #51018 is a reply to message #51012]

Sat, 20 April 2002 12:46

rita
Messages: 41
Registered: April 1998

Member

you can use sys as a user name. Usually sys has password oracle or change_on_install.

Since you do not know the password for internal user or sys user, follow this steps:

first delete the pwdfile..
ORADIM -DELETE -SID sid -SRVC sid

then recreate..
ORADIM -NEW -SID sid -INTPWD internalpassword -STARTMODE manual/auto -PFILE init.ora file with path

then initialize the env..
SET ORACLE_SID=sid

start SVRMGRl
connect INTERNAL
-now it will accept ur new password
-then change the SYS password, if u need.

note...
oradim command will return u the prompt immediately..but works at the background, check the process in the TASK MANAGER..or wait for few seconds till ur HHD light goes off then issue the next oradim command. this is same for set oracle_sid also..

Report message to a moderator

Re: Oracle Personal Edition 8i startup password problem [message #51027 is a reply to message #51012]

Sun, 21 April 2002 21:48

kamal
Messages: 12
Registered: February 2002

Junior Member

Hi

I am using oracle 8.1.7 personal edition. i had mentioned before that.

Report message to a moderator

Previous Topic:	Need to break the Export into small files
Next Topic:	urgent - accessing oracle7 from oracle8i or vice versa within the same server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 08:59:45 CST 2024