How to login Sql*plus
I just install 10g. try to use SQL*Plus. what should put for User Name, Password and Host String? Thank you.
Leave a comment...
- 4 Comments
- If you created your database through DBCA,it will prompt you for sys and system user password.what did u gave?
connect to sql*plus enter your login name as
password:***** (which u assigned)
Hoststring: Its nothing but your database name
After login as sys unlock the scott,hr schemas
Hope this will help u..
bye#1; Sat, 23 Feb 2008 12:16:00 GMT
- I downed Oracle database 10g, I thought I can login with user: scott and password: tigger to login, but my login was failed. I tried to login with system and manager it failed too. Could you please tell me how I can login to use sql*plus?
Thanks!#2; Sat, 23 Feb 2008 12:18:00 GMT
- > but my login was failed.
How ? Please post the error stack you get.#3; Sat, 23 Feb 2008 12:18:00 GMT
Just type - > sqlplusw in ur run prompt. Then type the user name and passwd in the
provided space. Should login in.
Still u face any problems do post the error message.
Nirmal#4; Sat, 23 Feb 2008 12:19:00 GMT