Shulou(Shulou.com)06/01 Report--

This article introduces the relevant knowledge of "how to install the database with tar". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

To install oracle 10g in tar mode on linux as4 today, the following is a simple way to record the steps and problems during the installation.

Server information where the original database is located:

[oracle@haoc2008 data] $more / etc/issue

Red Hat Enterprise Linux ES release 4 (Nahant)

Kernel\ r on an\ m

[oracle@haoc2008 data] $uname-a

Linux haoc2008 2.6.9-5.ELsmp # 1 SMP Wed Jan 5 19:29:47 EST 2005 x86'64 GNU/Linux

Server information where the new database is located:

[root@yans2 soft] # more / etc/issue

Enterprise Linux Enterprise Linux AS release 4 (October Update 4)

Kernel\ r on an\ m

[root@yans2 soft] # uname-a

Linux yans2 2.6.9-42.0.0.0.1.ELsmp # 1 SMP Sun Oct 15 15:13:57 PDT 2006 x86 "64 GNU/Linux

The two operating systems are different, but not a big problem.

1. Add users to the new server

Groupadd oinstall

Useradd-g oinstall oracle

2. Add relevant directories on the new server

Mkdir-p / data/oracle/product

3. Set core parameters

Vi / etc/sysctl.conf, add

Kernel.shmall = 2097152

Kernel.shmmax = 8589934592

Kernel.shmmni = 4096

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

To make the settings take effect:

Sysctl-p

4. Modify the environment variables of oracle users

Su-oracle

Vi .bash _ profile add:

Export ORACLE_SID=newdemo

Export ORACLE_BASE=/data/oracle

Export ORACLE_HOME=/data/oracle/product/10.2

Export PATH=$ORACLE_HOME/bin:$PATH

Export NLS_LANG= "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

5. Package the program on the original server

Package and compress the things under $ORACLE_HOME:

Cd $ORACLE_BASE/product

Tar cfz oracle10203.tar 10.2

6. Transfer to the new server and decompress

Sftp.

Cd $ORACLE_BASE/product

Tar-xzfv oracle10203

7. Modify the owner of the decompressed file

[root@yans2 oracle] # chown-R oracle:oinstall / data/

Chown: changing ownership of `/ data/oracle/product/10.2/rdbms/filemap': No such file or directory

There is an error indicating that the file does not exist. It is checked that this is a soft link:

[root@yans2 oracle] # ls-l / data/oracle/product/10.2/rdbms/filemap

Lrwxrwxrwx 1 root root 22 Jan 10 17:22 / data/oracle/product/10.2/rdbms/filemap-> / opt/ORCLfmap/prot1_64

After checking, the / opt/ORCLfmap directory does not exist on the current system. In fact, / opt/ORCLfmap is generated by root.sh. Delete this soft link first:

Rm-f / data/oracle/product/10.2/rdbms/filemap

Re-execute the root.sh:

[root@yans2 opt] # / data/oracle/product/10.2/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= / data/oracle/product/10.2

Enter the full pathname of the local bin directory: [/ usr/local/bin]:

Copying dbhome to / usr/local/bin...

Copying oraenv to / usr/local/bin...

Copying coraenv to / usr/local/bin...

Creating / etc/oratab file...

Entries will be added to the / etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Both the soft connection and the directory already exist:

[root@yans2 opt] # ls / data/oracle/product/10.2/rdbms/filemap

Bin etc log

[root@yans2 opt] # ls-l / data/oracle/product/10.2/rdbms/filemap

Lrwxrwxrwx 1 root root 22 Jan 10 17:40 / data/oracle/product/10.2/rdbms/filemap-> / opt/ORCLfmap/prot1_64

8. Create a database

Run dbca and set it up step by step.

9. Clean up the original network related files, original password files, etc.

Problems encountered in the process:

1. Chown: changing ownership of `/ data/oracle/product/10.2/rdbms/filemap': No such file or directory

This problem has been described above and I will not repeat it here.

2. Exception in thread "main" java.lang.UnsatisfiedLinkError: / data/oracle/product/10.2/jdk/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory

Execution of dbca Times error:

[oracle@yans2 ~] $dbca

Exception in thread "main"

[oracle@yans2 ~] $

There are very few error messages here, and it is impossible to determine the cause. If you execute netca, you can see more error messages:

[oracle@yans2 bin] $netca

Exception in thread "main" java.lang.UnsatisfiedLinkError: / data/oracle/product/10.2/jdk/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object 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. (DebugHelper.java:29)

At java.awt.Component. (Component.java:506)

This problem is mainly caused by the lack of a package xorg-x11-deprecated-libs. Just install the package:

[root@yans2 soft] # rpm-ivh xorg-x11-deprecated-libs-6.8.2-1.EL.13.37.i386.rpm

Warning: xorg-x11-deprecated-libs-6.8.2-1.EL.13.37.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516

Preparing... # [100%]

1:xorg-x11-deprecated-lib### [100%]

Note: although the system is 64-bit, 32-bit packages will be installed here.

3. ORA-12547: TNS: lost connection

Before creating the database, simply test whether sqlplus is working and find this problem:

[oracle@yans2 ~] $sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.3.0-Production on Thursday 10 January 17:51:35 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Oraclenewdemo: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

ERROR:

ORA-12547: TNS: lost connection

Please enter a user name:

The cause of the problem is the libaio system package, which can be installed:

[root@yans2 soft] # ls

Libaio-0.3.105-2.i386.rpm libaio-0.3.105-2.x86_64.rpm libaio-devel-0.3.105-2.x86_64.rpm

[root@yans2 soft] # rpm-ivh *

Warning: libaio-0.3.105-2.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516

Preparing... # [100%]

1:libaio # [33%]

2:libaio # [67%]

3:libaio-devel # # [100%]

Similarly, two 32-bit packages need to be installed here.

4 、 ORA-01031: insufficient privileges

[oracle@yans2 ~] $sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.3.0-Production on Friday January 11 10:48:35 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:

ORA-01031: insufficient privileges

Please enter a user name:

This problem is caused by inconsistent user groups.

Original library:

[oracle@haoc2008 oraInventory] $id-a

Uid=500 (oracle) gid=500 (oinstall) groups=500 (oinstall), 501 (dba) context=user_u:system_r:unconfined_t

New library:

[oracle@yans2 oraInventory] $id-a

Uid=500 (oracle) gid=500 (oinstall) groups=500 (oinstall) context=user_u:system_r:unconfined_t

Just add groups for oracle users on the new library:

[root@yans2 ~] # usermod-G dba oracle

This is the end of the content of "how to install the database in tar". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.