-
ORA-12154: TNS:could not resolve service name
Hi all, I am your typical newbie to all of this so please be gentle. I have done a google search on this and have tried all the solutions I could find with no luck. I just installed oracle 9i on RedHat Linux 9. I thought I had everything set up correctly but at the prompt when I type "sqlplus scott/tiger" I get this error message:
ERROR:
ORA-12154: TNS:could not resolve service name
My tnsnames.ora and sqlnet.ora are both in $ORACLE_HOME/network/admin
Here is my tnsnames.ora file:
O9IDB.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = O9IDB.testingthisdb.com)
)
)
INST1_HTTP.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
And here is my sqlnet.ora file:
NAMES.DEFAULT_DOMAIN = localdomain
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
I'm not doing any remote connection to it or have it connected to any domain. Its all on my local computer. My GID is O9IDB.testingthisdb.com and my SID is O9IDB
Any help from you gurus will be greatly appreciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|