Linux平台Oracle多个实例启动说明

╰+攻爆jí腚メ 2022-01-21 04:19 677阅读 0赞

如何在[Linux][]系统中启动多个Oracle实例？相信很多Oracle的初学者都会碰到这一类问题，下面我简单介绍一下。

1.切换Oracle用户：

\# su oracle

2.切换到Oracle目录下：

\#  cd $oracle\_home

3.执行配置文件 .bash\_profile

\[oracle@db ~\]$ ..bash\_profile

4. 查看参数是否已经配置成功

Echo$oracle\_home

Echo $oracle\_sid

5.启动[数据库][Link 1]实例

\#sqlplus  /nolog

\#conn /as sysdba

\#startup

\#exit

6.  启动监听程序

执行 lsnrctl start

7.  启动另外一个数据库,先修改参数

export ORACLE\_SID=devdb

然后重复步骤4-6

摘自 gavinloo的专栏

第二种

因为工作的需要，需要在一台LINUX下安装ORACLE的另外一个实例。  
  
在得到众多网友帮助之后，终于解决以下问题  
  
一，安装新的实例  
用linux账户oracle登录，找到bin目录下的dbca，然后创建了。默认是用pfile(init.ora)方式启动的.  
  
二，解决启动多个实例的问题。  
后来需要重启，于是：  
使用oracle远程登录(telnet),然后执行  
export ORACLE\_SID=SID2  
sqlplus /nolog  
conn /as sysdba  
startup  
  
三,修改SGA  
首先需要修改启动方式:  
CREATE SPFILE='/ORACLE/SPFILESID2.ORA' FROM PFILE;  
SHUTDOWN IMMEDIATE  
STARTUP  
ALTER SYSTEM SET SGA\_MAX\_SIZE=3072M SCOPE=SPFILE (scope=memory|spfile|both)  
SHUTDOWN IMMEDIATE  
STARTUP  
ALTER SYSTEM SET SGA\_TARGET=3072M

dbca创建多实例

dbca需要图形界面的支持
    先输入   xclock  看看可不可以弹出一个小闹钟出来，那么说明可以启用图形界面了
    如果看不到小闹钟 输入 export DISPLAY=192.168.8.1:0.0    (192.168.8.1是你进行操作的系统IP) 
    然后就可以dbca启用图形界面 进行操作了
    祝你顺利

提问者评价

xhost +

另一种说法“：

先看看 使用帐号正确不，一般是oracle（用来安装的用户）用户。
    然后在 root 用户下，执行命令： xhost +（xhost空格+）。
    在切到oracle 用户下，执行dbca。

首先在你的root用户下执行xhost +命令，允许其他用户使用图形界面，然后su - oracle，在oracle用户下运行命令dbca 之后会跳出图形界面 根据提示继续即可

另一个问题。。。。

**问题描述**

安装软件成功后，安装过程无报错，执行dbca报下面错，建库的界面出不来

\[oracle2@kvm14-10 ~\]$ dbca

Exception in thread "main"

\[oracle2@kvm14-10 ~\]$

**问题诊断**

查看dbca安装日志，发现为缺少包引起的

\[oracle2@kvm14-10 bin\]$ cd $ORACLE\_HOME/cfgtoollogs/dbca  
\[oracle2@kvm14-10 dbca\]$ more trace.log  
java.lang.UnsatisfiedLinkError: /opt/software/oracle2/product/10.2.0/jdk/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared obje  
ct file: No such file or directory  
at java.lang.ClassLoader$NativeLibrary.load(Native Method)  
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1586)  
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1503)  
at java.lang.Runtime.loadLibrary0(Runtime.java:788)  
at java.lang.System.loadLibrary(System.java:834)  
at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:50)  
at java.security.AccessController.doPrivileged(Native Method)  
at sun.awt.NativeLibLoader.loadLibraries(NativeLibLoader.java:38)  
at sun.awt.DebugHelper.<clinit>(DebugHelper.java:29)  
at java.awt.Component.<clinit>(Component.java:506)  
at oracle.sysman.assistants.util.wizard.WizardObject.<init>(WizardObject.java:64)  
at oracle.sysman.assistants.dbca.ui.DBCAWizard.<init>(DBCAWizard.java:425)  
at oracle.sysman.assistants.dbca.ui.UIHost.<init>(UIHost.java:214)  
at oracle.sysman.assistants.dbca.ui.InteractiveHost.<init>(InteractiveHost.java:54)  
at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:160)  
at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:94)  
at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)

**解决方案**

根据上面报错说明缺少包,到安装光盘的Packages下面找到相关的32位的包并执行安装

cd /redhat6/Packages/

\[root@kvm14-10 Packages\]\# rpm -ivh libXp-1.0.0-15.1.el6.i686.rpm

warning: libXp-1.0.0-15.1.el6.i686.rpm: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY

Preparing...                \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]

1:libXp                  \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]

\[root@kvm14-10 Packages\]\#

如果没有光盘，服务器配置了yum或可以连接外网，也可以使用yum安装这个32位的包

安装完之后执行dbca后成功。

上面同样的问题：

# oracle dbca报Exception in thread main 问题解决一例 #

[上一篇][Link 2] / [下一篇][Link 3]  2010-07-26 13:14:51 / 个人分类：[oracle学习][oracle]

[查看( 2855 )][2855] /  [评论( 5 )][5] /  [评分( 21 / 0 )][21_0]

Linux操作系统上安装[oracle][oracle 1] [10g][oracle 1]，在启动dbca的时候报 Exception in thread "main" 错误，详细内容如下：

<table style="word-break:break-all"> 
 <tbody style="word-break:break-all"> 
  <tr style="word-break:break-all"> 
   <td style="word-break:break-all">[oracle@centos ~]$ dbca<br style="word-break:break-all"> Exception in thread "main"<br style="word-break:break-all"> [oracle@rac1 ~]$</td> 
  </tr> 
 </tbody> 
</table>

经检查dbca的log如下：

<table style="word-break:break-all"> 
 <tbody style="word-break:break-all"> 
  <tr style="word-break:break-all"> 
   <td style="word-break:break-all">[oracle@centos ~]$ cd $ORACLE_HOME/cfgtoollogs/dbca<br style="word-break:break-all"> <br style="word-break:break-all"> [oracle@centos dbca]$ vi trace.log<br style="word-break:break-all"> <span style="color:#ff0000; word-break:break-all"><a href="http://space.itpub.net/8183550/viewspace-669459" style="word-break:break-all; color:rgb(0,153,153)" rel="nofollow"><span style="word-break:break-all"><span style="word-break:break-all">java</span></span></a>.lang.UnsatisfiedLinkError: /u01/app/oracle/product/10.2.0/db_1/jdk/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory</span><br style="word-break:break-all"> at java.lang.ClassLoader$NativeLibrary.load(Native Method)<br style="word-break:break-all"> at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1586)<br style="word-break:break-all"> at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1503)<br style="word-break:break-all"> at java.lang.Runtime.loadLibrary0(Runtime.java:788)<br style="word-break:break-all"> at java.lang.System.loadLibrary(System.java:834)<br style="word-break:break-all"> at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:50)<br style="word-break:break-all"> at java.security.AccessController.doPrivileged(Native Method)<br style="word-break:break-all"> at sun.awt.NativeLibLoader.loadLibraries(NativeLibLoader.java:38)<br style="word-break:break-all"> at sun.awt.DebugHelper.(DebugHelper.java:29)<br style="word-break:break-all"> at java.awt.Component.(Component.java:506)<br style="word-break:break-all"> at oracle.sysman.assistants.util.wizard.WizardObject.(WizardObject.java:64)<br style="word-break:break-all"> at oracle.sysman.assistants.dbca.ui.DBCAWizard.(DBCAWizard.java:425)<br style="word-break:break-all"> at oracle.sysman.assistants.dbca.ui.UIHost.(UIHost.java:214)<br style="word-break:break-all"> at oracle.sysman.assistants.dbca.ui.InteractiveHost.(InteractiveHost.java:54)<br style="word-break:break-all"> at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:160)<br style="word-break:break-all"> at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:94)<br style="word-break:break-all"> at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)</td> 
  </tr> 
 </tbody> 
</table>

注意标记为红色的行，确认是缺少libXp.so，解决方法是找到Linux安装盘，安装libXp包，问题解决

[安装][oracle 1]过程如下：

\[root@oraclebk ~\]\# yum install libXp  
Loaded plugins: security  
Setting up Install Process  
Resolving Dependencies  
\--> Running transaction check  
\---> Package libXp.i386 0:1.0.0-8.1.el5 set to be updated  
\---> Package libXp.x86\_64 0:1.0.0-8.1.el5 set to be updated  
\--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================  
 Package                    Arch                        Version                              Repository                 Size  
=============================================================================================================================  
Installing:  
 libXp                      i386                        1.0.0-8.1.el5                        base                       23 k  
 libXp                      x86\_64                      1.0.0-8.1.el5                        base                       23 k

Transaction Summary  
=============================================================================================================================  
Install      2 Package(s)          
Update       0 Package(s)          
Remove       0 Package(s)

Total download size: 45 k  
Is this ok \[y/N\]: y  
Downloading Packages:  
(1/2): libXp-1.0.0-8.1.el5.i386.rpm                                                                   |  23 kB     00:00      
(2/2): libXp-1.0.0-8.1.el5.x86\_64.rpm                                                                 |  23 kB     00:00      
\-----------------------------------------------------------------------------------------------------------------------------  
Total                                                                                         69 kB/s |  45 kB     00:00      
Running rpm\_check\_debug  
Running Transaction Test  
Finished Transaction Test  
Transaction Test Succeeded  
Running Transaction  
  Installing     : libXp                                                                                                 1/2  
  Installing     : libXp                                                                                                 2/2

Installed:  
  libXp.i386 0:1.0.0-8.1.el5                                   libXp.x86\_64 0:1.0.0-8.1.el5

Complete!

[Linux]: http://www.2cto.com/os/linux/
[Link 1]: http://www.2cto.com/database/
[Link 2]: http://space.itpub.net/batch.common.php?action=viewspace&op=up&itemid=669459&uid=8183550
[Link 3]: http://space.itpub.net/batch.common.php?action=viewspace&op=next&itemid=669459&uid=8183550
[oracle]: http://space.itpub.net/8183550/spacelist-blog-itemtypeid-81209
[2855]: http://space.itpub.net/8183550/viewspace-669459#xspace-tracks
[5]: http://space.itpub.net/8183550/viewspace-669459#xspace-itemreply
[21_0]: http://space.itpub.net/8183550/viewspace-669459#xspace-itemform
[oracle 1]: http://space.itpub.net/8183550/viewspace-669459