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.

Question asked by x

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

Answer 1:

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.

Answer2

Thank you all.

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

What do you think the problem is?

Again question by x

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.

Answer1

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

Answer 2

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.