(Transfer) Reconstruction of Oracle services using ORADIM

zhaozj2021-02-16  69

In the Windows system, Oracle's database will not be automatically started automatically, but manual startup is ok, in which case we can try to recreate Oracle services to see if the problem can be resolved.

Rebuilding Oracle services You can use ORADIM usage programs with Oracle under Windows operating systems.

The SID of the database can be found in the following method:

Check the service name similar to ORACleServicexxxx, find the Database's SID. For example, if the SID of the database is Test, the service name is OraclesERVICETEST.

Suppose our Oracle instance name is TEST, the parameter file used is c: /oracle/admin/test/inittest.ora

Then we do the following command:

ORADIM -EDIT -SID TEST -PFILE C: / Oracle/admin/test/inittest.ora -startmode auto -srvcstart system system

Then restart the service to see if the Oracle database can start automatically

转载请注明原文地址:https://www.9cbs.com/read-17599.html

New Post(0)