jamesccnacmp
asked on
help open sqlplus
I just download Oracle9i Database Release 2 Enterprise/Standard/Person al 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?
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?
ASKER
what about the host string?
If it is the personal edition it would probably by 2: or blank.
ASKER
type in the number 2 or type in blank, the user and password is not allow me in?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No it just kick me out I type
user: system
password: manager
Host string: 2:
user: system
password: manager
Host string: 2:
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
No connect to OEM Using,
system/manager@localHost
Sujit
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
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
User system and password manager