Can't find login for oracle 9i.

Posted on 2007-07-23
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

    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

    Try logging in as follows

    conn sys as sysdba
    password : change_on_install
    LVL 34

    Expert Comment

    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?
    LVL 34

    Expert Comment

    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 47

    Expert Comment

    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 34

    Expert Comment

    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Oracle Cursor 5 50
    top-performance 5 89
    Stay Alert! 13 47
    Value of 0's not appearing. 9 40
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

    731 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now