unable to connect to database
Hi - I'm an Oracle newbie having just installed it on my winxp box for a university project. I've been trying for some time now to connect to it using sql+ but haven't been able to do so. I think I've got my tnsnames.ora file configured correctly:
SIMONDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.162)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Oracle)
)
)
I'd like to be able to connect using the service name "Oracle", but it just doesn't seem to work! Any help would be much appreciated!
No SQL+ Connnection to 10g DB
Hi - I've tried changing the tns entry as per below, but still no joy connecting unfortunately. Just to elaborate a bit - I can perform sql queries etc using the 10g DB homepage, but when I try and do the same thing using sql+, or any application that requires me to connect using a host string, I get a "ORA-12514: TNS: Listener could not resolve SERVICE_NAME given in connect descriptor" error.
I wonder whether something went wrong with the install as I get the impression from some documentation that I should be able to configure this kind of stuff during installation, but I didn't seem to have the option to do that (installed 10g Express Edition).
I'm currently doing all my work using a SYSTEM login - would creating an additional user help at all?
Yours cluelessly.....