安裝完oracle資料庫后，沒有oracleServiceOrcl服務-有解無憂

剛剛安裝完資料庫，只有這幾個服務OracleMTSRecoveryService、OracleOraDb11g_home1ClrAgent、OracleOraDb11g_home1TNSListener、OracleRemExecService。
沒有oracleServiceOrcl服務，而且運行 connect /as sysdba; 的時候會報錯ERROR:ORA-12560: TNS: 協議配接器錯誤。

請各位大神幫忙解決。

uj5u.com熱心網友回復：

裝軟體和建庫是兩回事情，樓主是不是在安裝軟體的時候選擇了：install software only？不過這種分開的方式有好處，資料庫可以更多的自定義。
打開dbca看下，是不是還沒有資料庫。

uj5u.com熱心網友回復：

參考 1 樓 minsic78 的回復:

裝軟體和建庫是兩回事情，樓主是不是在安裝軟體的時候選擇了：install software only？不過這種分開的方式有好處，資料庫可以更多的自定義。
打開dbca看下，是不是還沒有資料庫。

是沒有資料庫，但是用dbca安裝的時候最后會報錯

然后又是ORA-12560: TNS: 協議配接器錯誤。

請問，這是什么問題？

uj5u.com熱心網友回復：

手工創建服務看看行不行：
oradim -new -sid orcl
sid可以根據你的需要更改，一般與你建庫時候的資料庫名同名

另外，執行dbca的作業系統用戶，是不是在ora_dba組里的？

uj5u.com熱心網友回復：

參考 3 樓 minsic78 的回復:

手工創建服務看看行不行：
oradim -new -sid orcl
sid可以根據你的需要更改，一般與你建庫時候的資料庫名同名

另外，執行dbca的作業系統用戶，是不是在ora_dba組里的？

操作用戶在ora_dba組里，試了一下手動加，最后會報錯

請問，這是什么問題？

uj5u.com熱心網友回復：

樓主，這是MOS上的一篇檔案，看看是否對你有幫助：

參考

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

In this Document
Goal
Solution
References
APPLIES TO:

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)

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

SOLUTION

Solution 1: User must be a Local Administrator

User must be a Local Administrator in order to install Oracle products on a Windows NT/2000 Server (or more recent). User must be a Domain Administrator to install Oracle products on a Domain Controller (PDC or BDC). DIM-00019 errors can be resolved by connecting to Windows NT/2000 machine as an appropriately privileged 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 "windom" domain, then this account must appear in the Local Administrators group:

WINDOM\dbuser

Most of the time, a domain account added to Local Administrators and local ORA_DBA groups offers sufficient privileges to connect as SYS as SYSDBA. (Doc ID 2016452.1) 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 12c databases due to unpublished BUG 19450700 - ORADIM FAILS WITH DIM-19 AND O/S-ERROR: (OS 87/1060) ON DOMAIN CONTROLLER.
This bug is fixed in Windows DB Bundle Patch 12.1.0.1.0 .

Workaround:
Add domain user as "Oracle Home User" to group "Domain Admins" via Active Directory admin console, and restart OracleService<SID>

Start OracleService<SID> manually when DBCA reports error and then click "OK" on DBCA.

Solution 4: Ensure proper installation

If this is a new Oracle installation, or newly upgraded software, then ensure that 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.

轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/83883.html

標籤：基礎和管理

上一篇：資料庫監聽日志一直在刷報錯

下一篇：如何撰寫日期條件是<=的一段時間的資料的SQL