VMWare下安装linux及oracle

Tar –xzvftest.tat.gz解压VMWtll

1 因为在前面我们并没有安装相应的包，所以此时肯定会出错误
1. Exception in thread "main" java.lang.UnsatisfiedLinkError:/tmp/OraInstall2010-11-04_09-24-31AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6:cannot open shared object file: No such file or directory
        atjava.lang.ClassLoader$NativeLibrary.load(Native Method)
        atjava.lang.ClassLoader.loadLibrary0(Unknown Source)
        atjava.lang.ClassLoader.loadLibrary(Unknown Source)
        atjava.lang.Runtime.loadLibrary0(Unknown Source)
        atjava.lang.System.loadLibrary(Unknown Source)
        atsun.security.action.LoadLibraryAction.run(Unknown Source)
        atjava.security.AccessController.doPrivileged(Native Method)
        atsun.awt.NativeLibLoader.loadLibraries(Unknown Source)
        atsun.awt.DebugHelper.<clinit>(Unknown Source)
        atjava.awt.Component.<clinit>(Unknown Source)
这是因为没有安装libXp包，所以不能显示图形化安装界面。安装libXp包， rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm
----如果在安装包的过程中出错。如：warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, keyID*****。执行rpm --import /etc/pki/rpm-gpg/RPM*  (只需执行一遍)，然后在安装包即可

此时会弹出图形化安装界面，第一步的时候不要选中“createstarter database”这个选项，等安装完软件后再人工创建数据库

2 Exception in thread "main"java.lang.InternalError: Can't connect to X11 window server using ':0.0' as thevalue of the DISPLAY variable.

       at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)

       at sun.awt.X11GraphicsEnvironment.<clinit>(Unknown Source)

       at java.lang.Class.forName0(Native Method)

       at java.lang.Class.forName(Unknown Source)

       at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(UnknownSource)

       at java.awt.Window.init(Unknown Source)

       at java.awt.Window.<init>(Unknown Source)

       at java.awt.Frame.<init>(Unknown Source)

       at oracle.ewt.popup.PopupFrame.<init>(Unknown Source)

       at oracle.ewt.lwAWT.BufferedFrame.<init>(Unknown Source)

       at oracle.sysman.oio.oioc.OiocOneClickInstaller.<init>(OiocOneClickInstaller.java:378)

       atoracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2091)

你现在root用户下执行#:xhost +
然后切换成oracle用户:su - oracle
在执行：./run````试下，这样一般是可以把图形界面调出来了

1 Root用户：创建用户

创建组oinstall,dba,用户oracle

[root@node1 ~]# groupadd oinstall

[root@node1 ~]# groupadd dba

[root@node1 ~]# useradd  -g oinstall -G dba oracle

Passwd oracle

 

 

2root创建指定目录

[root@node1 ~]# mkdir –p /u01/oracle

　　由于该目录主要由oracle用户操作，因此我们将其所有者改为oracle

[root@node1 ~]# chown oracle.oinstall /u01/oracle

 

3rootx修改内核参数

Vim  /etc/sysctl.conf

# semaphores: semmsl, semmns,semopm, semmni

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range =1024 65000

net.core.rmem_default=262144

net.core.rmem_max=262144

net.core.wmem_default=262144

net.core.wmem_max=262144

sysctl -p

Xhost +                   任何账户都可以连接窗口

 

4oracle用户改变量

vi /home/oracle/.bash_profile

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=$ORACLE_BASE/10g

export ORACLE_SID=orcl

export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin

 

5安装oracle

Unzip / -d mnt/

oracle账号安装(安装oracle‘之前要退出再登陆)

在 node2 上执行：/u01/ora10g/oraInventory/orainstRoot.sh; 

在 node1 上执行：/u01/ora10g/product/10.2.0/crs_1/root.sh; 

 

The Database Control URL is http://localhost.localdomain:1158/em

SQL*Plus URL:

http://localhost.localdomain:5560/isqlplus

 

iSQL*Plus DBA URL:

http://localhost.localdomain:5560/isqlplus/dba

 

Enterprise Manager 10g Database ControlURL:

http://localhost.localdomain:1158/em

 

 

ORCL =

 (DESCRIPTION =

   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))

   (CONNECT_DATA =

     (SERVER = DEDICATED)

     (SERVICE_NAME = orcl)

    )

  )

 

EXTPROC_CONNECTION_DATA =

 (DESCRIPTION =

   (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

    )

   (CONNECT_DATA =

     (SID = PLSExtProc)

     (PRESENTATION = RO)

    )

  )

 

Xp中dqldev怎么连接虚拟机的oracle

1 虚拟机要自动获取ip， DNS好像问题不大，可以不管

然后是修改有效/etc/rc.d/init.d/network restart

2 startup oracle服务/然后

3、启动监听器
oracle@suse92:~> lsnrctl start
4、停止监听器
oracle@suse92:~> lsnrctl stop
5、查看监听器状态
oracle@suse92:~> lsnrctl

启动监听

在客户端配置tnsnames.ora信息（注，要写IP地址，不要写主机名，不知道为什么主机名不行）

ORCL =

 (DESCRIPTION =

   (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))

    )

   (CONNECT_DATA =

         (SERVER= DEDICATED)

      (SERVICE_NAME = orcl)                                                  

    )

  )