Oracle 9ir2 (9.2.0.4) Database On Red Hat Advanced Server 3 (kernel 2.4.21-4.el)
First, the operating environment:
Red Hat Advanced Server 3 (kernel 2.4.21-4.el)
Oracle 9iR2 (9.2.0.4)
Second, the software you need:
SHIP_9204_LINUX_DISK1.CPIO.GZ
SHIP_9204_LINUX_DISK2.CPIO.GZ
SHIP_9204_LINUX_DISK3.CPIO.GZ
P3006854_9204_linux.zip
Note: It is best to move the above file to the main directory / home / oracle of the Oracle user.
Third, add groups and users:
#su - root
#groupadd dba # group of users to be granted with sysdba system privilege
#groupadd oinstall # group Owner of Oracle Files General This group can also be added
# useradd -g oinstall -g dba oracle
#passwd oracle
Note: In practice, I set the group to Oracle, everything is normal!
Fourth, generate an Oracle home directory:
#CD / OPT
#mkdir oracle
#Chown -r Oracle.Oracle / OPT
5. # vi /etc/sysctl.conf,
In Kernel.SysRQ = 0, increase kernel.shmmax = 1073741824
Kernel.sysrq = 0
Kernel.shmmax = 1073741824
6. Set environment variables:
# vi /Home/oracle/.bash_profile # is the .bash_profile file under Oracle users
Export Oracle_Base = / OPT / ORACLE # is changed according to your actual installation directory, but generally install / opt under OPT
Export Oracle_Home = / OPT / ORACLE # is changed according to your actual installation directory, but generally install / opt under OPT
Export Oracle_sid = Babo1 # can define themselves
Export ORA_NLS33 = $ Oracle_Home / Ocommon / NLS / Admin / Data
Export TNS_ADMIN = $ Oracle_Home / Network / Admin / Admin / Admin
Export ld_library_path = $ ld_library_path: $ Oracle_Home / Lib: / USR / LIB: / USR / LOCAL / LIB
Export NLS_LANG = American_america.us7ascii
Export path = $ path: / usr / sbin: / usr / bin: / bin: / $ oracle_home / bin
Export editor = vi
Export Display = 127.0.0.1: 0.0
Export ld_assume_kernel = 2.4.1
Seven, confirm developing packages (rpms):
# rpm -q GCC CPP Compat-LibSTDC Glibc-Devel Glibc-Headers Glibc-Kernheaders BinUtils
* Increase the method of the RPM package, in the third disk CD:
#su - root
RPM-IVH
Compat-libstdc - 7.3-2.96.122.i386.rpm
Compat-libstdc - devel-7.3-2.96.122.i386.rpm
Setarch-1.3-1.i386.rpm (in the second CD)
Tcl-8.3.5-92.i386.rpm (in the second CD)
OpenMotiF21-2.1.30-8.i386.rpm
Compat-DB-4.0.14-5.i386.rpm
Compat-GCC-7.3-2.96.122.i386.rpm
COMPAT-GCC-C - 7.3-2.96.122.i386.rpm
Note: When the above packaging is in order, there is a mutual dependency relationship, otherwise it will be wrong!
Eight, loaded file:
Su - root
# unzip p3006854_9204_linux.zip
# CD 3006854
# sh rhel3_pre_install.sh
Applying Patch ...
Patch SuccessFully Applied
Note: If you don't play this patch file, you will have the following error tips when running RunInstaller:
Error Occurred During Initialization Of VM
Unable to load native library: /tmp/orainstall2003-10-25_03-14-57pm/jre/lib/i386/libjava.so:
Symbol __libc_wait, version glibc_2.0 not defined in file libc.so.6 with link time reference
Nine, installation:
#CD / HOME / ORACLE
#zzcat lnx_920_disk1.cpio.gz | CPIO -IDMV
#zcat lnx_920_disk2.cpio.gz | CPIO -IDMV
#zzcat lnx_920_disk3.cpio.gz | CPIO -IDMV
Then generate three folders: Disk1, Disk2, Disk3
#CD disk1
#. / Runinstaller
Note: In this process, it is possible to have a little longer. Some are probably 1, 2 minutes, but x_windows must be easy to use, because Oracle is installed under the graphical interface, you can start using the startX command first X_Windows, also You can install it under the X_Windows interface.
Ten, enter the pattern interface:
If the previous step is normal, you should enter the following interface:
Slightly ... look slide
Here our oracle is successful, and you with the mouse point Exit button.
Eleven, after work
Step 1. Check the program
$ SQLPLUS "/ as sysdba"
SQL> Shutdown Immediate -> Verify that the database can end properly.
Database Close
Database dismount
Instance shutdown
SQL> Startup -> Check if the database starts normally.
Oracle Instance Started.
Total System Global Area 101784276 Bytes
Fixed size 453332 bytes
Variable size 75497472 bytes
Database buffers 25165824 BYTES
Redo buffers 667648 bytesdatabase mounted.
Database opened.
SQL> EXIT
$ lsnrctl -> Verify that the Listener is working properly.
LSNRCTL> Status -> Confirm Status
LSNRCTL> Stop -> End
Lsnrctl> Start -> Start
Step 2. Test SQLPLUS and generate Scott users
$ SQLPLUS "/ as sysdba"
SQL> CREATE User Test Identified by Test;
Default TableSpace Uses
Porary TableSpace Temp;
SQL> Grant Connect, Resource To Scott;
SQL> Connect Test / TEST;
SQL> @? / Sqlplus / demo / demobld;
$ SQLPLUS TEST / TEST @ Orcl à View, can test whether the Listener starts normally and tests whether the user can access it.
SQL> SELECT * from Tab;
SQL> EXIT
Oracle is connected to JSP (JDBC)
If the version of the JDK is JDK1.3, then the use of the classpath file is /opt/oracle/jdbc/lib/classes12.jar
If the JDK version is JDK1.4, then the use of the classpath file is /opt/oracle/jdbc/lib/ojdbc14.jar
Pay attention to the following configuration;
1, VI / ETC / PROFILE
Export classpath = "$ classpath": / OPT / ORACLE / JDBC / LIB / OJDBC14.JAR
2, cp /opt/oracle/jdbc/lib/ojdbc14.jar / usr / local / Tomcat4 / Common / LIB
3, cp /opt/oracle/jdbc/lib/ojdbc14.jar / usr / local / tomcat4 / webapps / root / web-infrest (only for the current
Valid)
The above is three ways to connect Oracle and JDBC, if the first is not easy, use the second.
Unrestrained saying:
Ha ha
DESC DICT
SELECT TABLE_NAME from Dict;
There are two more things to meet you.
It is just to study the Dongdong inside.
하하 ... said:
Obtain. . Ok
Unrestrained saying:
SQL> DESC DICT;
Name NULL? TYPE
------------------------------------- ---------------------------
Table_name varchar2 (30)
Comments varchar2 (4000)
Unrestrained saying:
All of its stuff is in front
Including basic applications and management classes
If you want to know what you say, let's talk about it.
What is the meaning of Qlplus Scott / Tiger @ orcl?
User name SCOTT
Password Tiger
@Orcl is the connection string of this database
SQL> CREATE PFILE = '/ OPT / INITF.ORA' from SPFILE;
SQL> Startup Pfile = / OPT / ORACLE / DBS / SPFILEBABO1.ORA
What does these two sentences mean?
Unrestrained saying:
Built a parameter file and enable this file
Unrestrained saying:
It uses spfile files by default
