OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

question [message #8342]

Mon, 11 August 2003 14:40

Gus
Messages: 18
Registered: December 2000

Junior Member

How do I log onto oracle for the first time? I am just starting out and from what I remember.

Name : scott
pass : tiger
host : ?

What is the host? I am on a Win 2000 machine.
How could creating a new name and password?

Report message to a moderator

Re: question [message #8343 is a reply to message #8342]

Mon, 11 August 2003 18:38

Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA

Senior Member

Just leave the host blank to connect to your local database. Or you can enter it, if you know what it is. You should have written it down when you did your installation.

If you want to create a new user/schema and password, first you need to connect as a user that has privileges to do so, such as system/manager. Then:

SQL> CREATE USER new_name IDENTIFIED BY new_password;

You will also need to grant appropriate privileges to the new_name:

SQL> GRANT CONNECT TO new_name;
SQL> GRANT RESOURCE TO new_name;
SQL> GRANT CREATE ANY TABLE TO new_name;

and so forth.

Then you can connect as new_name/password in the same manner that you would connect as scott/tiger.

Report message to a moderator

Re: question [message #8349 is a reply to message #8343]

Tue, 12 August 2003 06:54

Gus
Messages: 18
Registered: December 2000

Junior Member

It keeps saying that it is unable to connect when I put in

scott
tiger

is there a service I need to start?
or a database I need to create?

Report message to a moderator

Re: question [message #8355 is a reply to message #8349]

Tue, 12 August 2003 15:36

Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA

Senior Member

There should be more than just "unable to connect". What exact error message number do you get?

How did you do your installation? From CD's? If so, there should have been options for either client or server and you should have selected server. If you selected client, then there is no database to connect to and you need to re-do your installation, selecting server.

If you selected server, then everything else should have been done automatically and your local database should be your default if you leave the host string blank. The database should start when the machine is started. You might try re-starting your machine.

Report message to a moderator

Previous Topic:	Sql statement involving dates
Next Topic:	NLS PARAMENTER VALUES

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 12:46:05 CDT 2024