OraFAQ Forum: Security » Databse login problem

Home » RDBMS Server » Security » Databse login problem (Oracle 9i,Windows 2000)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Databse login problem [message #359731]

Tue, 18 November 2008 01:49

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Hi all,

i have installed oracle10g on windows for testing purpose using DBCA on my machine.Oracle 9i is also installed on the same machine.when i use sqlplus to login to database in command prompt mode ,i could only able to login into oracle 10g database .But i want to login to oracle 9i database.I even stopped the oracle10g service.But still i couldnot login to oracle 9i db only.

Please find the screenshot for the same.

C:\>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 18 13:08:50 2008

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

Enter user-name:

Any help will be appreciated

Thanks and Regards,
Balaji

[Updated on: Tue, 18 November 2008 01:52]

Report message to a moderator

Re: Databse login problem [message #359733 is a reply to message #359731]

Tue, 18 November 2008 01:57

Littlefoot
Messages: 21782
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It appears that you are invoking Oracle 10g SQL*Plus.

In order to start 9i SQL*Plus, either name the whole path to this file (such as "c:\oracle\oracle9ihome\bin\sqlplus"), or change your working directory to "Oracle9ihome\bin" directory and use SQLPLUS command.

Report message to a moderator

Re: Database login problem [message #359780 is a reply to message #359733]

Tue, 18 November 2008 03:36

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

In windows,Oracle 9i is installed in the path C:\oracle\ora92\bin .Under this path -- two sqlplus related files (sqlplus.exe and sqlplusw.exe) are available.

Can i use sqlplus command in command prompt under the path 'C:\oracle\ora92\bin' in order to login oracle 9i db?

Please revert me with the answer.

[Updated on: Tue, 18 November 2008 03:41]

Report message to a moderator