Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Problems Using SQL*plus in Oracle

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 21-01-2010
Member
 
Join Date: Nov 2009
Posts: 56
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.
Reply With Quote
  #2  
Old 21-01-2010
Member
 
Join Date: Feb 2008
Posts: 1,844
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.
Reply With Quote
  #3  
Old 21-01-2010
Member
 
Join Date: Jan 2008
Posts: 1,513
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.
Reply With Quote
  #4  
Old 21-01-2010
Member
 
Join Date: Apr 2008
Posts: 1,946
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Problems Using SQL*plus in Oracle"
Thread Thread Starter Forum Replies Last Post
VirtualBox 4.0.0 of Oracle Ooopinder Windows Software 4 30-05-2011 10:27 AM
How to connect vb 6.0 with oracle Mewad Software Development 5 05-01-2011 09:53 AM
Is Oracle Ok? willactnow Education Career and Job Discussions 2 15-09-2009 02:06 PM
Help with Oracle Certification! Bhusan Education Career and Job Discussions 5 17-04-2009 11:39 AM


All times are GMT +5.5. The time now is 12:15 AM.