Home » SQL & PL/SQL » SQL & PL/SQL » How to login Sqlplus (merged)
How to login Sqlplus (merged) [message #389812] Tue, 03 March 2009 12:04 Go to next message
pudurkutti
Messages: 2
Registered: March 2009
Junior Member
Hi,

I had just started my course in Oracle DBA. I had installed 9i in my system just today. And when i tried to lo-gin to SQLPLUS its asking for password and i tried to set user name as per my friends advice. But i was not able to lo-gin to SQLPLUS. Can some one please provide me the solution to Create User-name and password.

Thanks
Karthik
Re: How to login Sqlplus [message #389817 is a reply to message #389812] Tue, 03 March 2009 12:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>I had installed 9i in my system just today
V9 Oracle is obsoleted & unsupported.
I suggest installing V11 Oracle.


Oracle is not your typical Windoze point & click GUI application.

When all else fail, please Read The Fine Manual
http://download.oracle.com/docs/html/A95493_01/toc.htm


You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.


Re: How to login Sqlplus [message #389818 is a reply to message #389812] Tue, 03 March 2009 12:18 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
do NOT cross/multi-post
Re: How to login Sqlplus [message #389822 is a reply to message #389818] Tue, 03 March 2009 12:28 Go to previous messageGo to next message
pudurkutti
Messages: 2
Registered: March 2009
Junior Member
iam sorry i was new and unknowingly ive posted.
Re: How to login Sqlplus (merged) [message #389827 is a reply to message #389812] Tue, 03 March 2009 12:37 Go to previous message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
pudurkutti wrote on Tue, 03 March 2009 19:04
Hi,

I had just started my course in Oracle DBA. I had installed 9i in my system just today. And when i tried to lo-gin to SQLPLUS its asking for password and i tried to set user name as per my friends advice. But i was not able to lo-gin to SQLPLUS. Can some one please provide me the solution to Create User-name and password.

Thanks
Karthik

Congratulations. So you surely followed the steps as described e.g. Creating an Oracle database chapter in Oracle documentation and you know passwords of SYS and SYSTEM users (or the default ones if you did not specify them, as specified here).
So, connect as SYSTEM user and do it. Of course, creating an user is also documented - the whole Oracle documentation is available e.g. online on http://tahiti.oracle.com/. So, pick your Oracle version there and search for CREATE USER command (or have a look at your course papers).
Previous Topic: Rows into Columns
Next Topic: Date Validation
Goto Forum:
  


Current Time: Thu Dec 08 08:32:03 CST 2016

Total time taken to generate the page: 0.14631 seconds