Oracle10gr2 installation configuration and link test in ubuntu10.10

Oracle10gr2InUbuntu10.10Install

★ Create Swap Swap Partition
Dd If =/dev/Zero of = tmp_swap BS = 1 k count = 1024000
Chmod 600 tmp_swap
Mkswap tmp_swap
-- Echo "/swap defaults 0 0">/etc/fstab
Swapon tmp_swap -- Swap- Activate all Swap Partition
After installation is completed , This space can be released. :
Swapoff tmp_swap
Rm tmp_swap
Check Swap The swap partition works normally: CAT/proc/SWAPs; Swapon-S; free

★ Create RedHat Version Declaration File
In /Etc/RedHat-release To make the installationProgramThink that RedHat On the system: Echo "Red HatLinux release 3.1 (Drupal) ">/etc/RedHat-release

★ Set Oracle Environment Variable
Vim/etc/profile
Export oracle_base =/Oracle
Export ORACLE_HOME =/Oracle/ora_home
Export oracle_sid = Phoenix
Export Path = $ ORACLE_HOME/bin: $ path: $ home/bin

Tian Add User And add the user Admin Group
Adduser oradba- Create Oradba User and Oradba Group
Groupadd nobody
Usermod-G nobody

. modify sysctl. conf
Add the following rows to /etc/sysctl. conf medium :< br> kernel. sh mMax = 3147483648
kernel. shmmni = 4096
kernel. shmall = 2097152
kernel. SEM = 250 32000 100 128
FS. file-max = 65536
net. ipv4.ip _ local_port_range = 1024 65000

[ Edit ] C. Modify Limits. conf
Add the following row /Etc/security/limits. conf Medium:
* Soft nproc 2407
* Hard nproc 16384
* Soft nofile 1024
* Hard nofile 65536

[ Edit ] D. Make the modification take effect
Modify After the above files , Must take effect , Or restart the system. , Or switch Root Use the following methods to change the kernel running parameters: :Sysctl-P

★ Create Oracle Security Installation Directory and ownership
Mkdir-p-M 775/Oracle/ora_home
Chown-r oradba: oradba/Oracle

★ prepare the compilation tool environment
apt-Get install GCC make binutils lesstif2 libc6 libc6-dev RPM alien libmotif3 libstdc ++ 5 libstdc ++ 6 build-essential libaio1 libaio-dev
1 , error in invoking target 'utilities ctx_on 'of makefile
run before installation ln-S/usr/bin/basename

2,Error in invoking target 'all _ no_orcl ihsodbc 'of makefile
OracleCompileLibstdc ++. so.5, SolutionLibstdc ++ 5Or make a soft link.
Sudo ln-S/usr/lib/libstdc ++. so.6/usr/lib/libstdc ++. so.5

3, Ora-12547: TNS: Lost contact Solution
Sudo sudo apt-Get install libaio-Dev
Hanging Connect Oracle10gr2 CD or copy the installation Source
Makedir/Media/CDROM
# Umount/Media/CDROM
# Mount/dev/sr0-O exec/Media/CDROM -- Mount the installation source in executable Mode

★ Switch Oradba User, loading the optical disk Security Installation System
./Media/CDROM/database/runinstaller Slave Or use Filezilla Pass SFTP Upload a file. If it is a virtual machine, you can drag it in directly. Installation program.

★ Available Oracle SQL developer Or PL/SQL developer Remote connection Oracle
Oracle Restart the server after installation. Will find that the external connection fails By default:
Listener Not started, and the database does not Mount , System The account is also locked.

Oradba @ Ubuntu :~ $/Oracle/ora_home/bin/LSNRCTL start
Oradba @ Ubuntu :~ $Sqlplus/nolog

SQL * Plus: Release 10.2.0.1.0-production on Mon Dec 6 19:58:32 2010

Copyright (c) 1982,200 5, Oracle. All rights reserved.

SQL>Conn/As sysdba;
Connected.

SQL>Alter user system identified by "& password ";
Enter value for Password: abch; & ach2
Old 1: Alter user system identified by "& password"
New 1: Alter user system identified by "abch; & ach2"

User altered.

SQL>Alter user system account unlock;

User altered.

SQL>

Select * from V $ version;

Select username, account_status from (select * From dba_users) Where rownum <= 3;

Select userenv ('language') from dual;

 

Create Table testuser (ID integer, name char (10 ));

Insert into testuser values (0, 'jack ');

Select * From testuser;

Commit;

Shutdown immediate;

Quit