asked on

help open sqlplus

I just download Oracle9i Database Release 2 Enterprise/Standard/Personal Edition
from oracle web site 3 download I am trying to open sqlplus

It is ask me for

User Name ______
Password________

Host string_______

I tried to use User scott and password tiger

is there another way user and password?

joaoalmeida

User system and password manager

jamesccnacmp

ASKER

what about the host string?

joaoalmeida

If it is the personal edition it would probably by 2: or blank.

jamesccnacmp

ASKER

type in the number 2 or type in blank, the user and password is not allow me in?

ASKER CERTIFIED SOLUTION

joaoalmeida

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jamesccnacmp

ASKER

No it just kick me out I type

user: system
password: manager
Host string: 2:

sujit_kumar

NO, you will have to create a TNS String for your server from "Net Configuration Manager". Give your Machine's IP and the SID being ORCL (this is default, if you haven't chaged anything). Give it's name as "localHost"

No connect to OEM Using,

system/manager@localHost

Sujit

Mehul Shah

Go to

Oracle Home\network\admin folder

open the tnsnames.ora file and add the below entry

<<DB_NAME> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <<IP ADDRESS>>)(PORT = 1521))
)
(CONNECT_DATA =
(SID = <<DB_NAME>>)
)
)

Change the <<DB_NAME>> and <<IP_ADDRESS>> parameter according to your server.

and use the <<DB_NAME>> as the host string.

Hope this helps