Results 1 to 4 of 4

Thread: Problems Using SQL*plus in Oracle

  1. #1
    Join Date
    Nov 2009

    Problems Using SQL*plus in Oracle

    I installed Oracle 9i.When I go Start->Program->Oracle-oraHome90. I didn't get SQL*plus.Kindly let me know the idea. Any help would be highly appreciated.Kindly find the attachment also.I am unable to find out the password of database administrator.I am using Windows XP and installed oracle 9i but I get failed to login into administrator account of database.I was working on Linux before with oracle 9i but when I divert on Windows,So confused to use it.So please help me.
    Last edited by Adriana_andros; 21-01-2010 at 10:31 AM.

  2. #2
    Join Date
    Feb 2008

    Problems Using SQL*plus

    You are using oracle 9i and not getting any menu of SQL*plus in the list of programs .
    But before doing anything you need to confirm which Oracle Edition you are using.There are three editions are being used in the market like Express Edition,Enterprise Edition and Standard edition.

    If you have installed anyone of these then it would be known that working style is different on every Edition.

    If you installed Enterprise edition (Most popular and always preferred by DBAs),then go to Start=>Program=>Oracle-oraHome90=>Application development=>SQL*plus at bottom.

    If it is not listed in this list then open your SQL worksheet it will ask to you about password just enter the password and work on it but if you really want to choose that one you need to install it again and go for latest versions.

  3. #3
    Join Date
    Jan 2008

    Password of database in oracle

    You are using Oracle 9i Enterprise Edition and you don't know the password of your database,It's nothing like.

    When you are installing Oracle,just remember before you had been prompted for password of your database of sys account and systemaccount.After all of the installation process completion .The database creation wizard come up and ask for the name of database and password after creation.

    If you forget all so Just enter password "change_on_install" for sys account and "Manager" for System if you didn't change it earlier.

  4. #4
    Join Date
    Apr 2008

    Issues with Login into Oracle database

    You were working on Linux with Oracle 9i and now you are working on windows and unable to login unless you have exact password for it also.

    Don't worry about anything , Windows database login is something different from Linux ,you were login into database with oracle using this way:

    $ Export ORACLE_SID=<SID>
    $ sqlplus ' / as sysdba'

    But windows follow it from something different way of login:

    C:\> set ORACLE_SID=<SID>
    C:\> sqlplus /NOLOG

    After that it would jump you on SQL prompt .

    SQL> conn / as sysdba;

    Now you can easily operate your database as an Administrator.

Similar Threads

  1. VirtualBox 4.0.0 of Oracle
    By Ooopinder in forum Windows Software
    Replies: 4
    Last Post: 30-05-2011, 10:27 AM
  2. How to connect vb 6.0 with oracle
    By Mewad in forum Software Development
    Replies: 5
    Last Post: 05-01-2011, 09:53 AM
  3. Is Oracle Ok?
    By willactnow in forum Education Career and Job Discussions
    Replies: 2
    Last Post: 15-09-2009, 02:06 PM
  4. Help with Oracle Certification!
    By Bhusan in forum Education Career and Job Discussions
    Replies: 5
    Last Post: 17-04-2009, 11:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts