Home » SQL & PL/SQL » Client Tools » oracle 10g rel2 fresh install. need some help
oracle 10g rel2 fresh install. need some help [message #358461] Tue, 11 November 2008 08:10 Go to next message
blank
Messages: 2
Registered: November 2008
Location: greece
Junior Member
hello


i just installed the enterprise edition of oracle 10g rel2 on windows XP.

i have a problem trying to log on to sqlplusw as system.
im using the program for my sql lab lessons in uni and my teacher told me to log in as "system" and the pass I chose during the install for the sys and sysdba accounts. its not working though. it comes up with this error: ORA-12560: TNS: protocol adapter error

any ideas?
Re: oracle 10g rel2 fresh install. need some help [message #358473 is a reply to message #358461] Tue, 11 November 2008 08:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't just describe what you (think you) did, copy and paste it.
Did you set ORACLE_HOME and ORACLE_SID?

Regards
Michel

[Updated on: Tue, 11 November 2008 08:57]

Report message to a moderator

Re: oracle 10g rel2 fresh install. need some help [message #358499 is a reply to message #358461] Tue, 11 November 2008 10:59 Go to previous messageGo to next message
blank
Messages: 2
Registered: November 2008
Location: greece
Junior Member
i had the services stopped coz oracle slowed down my system. i've managed to log in as system now.
i created a new account with the create user command:
create user <username> identified by <pass>;

then i tried to grant access to this account with the grant command but it came up with another error. i dont remember exactly, im not on my puter at the mo.

whats that grant command? i googled it and i found this one
SQL> grant connect to <username>;

but the one my teacher told me to type isnt the same and was the one that came up with the error. anyway ill try the one i found on google later.


edit: with this user i want to: create and manage my db.

[Updated on: Tue, 11 November 2008 11:11]

Report message to a moderator

Re: oracle 10g rel2 fresh install. need some help [message #358516 is a reply to message #358499] Tue, 11 November 2008 12:28 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Database Administrator's Guide
SQL Reference

Regards
Michel
Previous Topic: Toad Installation with D2K client
Next Topic: authorization key for oracle toad 9.7
Goto Forum:
  


Current Time: Thu Dec 08 04:11:40 CST 2016

Total time taken to generate the page: 0.46055 seconds