Installing Oracle 10 GB on the Character interface in Aix

1. Preparations before installing the database.
First, you must confirm your machine configuration, operating system, and the version of the Oracle database to be installed. For different machine, operating system, and Oracle versions, refer to the following website.
Www.oracle.com (Oracle Database official website, enhanced in English ^-^)
This website contains the information you need, but you need to register it when you download it ^-^
2. for users who log on to Linux or Unix through windows. (If you are installing the Oracle database in windows and have a graphical interface provided to you, it is a good message ^-^)
I think most people are using putty! I have. With it, you can easily access Windows and Linux or UNIX. Then we can use it to build our database.
Someone may ask, "Is there no GUI installation in Linux or Uinx ?" Yes. However, you need to support the system or use the down XWindow application. But this is not the case, because the cute putty does not support graphical interfaces. So you need to learn another software: VNC.
What? Do you know VNC? Search for www.baidu.com or www.google.com. I personally like the two. Maybe you will have your own searcher! I don't need to teach you how to use VNC! Hey ..........
For the above reason, I decided to install oracle on the Character interface in Linux or UNIX. (I have not installed Oracle before, which is a challenge ^-^)
3. Actual action (taking the AIX machine as an example)
The ME machine is like this: ibm aix 5.3 1600 s, 2 GB memory, 5 GB space for Oracle I use. (The company is so nice to me)
So, the downloaded version is Oracle Database 10g Release 2 (10.2.0.1.0) for aix5l (preferably the release version)
Note: because the server to be sent to me requires telnet login, the down Oracle installation package cannot be passed over with putty, so there is only one other way. (We thought the character interface was fast, so there were no more steps. But .......)
Search online and find out that there is a powerful command --------- FTP in windows. (Introduction ?)
How can I enable ftp! (FTP 192. 168.
Ftp> Bin
Ftp> LCD $ PATH (my $ Path = D:/cya1/ study_source/Oracle)
Ftp> put 10gr2_aix5l64_database.cpio.gz
(Note: 1. In this way, the file will be stored in the/home/$ id directory.
2. You must have enough space to store the file! I fail to transmit the file over FTP due to insufficient directory space .)
Ftp> by (you must say goodbye to FTP after the transfer is successful! ^-^)
In this way, our AIX machine has our Oracle Installation Package. (This is also a project. ^-^)
$ Gunzip 10gr2_aix5l64_database.cpio.gz
$ Cpio-idgmm <10gr2_aix5l64_database.cpio.gz
After completing the preceding steps, a directory of disk1 is generated.
The real practice begins (pay attention ...........................)
1. Confirm the system hardware environment
Minimum Oracle10g installation requirements:
400 m physical memory, min (Ram * g) swap space, M/tmp space, 4G Oracle directory space, 64-bit architecture
The following is the confirmation process:
1. Check the memory size (1 GB)
Localhost>/usr/sbin/lsattr-e-l sys0-A realmem
Realmem 1048576 amount of usable physical memory in Kbytes false
Here, the Oracle10g installation document is wrong, and "sys0 (number 0)" is written as "syso (letter O )".
2. confirm that the swap space is smaller than MB and is added to 2 GB.
Localhost>/usr/sbin/LSPs-
Page space physical volume group size % used active auto type
Hd6 hdisk0 rootvg 512 MB 12 Yes LV
3. Confirm the/tmp and Oracle directory spaces (where Oracle10g is placed under/data1 ):
Localhost> DF-K
Filesystem 1024-blocks free % used iused % iused mounted on
/Dev/hd4 32768 14676 56% 2176 14%/
/Dev/hd2 1933312 516400 74% 35398 8%/usr
/Dev/hd9var 65536 43496 34% 623 4%/var
/Dev/hd3 917504 691884 25% 1034 1%/tmp
/Dev/hd1 10911744 4097144 63% 18636 1%/home
/Proc---/proc
/Dev/hd10opt 32768 23328 29% 362 5%/OPT
/Dev/lv00 2097152 937572 56% 708 1%/PTF
/Dev/data1lv 13107200 10559980 20% 2735 1%/data1
4. Confirm the System Structure
Localhost>/usr/bin/getconf hardware_bitmode
64
5. We can use the following command to confirm the number and clock speed of the system CPU:
# Lsdev-c | grep proc
Proc0 available 00-00 Processor
Proc1 available 00-01 Processor
# Lsattr-e-l proc0
Frequency 752010000 processor speed false
State enable processor state false
PowerPC_RS64-III Processor type false
# Lsattr-e-l proc1
Frequency 752010000 processor speed false
State enable processor state false
PowerPC_RS64-III Processor type false
2. Confirm the system software environment
1. AIX must be 5.2 level 1 or above (including level 1 ):
Localhost> oslevel-R
5200-01
2. install these filesets:
Localhost> lslpp-l Bos. ADT. Base Bos. ADT. Lib Bos. ADT. libm
Bos. Perf. perfstat Bos. Perf. libperfstat Bos. Perf. proctools
Fileset Level State Description
----------------------------------------------------------------------------
Path:/usr/lib/objrepos
Bos. ADT. Base 5.2.0.11 applied base application development
Toolkit
Bos. ADT. Lib 5.2.0.10 applied base application development
Libraries
Bos. ADT. libm 5.2.0.13 applied base application development
Math Library
Bos. Perf. libperfstat 5.2.0.12 applied Performance Statistics Library
Interface
Bos. Perf. perfstat 5.2.0.12 applied Performance Statistics
Interface
Path:/etc/objrepos
Bos. Perf. perfstat 5.2.0.0 committed Performance Statistics
Interface
Lslpp: 0504-132 fileset Bos. Perf. proctools not installed.
We can see that Bos. Perf. proctools is not installed, just install it with Smitty. Check now to confirm:
Localhost> lslpp-l Bos. Perf. proctools
Fileset Level State Description
----------------------------------------------------------------------------
Path:/usr/lib/objrepos
Bos. Perf. proctools 5.2.0.11 applied proc filesystem tools
3. requires that APARs (Authorized problem analysis reports) be installed ):
Localhost>/usr/sbin/instfix-I-k "iy43980 iy44810 iy45462 iy45707
Iy46214 iy46605 iy48525 iy51801"
All filesets for iy43980 were found.
All filesets for iy44810 were found.
All filesets for iy45462 were found.
All filesets for iy45707 were found.
All filesets for iy46214 were found.
All filesets for iy46605 were found.
There was no data for iy48525 In the fix database.
There was no data for iy51801 In the fix database.
We can see that iy48525 and iy51801 are not installed, we can download them from the Internet and then install them on, here is: https://techsupport.services.ibm.com/server/aix.fdc
But in fact, these two patches are for sdk1.4 and can be ignored if 1.4 is not used.
4. Create Oracle10g users and groups and create related directories (this step is the most critical)
Note that you must carefully perform each step. ^-^
Useradd-G oinstall-g dba-D/home/Oracle-S/usr/bin/bash-M Oracle
Passwd Oracle
After completion: Use the Oracle user to log in and modify the. Profile
Su-Oracle
. Set system environment variables: (generally at/home/Oracle)
ORACLE_HOME =/home/Oracle/product/10.2.0
Oracle_base =/home/Oracle
. System Planning: (test is used here)
Instance name oracle_sid = test
Database Name: Test
4. manually create the following directory:
/Home/Oracle/admin/test/cdump
/Home/Oracle/admin/test/bdump
/Home/Oracle/admin/test/udump
/Home/Oracle/admin/test/pfile
/Home/Oracle/oradata/test
Appendix: My. profile file
If [-s "$ mail"] # This is at Shell startup. In normal
Then ECHO "$ mailmsg" # operation, the shell checks
FI # periodically.
#. Bash_profile
# Get the aliases and functions
If [-f ~ /. Bashrc]; then
.~ /. Bashrc
Fi
# User specific environment and startup programs
ORACLE_HOME =/home/Oracle/product/10.2.0;
Export ORACLE_HOME
Export oracle_base =/home/Oracle
Export oracle_sid = test
Unset Username
Umask 022
Path = $ path: $ home/bin: $ ORACLE_HOME/bin;
Export path
5. Edit the response File
This step is a key step for Oracle Installation on the Character interface.
Go to the Oracle 10 Gb installation directory and edit the response File
$ Su-Oracle
$ CD/$ home/$ ID/disk1/Response
We can see that Oracle has prepared six response files. In fact, these files are the templates used to install and configure Oracle, which are custom. RSP dbca. RSP emca. RSP enterprise. RSP netca. RSP standard. RSP selects a simple response File enterprise. you can also select to edit several other response files based on the actual situation.
$ CP custom. RSP myinst. RSP
$ VI myinst. RSP
There is a description at the beginning of myinst. RSP. You should take a closer look. Pay special attention to the writing of several data variable formats defined by myinst. RSP, as shown below:
Type example
String "sample value"
Boolean true or false
Number 1000
Stringlist {"string value 1", "string value 2 "}
　　
The variables are all defined when oracle is installed. There are three possible values. One is that there are already default values, and you can almost ignore them. The second is that the value is equal. This variable is required for non-graphical installation of 10 Gb. It must be modified to an appropriate value. The value of the third variable is equal, it indicates that its value is associated with other variable values, or you can ignore it. Modify the values of the second type of variables one by one.
You can modify the values of other variables as follows:
ORACLE_HOME = "/home/Oracle/product/10.2.0"
Oracle_home_name = "test"
S_namefordbagrp = "dba"
S_nameforopergrp = "dba"
Show_database_configuration_page = false
B _createstarterdb = false (do not create a database)
Show_database_options_page = false
S_dbcharacterset = "zhs16gbk"
S_globaldbname = "test"
S_dbsid = "test"
Show_database_management_page = false
Show_database_file_storage_option_page = false
Show_backup_recovery_option_page = false
Show_schema_passwords_page = false
After modification, save the disk and exit.
Iii. Run and install Oracle
1. Run #./rootpre. Sh as root.
2. Go to the Oracle 10g installation media directory and run runinstaller with the Oracle user
$ CD @/disk1/
$./Runinstaller-silent-responsefile @/disk1/response/myinst. RSP
"@" Indicates the parent directory path of the disk.
In this way, Oracle 10 Gb is installed.
The installation process is as follows:
A. Check the partition size of temp and swap.
B. Check whether System Patches meet the requirements.
C. read information from the response File
D. Copy Related Files
E. Link and Setup
F. Run root. Sh as prompted. Run root. Sh as prompted.
Generally, errors occur in steps B and C. If the system patch is not complete, complete the system patch as prompted, it indicates that your response file information is incorrect and you need to modify the response file again.
So far, Oracle 10 Gb installation on the GUI is complete.
Iv. Follow-up work
Create a database.
The database is not created during this installation. The method for creating a database using scripts is similar to that of the previous version of Oracle, which is not described here.

Let me add some content ~~~
My database creation Script: (create_db. SQL)
Create Database '$ dbname'
Logfile
Group 1 ('/home/Oracle/oradata/' $ dbname'/redo01.log') size 100 m,
Group 2 ('/home/Oracle/oradata/' $ dbname'/redo02.log ') size 100 m,
Group 3 ('/home/Oracle/oradata/' $ dbname'/redo03.log') size 100 m
Maxlogfiles 5
Maxlogmembers 5
Maxloghistory 1
Maxdatafiles 100
Maxinstances 1
Datafile '/home/Oracle/oradata/' $ dbname'/system01.dbf 'size 256 m
[U] Undo tablespace undotbs [/u]
Datafile '/home/Oracle/oradata/' $ dbname'/undotbs01.dbf' size 200 m autoextend on next 5 m maxsize Unlimited
Sysaux datafile '/home/Oracle/oradata/' $ dbname'/sysaux01.dbf 'size 100 m
[U] default temporary tablespace temp [/u]
Tempfile '/home/Oracle/oradata/' $ dbname'/temp01.dbf' size 512 M autoextend on next 5 m maxsize Unlimited
Character Set us7ascii
National Character Set al16utf16;

Note the special mark !! Pai_^

In my practice, I found that I did not execute an important step, that is, after using scripts to create a database, I need to execute two important system files. (The following are the materials found online)
Reference:[Color = Red] in addition to creating an extra data table space, you must execute two important command files after the database is created: catelog. SQL and cataproc. SQL. These two command files will create visual tables, synonyms, and PL/SQL packages necessary for management in the Oracle9i database ).
1 catalog. SQL:
The content of this directive is: create a visual table, a dynamic performance visual table, and the words used to access various visual tables on the data dictionary data table. In addition, catalog. SQL grants the permission to use these visual tables to database users.
2 catproc. SQL:
This command file contains all command files required to execute PL/SQL programs. [/Color]