安装完oracle数据库后,没有oracleServiceOrcl服务

gigi-qiqi 2017-09-08 03:52:50
刚刚安装完数据库,只有这几个服务OracleMTSRecoveryService、OracleOraDb11g_home1ClrAgent、OracleOraDb11g_home1TNSListener、OracleRemExecService。
没有oracleServiceOrcl服务,而且运行 connect /as sysdba; 的时候会报错ERROR:ORA-12560: TNS: 协议适配器错误。

请各位大神帮忙解决。
...全文
7349 5 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
minsic78 2017-09-11
  • 打赏
  • 举报
回复 1
楼主,这是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.
gigi-qiqi 2017-09-08
  • 打赏
  • 举报
回复
引用 3 楼 minsic78 的回复:
手工创建服务看看行不行:
oradim -new -sid orcl
sid可以根据你的需要更改,一般与你建库时候的数据库名同名

另外,执行dbca的操作系统用户,是不是在ora_dba组里的?



操作用户在ora_dba组里,试了一下手动加,最后会报错

请问,这是什么问题?

minsic78 2017-09-08
  • 打赏
  • 举报
回复
手工创建服务看看行不行: oradim -new -sid orcl sid可以根据你的需要更改,一般与你建库时候的数据库名同名 另外,执行dbca的操作系统用户,是不是在ora_dba组里的?
gigi-qiqi 2017-09-08
  • 打赏
  • 举报
回复 2
引用 1 楼 minsic78 的回复:
装软件和建库是两回事情,楼主是不是在安装软件的时候选择了:install software only?不过这种分开的方式有好处,数据库可以更多的自定义。
打开dbca看下,是不是还没有数据库。



是没有数据库,但是用dbca安装的时候最后会报错
然后又是ORA-12560: TNS: 协议适配器错误。

请问,这是什么问题?
minsic78 2017-09-08
  • 打赏
  • 举报
回复
装软件和建库是两回事情,楼主是不是在安装软件的时候选择了:install software only?不过这种分开的方式有好处,数据库可以更多的自定义。 打开dbca看下,是不是还没有数据库。

17,382

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧