After installing the oracle database, no oracleServiceOrcl service-CodePudding

Just finished the installation database, only a few service OracleMTSRecoveryService OracleOraDb11g_home1ClrAgent, OracleOraDb11g_home1TNSListener, OracleRemExecService,
No oracleServiceOrcl services, and run the connect/as sysdba; When an ERROR: ORA - 12560: TNS: protocol adapter ERROR,

A great god please help solve,

CodePudding user response:

Install software and database construction are two different things, the original poster is when install the software to choose: install the software only? But this way of separate is good, the database can be more custom,
Open the dbca see, still no database,

CodePudding user response:

reference 1st floor minsic78 response:

software and database construction are two different things, the original poster is choice: when install the software install software only? But this way of separate is good, the database can be more custom,
Open the dbca see, still no database,

There is no database, but use dbca installation last complains

Then the ORA - 12560: TNS: protocol adapter error,

Excuse me, what's the problem?

CodePudding user response:

Look at the line not line manually create service:
Oradim - new - sid former
Sid can according to your need to change, and you build library database name

In addition, perform the dbca operating system user, in the ora_dba group?

CodePudding user response:

reference minsic78 reply: 3/f

look line not line manually create service:
Oradim - new - sid former
Sid can according to your need to change, and you build library database name

In addition, perform the dbca operating system user, in the ora_dba group?

Users in the ora_dba group operation, tried to manually add, finally complains

Excuse me, what's the problem?

CodePudding user response:

The building Lord, this is a document on the MOS, see whether helpful to you:

The

reference

IF: How to Resolve DIM - 00019: Create Service Error (Doc ID 2016492.1)
Modified: 09 - Sep - 2016 Type: HOWTO
What this document Email link to this document the Open document in new Windows Printable Page

In this Document
Goal
Solution
The References
APPLIES TO:

The Oracle Database Enterprise Edition - Version 9.2.0.1 and later
Microsoft Windows x64 (64 - bit)
Microsoft Windows (32 - bit)
* * * Checked for relevance on 09 - Sep - 2016 * * *
GOAL

This document is to summarize the various causes for DIM - 00019 errors and their solutions, while creating Oracle service in Windows using ORADIM utility.

DIM - 00019: create service error
O/S - Error: (OS 1053) The service did not respond to The start or control request in a timely fashion.
(OR)

The Error in the Process of h: \ app \ OracleWinUser \ product \ 12.1.0 \ dbhome_1 \ bin \ oradim exe
Enter the password for the Oracle server user:
DIM - 00019: create service error
O/S - Error: (OS 87), the parameter is incorrect

SOLUTION

Solution 1: the User must be a Local Administrator

The User must be a Local Administrator in order to install Oracle products on a Windows NT/2000 Server (or more recent). The User must be a Domain Administrator to install Oracle products on a Domain Controller (PDC or data). DIM - 00019 errors can be resolved by connecting to Windows NT/2000 machine as an appropriately ring User.

Solution 2: Ensure sufficient privileges

Adding the Domain Administrators group to the Local Administrators group is not sufficient for operating system authentication of the SYS as SYSDBA user. The same individual Domain administrator account must also be a member of the Local ORA_DBA group as well.

If the individual domain administrator account is called "dbuser" in the domain of "windom", then this account must appear in the Local Administrators group:

WINDOM \ dbuser

Most of the time, a domain account added to the Local Administrators and Local ORA_DBA groups offers sufficient privileges to connect as SYS as SYSDBA. (2016452.1) Doc ID provided more details regarding this.

Solution 3: Have fix (or workaround) for Bug 19450700 in place.

DIM - 00019 error accompanied by 'O/S - error: (OS 87), the parameter is incorrect' can be observed in 12 c databases due to unpublished BUG 19450700 - ORADIM FAILS WITH DIM - 19 AND O/S - error: 87/1060 (OS) ON the DOMAIN CONTROLLER.
This bug is fixed Windows in the DB Bundle Patch 12.1.0.1.0.

Workaround:
The Add domain user as "Oracle Home user to" group "domain Admins" via the Active Directory admin console, and restart OracleService

Start OracleService Manually when DBCA reports the error and then click "OK" on DBCA.

Solution 4: Ensure the proper installation

If this is a new Oracle installation, or newly upgraded software, then ensure that the installation is done correctly. Else, Redo the Base release installation and apply the desired Database patchset software.
Invoke the DBUA utility again to upgrade the database.