| system/manager not accessing in oracle9i [message #458559] |
Mon, 31 May 2010 04:30  |
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  |
 |
Littlefoot
Messages: 21823
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
