system/manager not accessing in oracle9i [message #458559] |
Mon, 31 May 2010 04:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
visix
Messages: 6 Registered: May 2010 Location: Hyderabad
|
Junior Member |
|
|
Hi every one,
Recently iam installed oracle9i in my labtop.In oracle scott/tiger acessing.But system/manager not accessing pls give me the correct solution.
Regards,
Visix.
|
|
|
|
|
Re: system/manager not accessing in oracle9i [message #458566 is a reply to message #458564] |
Mon, 31 May 2010 04:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I don't know what you set it to.
When you installed the database, did installer ask for some passwords you'd like to use? If so, what did you enter?
Default username + password combinations were, as far as I can remember, SYS/CHANGE_ON_INSTALL and SYSTEM/MANAGER. If you can't connect using those credentials, you (or someone else) changed those passwords.
If your OS user is part of the DBA group, then you could try to connect with SQLPLUS / AS SYSDBA and, once connected, change passwords you want (which includes SYSTEM).
[Updated on: Mon, 31 May 2010 04:59] Report message to a moderator
|
|
|
Re: system/manager not accessing in oracle9i [message #458567 is a reply to message #458559] |
Mon, 31 May 2010 05:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Its_me_ved
Messages: 979 Registered: October 2009 Location: India
|
Senior Member |
|
|
If you are logged into the database server as user belonging to 'dba' unix or 'ora_dba' windows group , typically 'oracle' , then you should be able to do this
xxxx@xxxxx1:/ora1/exports>sqlplus "/ as sysdba"
SQL*Plus: Release 9.0.1.4.0 - Production on Mon May 31 15:15:00 2010
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
With the Partitioning option
JServer Release 9.0.1.4.0 - Production
SQL> show user
USER is "SYS"
Once logged in, you can change the passwords.
SQL> Alter user SYSTEM identified by new_password;
Regards
Ved
|
|
|