This content has been marked as final. Show 39 replies
The hostname (HOST = ora.newmiddleclass.com) in your listener.ora doesn't match your actual hostname.
Based on what I posted above, what is my actual host name? Is it
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.
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.
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.
(ADDRESS = (PROTOCOL = TCP)(HOST = dimension4100.ora.newmiddleclass.com)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = HCM.dimension4100.ora.newmiddleclass.com)
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(SID = PLSExtProc)
(PRESENTATION = RO)
I'm using dimension4100 for the SQL*Plus Host String in the login window.
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.
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.
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).
Assuming you are in the DBA group:
sqlplus / as sysdba
Or just try to log in without specifying a tns alisas:
I opened a DOS command window and tried the commands you just suggested, and got
ORA-12560: TNS: protocol adapter error
You need to make sure the Window's Oracle service is started in the Windows service control panel.
The only Oracle services I see are
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!
It's the OracleServiceHCM one.
Yes, that's in status Started, and I stopped and started it just to be sure. Still getting the same error.
Ok, now in the command prompt type:1 person found this helpful
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.