Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Can't find login for oracle 9i.

Posted on 2007-07-23
Medium Priority
Last Modified: 2013-12-19
I downloaded and install oracle 9i and did the install steps, one it was all done I could not log in because I did not know the login id. is there a default Id that is used when you first install it?
Question by:cdb424ttm
LVL 11

Accepted Solution

sujit_kumar earned 2000 total points
ID: 19550428
you can try user_name = scott, Password=tiger. If this does not work try, user_name = system, Password=manager.

 You should change the system's password after you log in.
LVL 14

Expert Comment

ID: 19550710
Try logging in as follows

conn sys as sysdba
password : change_on_install
LVL 35

Expert Comment

by:Mark Geerlings
ID: 19550951
Prior to Oracle9, yes there were default logins for Oracle (as others have indicated).  Starting with oracle9 though, the Oracle installer prompts for a password for the SYS and SYSTEM accounts (it may be the same or different, depending on how you responded to the prompt).

Don't you remember being prompted to provide a password for SYS or SYSTEM?
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

LVL 35

Expert Comment

by:Mark Geerlings
ID: 19550970
If you cannot log in, you don't have much to lose at this point.  You could use DBCA (the GUI Database Creation Assistant) to just create a new database and keep track of the password for SYS and/or SYSTEM as you create the new database.  I think DBCA can also be used to delete the default database that you have now, since it doesn't add any value for you.
LVL 48

Expert Comment

ID: 19553806
Logon as the OS user who has installed Oracle.
% sqlplus /nolog
SQL>connect / as sysdba
SQL>alter user sys identified by manager;

Now you will be able to logon so:
SQL>connect sys/manager@alias as sysdba
LVL 35

Expert Comment

by:Mark Geerlings
ID: 19556205
To schwertner:

That syntax: "connect / as sysdba" usually works in UNIX and Linux, but for Oracle on Windows it usually does not work.  We don't know the server O/S in this case, so that may or may not work here.

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question