Tags: 10g, database, install, login, mysql, oracle, password, sql, sqlplus, string, user

How to login Sql*plus

On Database » Oracle

1,019 words with 4 Comments; publish: Tue, 12 Feb 2008 10:23:00 GMT; (25046.88, « »)

I just install 10g. try to use SQL*Plus. what should put for User Name, Password and Host String? Thank you.

All Comments

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

      eg: username:sys

      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
    • Hi,

      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.

      Cheers

      Nirmal

      #4; Sat, 23 Feb 2008 12:19:00 GMT