Fedora6 install Oracle9i

OracleLinux install

FedoraCore 6
Oracle9i

See documentation

Http://ivan.kartik.sk/Oracle/Install_ora9 _Fedora. Html

Google search keywords

InstallationOracle9I (R2) onFedoraCore Linux 2, 3, 4, 5 and 6

1. CreateOracleCreate a user accountOracleUser

Login as root and create te userOracleWhich belongs to DBA group.
Create group authorization with Root User LoginOracleUser

$ Su-
# Groupadd DBA
# Useradd-G DBAOracle

2. Setting System Parameters
 
Edit the/etc/sysctl. conf and add following lines:
Edit/etc/sysctl. conf and add the following attributes.

# Vi/etc/sysctl. conf

Kernel. SEM = 250 32000 100 128
Kernel. shmmax = 536870912
Kernel. shmmni = 4096
Kernel. Shmall = 2097152
Kernel. msgmnb = 65536
Kernel. msgmni= 2878
FS. File-max = 65536
Net. ipv4.ip _ local_port_range = 1024 65000

Note: You need execute "sysctl-P" or reboot system to apply above settings.
Note: The environment on sysctl-P or reboot takes effect.

Edit the/etc/security/limits. conf file and add following lines:
Edit/etc/scurity/limits. conf and add the following lines:

# Vi/etc/security/limits. conf

*-Nproc 16384
*-Nofile 16384

3. SettingOracleEnviroment settingsOracleEnvironment
 
Edit the/home/Oracle/. Bash_profile file and add following lines:
Edit/home/Oracle/. Add the following line to bash_profile:

SettingsFedoraCore 5 and 6 only.
Fc5, 6. Set JRE as your path.Oracle_ SID Customization

# Vi/home/Oracle/. Bash_profile
 Oracle_ Base =/opt/Oracle
 Oracle_ Home = $Oracle_ Base/920
 Oracle_ SID = My _Oracle
LD_LIBRARY_PATH = $Oracle_ Home/lib
 Oracle_ Oem_javaruntime =/opt/jre1.3.1 _ 15
Path = $ path: $Oracle_ Home/bin

ExportOracle_ BaseOracle_ HomeOracle_ SID LD_LIBRARY_PATHOracle_ Oem_javaruntime path

Save the. bash_profile and execute following commands for load new enviroment:
Save the environment to take effect

# Cd/home/Oracle
# .. Bash_profile
There is a space between two points

4. Create base directoryOracleCreateOracleInstallation Directory

Login as root and create base directoryOracle($Oracle_ Base ).
Log on as the root user to create a directory

Su-
# Cd/OPT
# MkdirOracle
# ChownOracle: DBAOracle

5. Download & Install
 
1. Download and install required. RPM packages
Download and install
 
A. Some additional packages are required for Succesful instalationOracleSoftware. to check whether required packages are installed on your operating system use following command:
Check if these software is installed

# Rpm-q gcc glibc-headers glibc-kernheaders glibc-devel compat-libstdc ++ CPP compat-gcc

Note: You don't need glibc-kernheaders installed on fc6 as this package is not shipped with fc6.
Note: Glibc-kernheaders can be installed without compat-libstdc ++ in fc6. I have not installed compat-libstdc ++, but it is best to install it successfully.

B. If some package is not installed download it fromFedoraProject website or direct from Core 2, core 3, Core 4, core 5, core 6 locations.
If some packages do not exist, you can goFedoraDownload http: // from the official website ://Fedora.Redhat.com/download/
Compat-gcc-7.3-2.96.126.i386.rpm
You can download http://ivan.kartik.sk/Oracle/Download_from.php? Site_id = 2

 
C.FedoraCore 4, 5 and 6 only: install the required additional packages using the RPM command:
Install the following packages

# Rpm-IVH compat-libgcc-296-2.96-___. RPM \
Compat-libstdc ++-33-3.2.3-___. RPM \
Compat-libstdc ++-296-2.96-___. rpm

2. Download the Java runtime Enviroment
From the sun website. Keep in mind you
Need to download j2re1.3.1 _ 11 or higher (Note: Install JRE 1.3.1 _ 1x
Version only ).
Note: Download JRE jre1.3.1 _ 1x, where X is arbitrary, but the previous version cannot be changed.
 
Login as root and make the file executable and then execute it.
When the JRE is exracted move the "jre1.3.1 _ 15" Di rectory to "/OPT"
Directory.
Log on as the root user and run the following command:

# Chmod + x j2re-1_3_1_19-linux-i586.bin
#./J2re-1_3_1_19-linux-i586.bin

# Mv jre1.3.1 _ 19/opt/

3. downloadOracle9I (9.2.0.4) software fromOracleWebsite.
Extract the files using following command:
Download and decompress

# Gunzip ship_9204_linux_disk1.cpio.gz
# Gunzip ship_9204_linux_disk2.cpio.gz
# Gunzip ship_9204_linux_disk3.cpio.gz

# Cpio-idmv <ship_9204_linux_disk1.cpio
# Cpio-idmv <ship_9204_linux_disk2.cpio
# Cpio-idmv <ship_9204_linux_disk3.cpio

When all archives were extracted you 've got three directories disk1, disk2 and disk3.
Edit the disk1/install/Linux/oraparam. ini and modify jre_location
Variable and set path to our JRE installation from step 2.
Decompress the package to get the three folders disk1, disk2 and disk3, and then modify disk1/install/Linux/oraparam. ini.
 
Jre_location =/opt/jre1.3.1 _ 19

4. StartOracleSoftware installation process.

Now the system is preparedOracleSoftware Installation. To start the installation process execute the following commands:

After you are ready, start installation and logoutOracleUser Login and Installation

CD disk1
./Runinstaller

When network configuration assistant and Database Configuration
Assistant has failed during startup then do following steps:
When the network assistant configuration assistant fails to start, run the following command:

# Cd/opt/Oracle/920
# Rm JRE
# Ln-S/opt/jre1.3.1 _ 15 JRE
# Su-
# Cd/opt/Oracle/920/JRE/bin
# Ln-s Java JRE
# Cd i386/native_threads
# Ln-s Java JRE

****** common installation errors ************
Common Errors and solutions
******* **************************************** **************************************** * ********************************
unable to load native Library: & lt; BR & gt;/tmp/OraInstall2005-01-08_11-11-34AM/JRE/lib/i386/libjava. so: symbol
__ libc_wait, version glibc_2.0 not defined in file libc. so.6 with Link
time reference
resolution
solution: Install new JRE 1.3.1 version. edit the
disk1/install/Linux/oraparam. INI and set path to new JRE for
jre_location variable. for more information see download & install
section.
************************************* **************************************** **************************************** * **

& Lt; P & gt;/tmp/OraInstall2005-04-26_11-38-19AM/JRE/lib/i386/libawt. so:
libxp. so.6: cannot open shared object file: no such file or directory
plugin
solution: Install the xorg-x11-deprecated-libs package (for> = FC4 versions ). for fc5 and later install libxp package.
************************************* **************************************** **************************************** * **

/Tmp/OraInstall2005-06-14_03-46-25PM/JRE/bin/i386/native_threads/Java:
Error while loading shared libraries:
/Tmp/OraInstall2005-06-14_03-46-25PM/JRE/lib/i386/native_threads/libhpi. So:
Cannot restore segment prot after reloc: Permission denied
Bytes ------------------------------------------------------------------------------------------------------------------------
Solution: Modify/etc/SELinux/config and change value of SELinux to "disabled" and reboot computer.
**************************************** **************************************** ****************************************

Starting Oracle Intelligent Agent.../opt/ Oracle /920/bin/dbsnmpwd: Line 156: 1393 segmentation fault nohup $ Oracle _ Home/bin/Dbsnmp $ * >$ dbsnmp_wdlogfile 2> & 1
/Opt/ Oracle /920/bin/dbsnmpwd: Line 156: 1405 segmentation fault nohup $ Oracle _ Home/bin/Dbsnmp $ * >$ dbsnmp_wdlogfile 2> & 1
/Opt/ Oracle /920/bin/dbsnmpwd: Line 156: 1416 segmentation fault nohup $ Oracle _ Home/bin/Dbsnmp $ * >$ dbsnmp_wdlogfile 2> & 1
/Opt/ Oracle /920/bin/dbsnmpwd: Line 156: 1427 segmentation fault nohup $ Oracle _ Home/bin/Dbsnmp $ * >$ dbsnmp_wdlogfile 2> & 1
Bytes ------------------------------------------------------------------------------------------------------------------------
Solution: Download and apply patch Nr.: 3238244 from http: // Metalink. Oracle . Com.
**************************************** **************************************** ****************************************

exception in thread "Main" Java. lang. internalerror: Can't connect to
X11 window server using 'localhost: 0.0 'as the value of the display
variable.
solution: Execute "export display =: 0.0" (as Oracle
User) and "xhost +" as user who has opened X session (for example
logged in Kde, gnome, etc .). if the value is other than 127.0.0.1 or
localhost you shoshould "xhost +" on client machine.
************************************* **************************************** **************************************** * **

Error in invoking target install of makefile/opt/Oracle/920/CTX/lib/ins_ctx.mk
Error in invoking target install of makefile/opt/Oracle/920/precomp/lib/ins_precomp.mk
Error in invoking target install of makefile/opt/Oracle/920/PLSQL/lib/ins_plsql.mk
Error in invoking ntcontab. O of makfile/opt/Oracle/920/Network/lib/ins_net_client.mk
**************************************** **************************************** ****************************************

Solution: Install the compat-gcc-7.3-2.96.126.i386.rpm (GCC 2.96)
Package and change the GCC binaries. For more information see download
& Install section. In caseFedoraCore 5 take look at next error message.

SED:-e expression #1, char 7: unterminated's 'COMMAND error in $ Oracle _ home/install/make. log
solution: There is probably bug in bash (fc5 only ). download and
install bash package from fc4. I have prepared this package (builded
from FC4 SRC. rpm) for fc5-download.
install it using "rpm-IVH bash-3.0-31.i386.rpm -- force ".
************************************* **************************************** **************************************** * **

Initializing Java Virtual Machine from
/Tmp/OraInstall2006-10-25_01-43-30PM/JRE/bin/Java. Please wait...
/Tmp/OraInstall2006-10-25_01-43-30PM/JRE/bin/i386/native_threads/Java:
Error while loading shared libraries: libstdc ++-libc6.1-1. so.2: cannot
Open shared object file: no such file or directory-after
./Runinstaller execution.
Bytes ------------------------------------------------------------------------------------------------------------------------
Solution:
Su-
# Cd/usr/lib
# Ln-s libstdc ++-3-libc6.2-2.10.0.so libstdc ++-libc6.1-1. so.2

Start./runinstaller again.

If an error occurs in the middle: the error message is not displayed on the first node. Then
Follow the error message prompt: If you want to run the script on a new terminal, You need to press/usr/bin to install the script. just copy the prompt.

ModifyOracleConfiguration:

Note: Sid JRE version path name the path of the file in disk1 FC2 3 4 and fc5 fc6 steps firewall to set the port

$ Dbca adds a database

$ Netmgr Network Management

$ Netca

$OracleModify _ home/920/Network/admin/listener. ora as follows:

Sid only needs sid_nameOracle_ Home
The listener must change the host to an IP address.

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name =Oracle)
(Oracle_ Home =/opt/Oracle/920)
)
)

Listener =
(Description_list =
(Description =
(Address_list =
(Address = (Protocol = IPC) (Key = EXTPROC ))
)
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.1.11) (Port = 1521 ))
)
)
)

 

Start the listener:
$ LSNRCTL start
Open sqlplus

$ Sqlplus/nolog
Connection
$ Connect/As sysdba
Start
$ Startup