Oracle XE数据库配置失败 [英] Oracle XE Database Configuration failed

问题描述

我试图在我的vps中创建一个oracle xe数据库。

VPS操作系统：Cent操作系统。

尝试运行

  /etc/init.d/oracle-xe configure 
  

$ b b

它抛出一个错误数据库confiration失败，并检查日志，但日志只显示
ORA-01034：ORACLE不可用

...

  [root @ vmcx-43 Disk1]＃rpm -ivh oracle-xe-11.2.0-1.0.x86_64 .rpm 
准备... ######################################## ### [100％] 
 /var/tmp/rpm-tmp.51363：line 186：bc：未找到命令
 1：oracle-xe /var/tmp/rpm-tmp.51363：第186行：bc：command not fo und ######################################### ## [100％] 
执行安装后步骤... 
 
 /var/tmp/rpm-tmp.97984：第76行：bc：未找到命令
 / var / tmp / rpm-tmp.97984：line 77：bc：command not found 
 /var/tmp/rpm-tmp.97984：line 78：[：-gt：unary operator expected 
 / var /tmp/rpm-tmp.97984：line 82：bc：command not found 
 
必须以root用户身份运行'/etc/init.d/oracle-xe configure'以配置数据库。 
 
 [root @ vmcx-43 Disk1]＃/etc/init.d/oracle-xe configure 
 
 Oracle数据库11g快速版配置
 ---- --------------------------------------------- 
这将配置Oracle数据库11g Express的on-boot属性
 Edition。以下问题将决定数据库是否
将在系统引导时启动，它将使用的端口以及
将用于数据库帐户的密码。按< Enter>接受默认值。 
 Ctrl-C将中止。 
 
指定将用于Oracle Application Express [8080]的HTTP端口：
 
指定将用于数据库侦听器的端口[1521]：
 
指定要用于数据库帐户的密码。请注意，相同的
密码将用于SYS和SYSTEM。 Oracle建议对每个数据库帐户使用
个不同的密码。这可以在
初始配置后完成：
密码不能为空。输入密码：
密码不能为空。输入密码：
确认密码：
 
是否要在启动时启动Oracle数据库11g快速版（y / n）[y]：n 
 
启动Oracle Net Listener ...完成
配置数据库... 
数据库配置失败。查看/u01/app/oracle/product/11.2.0/xe/config/log了解详情
 
 [root @ vmcx-43 Disk1]＃cd /u01/app/oracle/product/11.2 .0 / xe / config / log 
 [root @ vmcx-43 log]＃ls 
 CloneRmanRestore.log cloneDBCreation.log postDBCreation.log postScripts.log 
 
 [root @ vmcx -43 log]＃tail postScripts.log 
 
 
 commit 
 * 
第1行的错误：
 ORA-01034：ORACLE不可用
进程ID：0 
会话ID：0序列号：0 
 
 
 [root @ vmcx-43 log]＃tail CloneRmanRestore.log 
 
 
选择TO_CHAR（systimestamp，'YYYYMMDD HH：MI：SS'）from dual 
 * 
错误在第1行：
 ORA-01034：ORACLE不可用
 ID：0 
会话ID：0序列号：0 
  

解决方案>

将您的服务器名称和IP添加到/ etc / hosts文件

I am trying to create an oracle xe database in my vps.

VPS OS : Cent OS.

When try to run

/etc/init.d/oracle-xe configure

it throws an error Database confiration failed and to check the logs but logs just shows ORA-01034: ORACLE not available

Below is the history...

[root@vmcx-43 Disk1]# rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
Preparing...                ########################################### [100%]
/var/tmp/rpm-tmp.51363: line 186: bc: command not found
   1:oracle-xe              /var/tmp/rpm-tmp.51363: line 186: bc: command not fo                                        und########################################### [100%]
Executing post-install steps...

/var/tmp/rpm-tmp.97984: line 76: bc: command not found
/var/tmp/rpm-tmp.97984: line 77: bc: command not found
/var/tmp/rpm-tmp.97984: line 78: [: -gt: unary operator expected
/var/tmp/rpm-tmp.97984: line 82: bc: command not found

You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.

[root@vmcx-43 Disk1]# /etc/init.d/oracle-xe configure

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Password can't be null. Enter password:
Password can't be null. Enter password:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]: n

Starting Oracle Net Listener...Done
Configuring database...
Database Configuration failed.  Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

[root@vmcx-43 Disk1]# cd /u01/app/oracle/product/11.2.0/xe/config/log
[root@vmcx-43 log]# ls
CloneRmanRestore.log  cloneDBCreation.log  postDBCreation.log  postScripts.log

[root@vmcx-43 log]# tail postScripts.log


commit
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


[root@vmcx-43 log]# tail CloneRmanRestore.log


select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

解决方案

Add your servers name and IP to the /etc/hosts file

这篇关于Oracle XE数据库配置失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！