| oracle 10g rel2 fresh install. need some help [message #358461] |
Tue, 11 November 2008 08:10  |
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 #358499 is a reply to message #358461] |
Tue, 11 November 2008 10:59  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
