Create Oracle Host

I'm new to Oracle, I downloaded Oracle 9i and want to use the SQL applications.

It asks me for user name and password and host string.  It didn't ask me to create these when I installed the software.

So what is a host string and how do I create it and create a username and password for it.

Mohammad

simply type in host string as "scott" and pwd as "tiger".

Lokesh Bohra

There are default accounts created, following are their user name and passwords
user name: sys password:change_on_install
system p/w manager
scott p/w tiger
host string is used when you have more than one database or you want to connect to a database from remote location. There is no need of connect string at the moment.

Abdul Qadir

Thank you all.

But unfortunatlly it didn't work, I tried all of them

What do you think the problem is?

Mohammad

This means you have not configured your tnsnames. It is available in orahome/network/admin directory, insert the entry for your database and then try to connect. Alternately you can use net configuration assistant.

Sumit

If  you are interested to create new user you must connect with dba right . So by default in oracle user system and user sys has dba right therefore initially you use user name as sys and by default sys password is change_on_install.

After connecting the above user name & password you write command on sqlplus is create user abc identified by xyz
after creating user you type a command
grant connect, dba to abc identified by xyz with admin option

Now you join with dba privileges

Khawaja

Follow the steps to access sql

1, create the service name using config. mgmt.(Net) while create the service name it will ask service name and hostname just enter your db name and your host ip address which is hosted oracle.

2, oracle provice some predefined un and pwd i.e scott and tiger. open the sqlplus environment and type the username, password and the service name.

3, after that it will connect, if not send me what error msg occur while connection.

Thoppan S Karthick

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.