Upgrade to Oracle 10g

[Former Member]

hi,

We have done a test upgrade from 9.2.0.7 to 10.2.0.2 , The upgrade was successful.

For some reason the following 10g services were not created.

OracleCSService

OracleJobScheduler<DBSID>

Oracle<Oracle_Home_Name>SNMPPeerEncapsulator

Oracle<Oracle_Home_Name>SNMPPeerMasterAgent

Is there a manual way of creating these services and why they were not created

during the installation process.

[former_member204746 · Accepted solution]

You do not need those services. they are probably leftovers from Oracle 9i.

[Former Member · Accepted solution]

yes, these are new 10g oracle services, i have deleted the old 9i services.

[former_member204746 · Accepted solution]

again, YOU DO NOT NEED those services, so, do not bother with recreating them.

[Former Member]

Hi,

The first time you install Oracle Database, if you selected Automatic Storage Management as a storage and recovery option, Oracle Universal Installer configures and starts a single-instance version of the Oracle Cluster Synchronization Services (CSS) service.If you did not choose Automatic Storage Management as a storage or recovery option, you can ignore the OracleCSService service.

Becoz of Bug some of services are not created.

You will have to first shutdown the database and stop the database service before running ORADIM -delete from cmd prompt.

Delete and recreate the database service via the 10.2 ORADIM. This will also create the OracleJobSchedulerSID needed... it will be in a disabled status, but you can change that via Computer Management > Services gui.

from cmd prompt ORADIMxx -NEW -SID <SID> -INTPWD <password> -STARTMODE <mode> -PFILE <pfile>

where:

sid is the database SID

password is the password for INTERNAL

mode is the startup mode for the services, either

AUTO or MANUAL

pfile is the full path and name of the

INIT<sid>.ORA file

Review the ORADIM log file for any errors.

Regards

vinod