Oracle10g Can't start OracleCSService

Running firewall is the most often cause for this.
Turn the firewall off.

Thank, but the firewall had been turn off already

You have to install Oracle as Administrator of the machine.
Also check the processes and possibly change some start features
of them.

Thanks for you reply

i installed Oracle as Administrator.

I have this errors when window restart

Please look for hidden firewall components and antiviruses.
Also in Oracle 10g there is a famous effect (politely I will not say bug, but ... I am ... worried about):

For STATIC registration of the Oracle service to the Listener:

Go to the remote 10g installation.
In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

OracleCSService is required for RAC environments or ASM.
If you have a stand alone machine or do not want to use the
Automatic Storage Manager,
you can simply ignore those messages and set the
OracleCSService to manual startup within the Windows services.

Thank bros
to shwertner:

I have a stand alone machine, i can set oracle CSService to manual startup, but the thing is i cannot start listener service.


i have two listener services as i mentioned above:

OracleOraDb10g_home1TNSlistener         Automatic
OracleOraEM10g_home1TNSListener         Started

i can start the second but i cannot start the first one.

When i try to use the sqlplus to logon database, error:

ORA-12560: TNS:protocol adapter error


i have two listener file:

the first one:

# listener.ora Network Configuration File: C:\oracle\product\10.1.0\em_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = Oracle8.ho.vcb.com)
      (SID_NAME = CAM)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ho-cam01)(PORT = 1521))
  )


and the second one



# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ho-cam01.ho.vcb.com)(PORT = 1521))
      )
    )
  )



and in the regitry, the ORACLE_HOME is  C:\oracle\product\10.1.0\Db_1   in ORACLE\SYSMAN\OracleDBConsoleCAM
C:\oracle\product\10.1.0\em_1

Im so confuse.

Thanks for you helps once again

but in the other tag, the ORACLE_HOME is


 

Big mistake!
The both servers tries to use the same port 1521.
It is occupied by the first started Listener.
Change the port of the second Listener to 1522!!!!

i try to stop and start the second listener, it's ok,

but when stop the second listener and start the

first one, error happened.

The problem here is i can't start the first listener

OracleOraDb10g_home1TNSlistener         Automatic
OracleOraEM10g_home1TNSListener         Started

Hi, someone give me solution, pls!!!

Here is my ENV:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"inst_loc"="C:\\Program Files\\Oracle\\Inventory"
"ORA_CRS_HOME"="C:\\oracle\\product\\10.1.0\\Db_1"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\iSuites]
"MDAC Session Update Status"="Complete"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1]
"ORACLE_HOME"="C:\\oracle\\product\\10.1.0\\Db_1"
"ORACLE_HOME_NAME"="OraDb10g_home1"
"ORACLE_GROUP_NAME"="Oracle - OraDb10g_home1"
"ORACLE_BUNDLE_NAME"="Enterprise"
"NLS_LANG"="AMERICAN_AMERICA.WE8MSWIN1252"
"OLEDB"="C:\\oracle\\product\\10.1.0\\Db_1\\oledb\\mesg"
"OO4O"="C:\\oracle\\product\\10.1.0\\Db_1\\oo4o\\mesg"
"SQLPATH"="C:\\oracle\\product\\10.1.0\\Db_1\\dbs"
"ORACLE_HOME_KEY"="SOFTWARE\\ORACLE\\KEY_OraDb10g_home1"
"ORACLE_BASE"="C:\\oracle\\product\\10.1.0"
"MSHELP_TOOLS"="C:\\oracle\\product\\10.1.0\\Db_1\\MSHELP"
"RDBMS_CONTROL"="C:\\oracle\\product\\10.1.0\\Db_1\\DATABASE"
"RDBMS_ARCHIVE"="C:\\oracle\\product\\10.1.0\\Db_1\\DATABASE\\ARCHIVE"
"ORA_CAM_AUTOSTART"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_CAM_SHUTDOWN"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_CAM_SHUTDOWNTYPE"=hex(2):69,00,6d,00,6d,00,65,00,64,00,69,00,61,00,74,00,\
  65,00,00,00
"ORA_CAM_SHUTDOWN_TIMEOUT"=hex(2):39,00,30,00,00,00

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ODP.NET]
"TraceFileName"="C:\\ODPNET.trc"
"TraceLevel"="0"
"TraceOption"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\OLEDB]
"CacheType"="Memory"
"ChunkSize"="100"
"DistribTX"="1"
"FetchSize"="100"
"OSAuthent"="0"
"PLSQLRset"="0"
"PwdChgDlg"="1"
"SchRstLng"="10000"
"UserDefFn"="0"
"DisableRetClause"="1"
"VCharNull"="1"
"TraceCategory"="0"
"TraceFileName"="c:\\OraOLEDB.trc"
"TraceLevel"="0"
"TraceOption"="0"
"SPPrmDefVal"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\OO4O]
"CacheBlocks"="20"
"FetchLimit"="100"
"FetchSize"="4096"
"HelpFile"="C:\\oracle\\product\\10.1.0\\Db_1\\oo4o\\doc\\oracleo.hlp"
"PerBlock"="16"
"SliceSize"="256"
"TempFileDirectory"="c:\\temp"
"OO4O_HOME"="C:\\oracle\\product\\10.1.0\\Db_1\\oo4o"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraEM10g_home1]
"ORACLE_HOME"="C:\\oracle\\product\\10.1.0\\em_1"
"ORACLE_HOME_NAME"="OraEM10g_home1"
"ORACLE_GROUP_NAME"="Oracle - OraEM10g_home1"
"ORACLE_BUNDLE_NAME"="Enterprise"
"NLS_LANG"="AMERICAN_AMERICA.WE8MSWIN1252"
"SQLPATH"="C:\\oracle\\product\\10.1.0\\em_1\\dbs"
"ORACLE_OPMN_SERVICE"="OracleOraEM10g_home1ProcessManager"
"MSHELP_TOOLS"="C:\\oracle\\product\\10.1.0\\em_1\\MSHELP"
"ORACLE_HOME_KEY"="SOFTWARE\\ORACLE\\KEY_OraEM10g_home1"
"RDBMS_CONTROL"="C:\\oracle\\product\\10.1.0\\em_1\\DATABASE"
"RDBMS_ARCHIVE"="C:\\oracle\\product\\10.1.0\\em_1\\DATABASE\\ARCHIVE"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraEM10g_home1\HTTP_Server]
"Path"="C:\\oracle\\product\\10.1.0\\em_1\\bin;C:\\oracle\\product\\10.1.0\\em_1\\Perl\\5.6.1\\bin\\MSWin32-x86;C:\\oracle\\product\\10.1.0\\em_1\\Apache\\fastcgi;C:\\oracle\\product\\10.1.0\\em_1\\opmn\\bin;C:\\oracle\\product\\10.1.0\\em_1\\opmn\\lib"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraEM10g_home1_Agent]
"ORACLE_HOME"="C:\\oracle\\product\\10.1.0\\agent"
"ORACLE_HOME_NAME"="OraEM10g_home1_Agent"
"ORACLE_GROUP_NAME"="Oracle - OraEM10g_home1_Agent"
"ORACLE_BUNDLE_NAME"="Enterprise"
"NLS_LANG"="AMERICAN_AMERICA.WE8MSWIN1252"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Ocr]
"ocrconfig_loc"="C:\\oracle\\product\\10.1.0\\Db_1\\cdata\\localhost\\local.ocr"
"Local_Only"="TRUE"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SCR]

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN]

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDBConsoleCAM]
"EMDROOT"="C:\\oracle\\product\\10.1.0\\Db_1"
"ORACLE_HOME"="C:\\oracle\\product\\10.1.0\\Db_1"
"EMSTATE"="C:\\oracle\\product\\10.1.0\\Db_1\\ho-cam01.ho.vcb.com_CAM"
"CONSOLE_CFG"="dbconsole"
"ORACLE_SID"="CAM"
"TIMEOUT"="15"
"TRACE_LEVEL"="16"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleOraEM10g_home1ASControl]
"EMDROOT"="C:\\oracle\\product\\10.1.0\\em_1"
"ORACLE_HOME"="C:\\oracle\\product\\10.1.0\\em_1"
"TIMEOUT"="15"
"TRACE_LEVEL"="16"
"CONSOLE_CFG"="iasconsole"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleOraEM10g_home1CentralConole]

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleOraEM10g_home1CentralConsole]
"EMDROOT"="C:\\oracle\\product\\10.1.0\\em_1"
"JAVA_HOME"="C:\\oracle\\product\\10.1.0\\em_1/jdk"
"ORACLE_HOME"="C:\\oracle\\product\\10.1.0\\em_1"
"JRE_HOME"="C:\\oracle\\product\\10.1.0\\em_1/jdk"
"ADDL_PATH"="C:\\oracle\\product\\10.1.0\\em_1\\bin;C:\\oracle\\product\\10.1.0\\em_1\\jdk\\jre\\bin\\client;C:\\oracle\\product\\10.1.0\\em_1\\perl\\5.6.1\\bin\\MSWin32-x86"
"ORA_NLS"="C:\\oracle\\product\\10.1.0\\em_1\\ocommon\\nls\\admin\\data"
"ORA_NLS32"="C:\\oracle\\product\\10.1.0\\em_1\\ocommon\\nls\\admin\\data"
"ORA_NLS33"="C:\\oracle\\product\\10.1.0\\em_1\\ocommon\\nls\\admin\\data"
"NLS_LANG"="AMERICAN_AMERICA.WE8MSWIN1252"
"PERL5LIB"="C:\\oracle\\product\\10.1.0\\em_1\\perl\\5.6.1\\bin\\MSWin32-x86;C:\\oracle\\product\\10.1.0\\em_1\\perl\\5.6.1\\lib;C:\\oracle\\product\\10.1.0\\em_1\\perl\\5.6.1\\lib\\MSWin32-x86;C:\\oracle\\product\\10.1.0\\em_1\\perl\\site\\5.6.1\\lib;C:\\oracle\\product\\10.1.0\\em_1\\perl\\site\\5.6.1\\lib\\Win32;C:\\oracle\\product\\10.1.0\\em_1\\sysman\\admin\\scripts"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleOraEM10g_home1_AgentAgent]
"EMDROOT"="C:\\oracle\\product\\10.1.0\\agent"
"ORACLE_HOME"="C:\\oracle\\product\\10.1.0\\agent"
"TIMEOUT"="15"
"TRACE_LEVEL"="16"
"CONSOLE_CFG"="agent"

Use net Configuration assistant and drop both Listeners.
After that create one and use it.
Do not make your life too complex having 2 Listeners.
Also if possible try to migrate to 10g R2.

Thanks!

I have solve the problem already.

I have changed the Oracle SID and restart the system.

Thanks everyone.