| Installing Personal Oracle [message #54146] |
Thu, 31 October 2002 13:55  |
dheeraj sharma
Messages: 3
Registered: October 2002
|
Junior Member |
|
|
|
I have personal oracle installed and i can connect as conn scott/tiger on sql plus but when i use toad to connect i can not because i do not know what database name to provide. i think i have to add a service etc but how do we do that.
|
|
|
|
| Re: Installing Personal Oracle [message #54147 is a reply to message #54146] |
Thu, 31 October 2002 15:09  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Add service name in your tnsnames.ora file in ORACLE_HOMEnetworkadmin directory.
"SERVICE_NAME"=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = "HOST NAME.DOMAIN NAME.COM)(PORT = 1521))
)
(CONNECT_DATA = (SID = "SID NAME")
)
)
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
