| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
12-02-09, 05:10
|
|
Registered User
|
|
Join Date: Dec 2009
Posts: 4
|
|
Issue in logging into sqlplus - Oracle 11g Database
|
|
Hi,
I have installed oracle 11g database in my system, After installation, i am able to login into the Oracle Enterprise manage by accessing the link
https://localhost:1158/em with my system or sys user name and the password.
Both as Normal and as SYSDBA 
But if try to give to the same user name and password in the sqlplus, i get the invalid user name/password error.
Can someone please help me 
Thanks and Regards,
Adarsh.S.K
|
|
12-02-09, 09:03
|
|
Lead Application Develope
|
|
Join Date: Jun 2004
Location: Liverpool, NY USA
Posts: 2,222
|
|
have you setup the tnsnames file?
__________________
Bill
You do not need a parachute to skydive. You only need a parachute to skydive twice. 
|
|
12-02-09, 10:35
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,415
|
|
|
|
It is a little known fact that starting with V11, Oracle passwords became CaseSensitive.
In the past the passwords defaulted to being UPPERCASE.
So, this might be your problem.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
|
|
12-02-09, 21:50
|
|
Registered User
|
|
Join Date: Dec 2009
Posts: 4
|
|
Quote:
Originally Posted by beilstwh
have you setup the tnsnames file?
|
No, i didnt explicitly set up any tnsname files.. my problem seems a little weird, able to login to enterprise manager, but not to sqlplus.....
Thanks and Regards,
Adarsh.S.K
|
|
12-02-09, 21:52
|
|
Registered User
|
|
Join Date: Dec 2009
Posts: 4
|
|
Quote:
Originally Posted by anacedent
It is a little known fact that starting with V11, Oracle passwords became CaseSensitive.
In the past the passwords defaulted to being UPPERCASE.
So, this might be your problem.
|
Thanks, i tried logging into the sqlplus with the password modified to all caps, but not working....
|
|
12-02-09, 21:57
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,415
|
|
Quote:
Originally Posted by Adarshsk
No, i didnt explicitly set up any tnsname files.. my problem seems a little weird, able to login to enterprise manager, but not to sqlplus.....
Thanks and Regards,
Adarsh.S.K
|
> https://localhost:1158/em
Please pay attention!
Logging using "https://localhost:1158/em" works because it uses a browser, Apache & totally different protocol to the DB than sqlplus!
If you are physically logged onto the DB server, then no SQL*Net (tnsnames.ora) is required to log into Oracle RDBMS.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
|
|
12-02-09, 21:59
|
|
Registered User
|
|
Join Date: Dec 2009
Posts: 4
|
|
Quote:
Originally Posted by anacedent
> https://localhost:1158/em
Please pay attention!
Logging using "https://localhost:1158/em" works because it uses a browser, Apache & totally different protocol to the DB than sqlplus!
If you are physically logged onto the DB server, then no SQL*Net (tnsnames.ora) is required to log into Oracle RDBMS. |
Thanks a lot, it would be great if i get some pointers on how to set up the tnsnames.ora file? any information or any links for that..
Thanks and Regards,
Adarsh.S.K
|
|
12-02-09, 22:05
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,415
|
|
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
Issue in logging into sqlplus - Oracle 11g Database
