Relationship between OracleServiceXXX and Oracle instances in windows, oracleservicexe

Relationship between OracleServiceXXX and Oracle instances in windows, oracleservicexe

In fact, oracle in windows is completely dependent on OracleServiceXXX in the window service when the oracle instance is started. This XXX is the oracle Instance name (note that it is not the Database Name, but the Instance name. If you do not understand the meanings of these two names, please contact us .)

 

As long as OracleServiceXXX does not start, sqlplus will never enter. (Ora-12560 error will be reported. But the ora-12560 error may not be caused by OracleServiceXXX not starting)

 

So here is a problem: Does OracleServiceXXX start an oracle instance? Or what is the relationship between OracleServiceXXX and oracle instance startup?

 

Start Windows-Program-oracle --- configuration and porting tool-Administration Assistant for Windows

 

 

 

It is worth noting that the thread can also be killed from here:

 

 

 

In windows, how does one create an Oracle instance at 10 Gb in Oracle?

After 10 Gb of oracle is successfully installed on your local machine, the oracle menu will appear in the windows Start Menu.
Choose start-Oracle-OraDb10g_home1-configure and transplant tool-Database Configuration Assistant ,. A graphical DBCA tool is displayed.
We recommend that you buy a basic book or search for more information on the Internet.
If you are interested, you can find a training course.




How can I create an oracle instance in windows?

1. First install the operating system and database software

2. Copy the original data file, control file, and redo log file for backup.

2. Concerning database restoration,

A. If all the control files, log files, and data files exist, the simplest way is to reinstall the database after installing the software. There are several notes:

1) New Control File Name and Path
New data file name, number
The number of new log file names must be the same as the original one, which can avoid a lot of trouble.

2) After creating a new database, close the new database, delete the newly generated control file, data file, redo log file, and copy the original files back.

3) restart the database.

Note: If the data file of the newly created database is different from the original path, you can start the database to the mount state, then, use alter database rename file 'original path' to 'new path ';