This content has been marked as final.
Show 39 replies
-
1. Re: Could not start the TNSListener service on Local Computer
ebrian Sep 25, 2008 4:35 PM (in response to 661470)The hostname (HOST = ora.newmiddleclass.com) in your listener.ora doesn't match your actual hostname. -
2. Re: Could not start the TNSListener service on Local Computer
661470 Sep 25, 2008 4:45 PM (in response to ebrian)Based on what I posted above, what is my actual host name? Is it
dimension4100.ora.newmiddleclass.com ?
What files or settings should I change in order to have everything match?
Edited by: M_Borok on Sep 25, 2008 9:42 AM
...and I'm not clear how theses values might have gotten out of sync. listener.ora is generated during the install. -
3. Re: Could not start the TNSListener service on Local Computer
ebrian Sep 25, 2008 4:43 PM (in response to 661470)Your Fully qualified hostname is dimension4100.ora.newmiddleclass.com.1 person found this helpful
Change (HOST = ora.newmiddleclass.com) to (HOST = dimension4100.ora.newmiddleclass.com) in both the listener.ora and tnsnames.ora files. -
4. Re: Could not start the TNSListener service on Local Computer
661470 Sep 25, 2008 5:08 PM (in response to ebrian)That helped somewhat... now I am able to start the listener. However, SQP*Plus now says:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
My tnsnames.ora now looks like this:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
HCM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dimension4100.ora.newmiddleclass.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HCM.dimension4100.ora.newmiddleclass.com)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
I'm using dimension4100 for the SQL*Plus Host String in the login window. -
5. Re: Could not start the TNSListener service on Local Computer
ebrian Sep 25, 2008 5:13 PM (in response to 661470)What is your service name set to in your database? Go into SQL*Plus and issue1 person found this helpful
SQL> sho parameter service
Set (SERVICE_NAME = HCM.dimension4100.ora.newmiddleclass.com) to this value. -
6. Re: Could not start the TNSListener service on Local Computer
661470 Sep 25, 2008 5:30 PM (in response to ebrian)This looks like a SQLPlus command line command. How do I get to this command line? ... since I can't log in via the login window.
Thanks.
Edited by: M_Borok on Sep 25, 2008 10:29 AM
By the way, there's a service listed in control panel named OracleServiceHCM (which is started). -
7. Re: Could not start the TNSListener service on Local Computer
ebrian Sep 25, 2008 5:29 PM (in response to 661470)Assuming you are in the DBA group:
sqlplus / as sysdba
Or just try to log in without specifying a tns alisas:
sqlplus <username>/<password> -
8. Re: Could not start the TNSListener service on Local Computer
661470 Sep 25, 2008 5:35 PM (in response to ebrian)I opened a DOS command window and tried the commands you just suggested, and got
ORA-12560: TNS: protocol adapter error -
9. Re: Could not start the TNSListener service on Local Computer
ebrian Sep 25, 2008 5:37 PM (in response to 661470)You need to make sure the Window's Oracle service is started in the Windows service control panel. -
10. Re: Could not start the TNSListener service on Local Computer
661470 Sep 25, 2008 5:47 PM (in response to ebrian)The only Oracle services I see are
OracleOraDb10g_home1iSQL*Plus
OracleOraDb10g_home1iSQLTNSListener
OracleServiceHCM
OracleJobSchedulerHCM
The last one is disabled, all the others are started. I tried stopping and stopping all three, but got the same error.
Edited by: M_Borok on Sep 25, 2008 10:46 AM
I meant stopping and starting! -
11. Re: Could not start the TNSListener service on Local Computer
ebrian Sep 25, 2008 5:49 PM (in response to 661470)It's the OracleServiceHCM one. -
12. Re: Could not start the TNSListener service on Local Computer
661470 Sep 25, 2008 5:50 PM (in response to ebrian)Yes, that's in status Started, and I stopped and started it just to be sure. Still getting the same error. -
13. Re: Could not start the TNSListener service on Local Computer
ebrian Sep 25, 2008 5:52 PM (in response to 661470)Ok, now in the command prompt type:1 person found this helpful
set oracle_sid=hcm
sqlplus <username>/password -
14. Re: Could not start the TNSListener service on Local Computer
661470 Sep 25, 2008 6:02 PM (in response to ebrian)That seemed to work, but the next error is:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
I checked; all three Oracle services are still up.