Home » Other » Client Tools » SQL+ login headache
SQL+ login headache [message #244911] Thu, 14 June 2007 10:15 Go to next message
pqr789
Messages: 4
Registered: June 2007
Junior Member
Hi,
I have been having a headache while logging into SQL+ in Oracle 10g.
ok, lemme elaborate..

When I create a new database, I click on 'Password Management'tab. There I unlock SCOTT account and provide a new password.
When I login SQL+ with username: SCOTT and the password, it logs well.

Now, when I close the program and reboot my PC and again try to login SQL+ with the same pswd, it does not login. I get the error TNS Protocol Error...What do i do? This is a headache as i cant login after rebooting the machine...plz help
Re: SQL+ login headache [message #244912 is a reply to message #244911] Thu, 14 June 2007 10:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What do i do?
Use ACCESS instead of Oracle. Access is much more user friendly & you don't need to RTFM to use Access.
Re: SQL+ login headache [message #244913 is a reply to message #244911] Thu, 14 June 2007 10:21 Go to previous messageGo to next message
pqr789
Messages: 4
Registered: June 2007
Junior Member
No...I wanna learn oracle...help me out with a solution not alternatives...
Re: SQL+ login headache [message #244915 is a reply to message #244911] Thu, 14 June 2007 10:24 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Look up the error message you are receiving to see what might be causing your "headache" ?? Try and resolve it, then ask some specific questions if you still do not understand.

Re: SQL+ login headache [message #244919 is a reply to message #244911] Thu, 14 June 2007 10:31 Go to previous messageGo to next message
pqr789
Messages: 4
Registered: June 2007
Junior Member
It gives me the foll error:
ERROR:
ORA-12560: TNS:protocol adapter error
Re: SQL+ login headache [message #244920 is a reply to message #244911] Thu, 14 June 2007 10:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle comes with documentation you MUST read them if you want to use it:
Database Platform Guide 10g Release 2 (10.2) for Microsoft Windows (32-Bit)
Database Concepts
SQL*PlusŪ User's Guide and Reference

Regards
Michel
Re: SQL+ login headache [message #244925 is a reply to message #244911] Thu, 14 June 2007 10:46 Go to previous messageGo to next message
pqr789
Messages: 4
Registered: June 2007
Junior Member
hey those were indeed good informative links...but am unable to interpret the error i am getting (TNS protocol adapter error)...
Re: SQL+ login headache [message #244926 is a reply to message #244911] Thu, 14 June 2007 10:50 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Google is your friend.

Try it here is 1 link of over 65,000

http://www.cryer.co.uk/brian/oracle/ORA12560.htm
Previous Topic: Output alignment......
Next Topic: Reporting in Oracle............
Goto Forum:
  


Current Time: Thu Mar 28 06:44:18 CDT 2024