Re: Initial Default Admin Username and Password

From: HansF <News.Hans_at_telus.net>
Date: Fri, 17 Feb 2006 15:23:04 GMT
Message-Id: <pan.2006.02.17.15.23.04.259008_at_telus.net>


On Fri, 17 Feb 2006 06:59:29 -0800, source_acct wrote:

> I just installed Oracle. I want to use SQL Plus from the commandline
> (drive:\orant\bin\sqlplus). What is the default admin username and
> password for first login? Thanks.

If you installed Oracle9i or Oracle 10g and this database was created during the install process (or you created the database using DBCA), you were asked to provide a password.

Oracle no longer routinely creates a database with 'default' passwords.

However, logging on as the user who installed the software, you may be able to access the database without a password, and change the 'system' password using

> sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Beta on Fri Feb 17 08:20:34 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> alter user system identified by turkey;

User altered.

SQL> exit

resulting in the system password being 'turkey'

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***
Received on Fri Feb 17 2006 - 16:23:04 CET

Original text of this message