10g installation steps on LINUX


1) Check Physical Memory:-
 
[root@sujeet ~]$ grep MemTotal /proc/meminfo
MemTotal:      2036792 kB
Required physical Memory (RAM):-1GB
 
2) Check Swap Space :- 
 
[root@sujeet ~]#   grep SwapTotal /proc/meminfo
SwapTotal:     4192956 kB
Required Swap Space:-1.5 GB
 
3). Check free Space:-
 
[root@sujeet ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3             222G   99G  113G  47% /
/dev/sda1              99M   12M   83M  12% /boot
tmpfs                 995M   12K  995M   1% /dev/shm
 
[root@sujeet ~]# free
        total     used     free   shared  buffers     cached
Mem-2036792    1970268      66524    0     151772   1234832
-/+ buffers/cache583664    1453128
Swap: 4192956      53876    4139080
 
4)  CHANGE HOSTNAME OR MACHINE NAME:-
 
[root@sujeet ~]#  vi  /etc/hosts
 
Make sure that there is an entry in /etc/hosts file for your 
machine like this:
 
[IP-address]  [Fully-qualified-machine-name]  [Machine-name]
172.16.2.76            R0202.iwarelogic.com            R0202
 
 
5) GUI:-Create User and Group:-
 
System -> Administration -> Users and Groups -> 
i) Add user oracle
ii) Add Group dba
iii) Assign user to that group
 
        OR
 
COMMAND LINE:-
 
[root@sujeet ~]# useradd -g dba -m oracle
 
[root@sujeet ~]# passwd oracle
 
Changing password for user oracle.
New UNIX password: 
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password: 
passwd: all authentication tokens updated successfully.
 
 
6) Create directories where the Oracle Software and database 
will be installed.
 
[root@sujeet ~]#  Mkdir /10g_install 
[root@sujeet ~]#  chown -R oracle:dba  /10g_install
[root@sujeet ~]#  chmod -R 777 /10g_install
 
 
7) SELINUX=disabled
 
System -> Administration ->
 
If you leave SELINUX=enforcing then you may get an error later 
while starting sqlplus:
sqlplus: error while loading shared libraries:
/usr/lib/oracle/default/client64/lib/libclntsh.so.11.1: 
cannot restore segment
prot after reloc: Permission denied
 
 
8) Linux Kernel Parameters to support Oracle.
 
Open /etc/sysctl.conf and add the following lines:
 
[root@sujeet ~]# vi /etc/sysconfig/network
 
# Oracle settings
fs.file-max = 65536
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65500
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
 
Make the kernel parameters changes effective immediately:
 
[root@sujeet ~]# /sbin/sysctl -p
 
[root@sujeet ~]#  /sbin/sysctl -a | grep <name of kernel>
 
 
9)  RPM INSTALL: - (For Linux 32-bit)
 
[root@sujeet ~]#  cd /setup/rpms
 
[root@sujeet newrpms]# ls
 
binutils-2.17.50.0.6-6.0.1.el5.i386.rpm
binutils-2.17.50.0.6-9.0.1.el5.i386.rpm
compat-binutils215-2.15.92.0.2-24.i386.rpm
compat-libcwait-2.0-2.i386.rpm
compat-libstdc++-3.2-1.i386.rpm
compat-libstdc++-egcs-1.1.2-1.i386.rpm
compat-oracle-el5-1.0-5.i386.rpm
fonts-chinese-3.02-12.el5.noarch.rpm
openmotif21-2.1.30-11.EL5.i386.rpm
openmotif21-debuginfo-2.1.30-11.EL5.i386.rpm
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
 
 
INSTALL RPM COMMAND:-
[root@sujeet ~]#  rpm –ivh  <rpmname> 
 
[root@sujeet ~]#  rpm –Uivh <rpmname>
 
Install rpm check:-
[root@sujeet ~]#  rpm -qa |grep <rpmname>
 
 
10) Restart system:-
 
[root@sujeet ~]# init 6   
 
 
11) Permission to connect any HOST:-
[root@sujeet ~]#  xhost +
access control disabled, clients can connect from any host
 
 
 
12)  Now switch to the user ORACLE
 
[root@sujeet ~]# su - oracle
   
12) Set BASH_PROFILE:-
 
[oracle@sujeet ~]#   vi .bash_profile
 
(Open file than copy inst parameter)
 
# Oracle Settings
    TMP=/tmp; export TMP
    TMPDIR=$TMP; export TMPDIR
 
    ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
    ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
    ORACLE_SID=TSH1; export ORACLE_SID
    ORACLE_TERM=xterm; export ORACLE_TERM
    PATH=/usr/sbin:$PATH; export PATH
    PATH=$ORACLE_HOME/bin:$PATH; export PATH
 
    LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
    CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; 
export CLASSPATH
 
 
13). Permission grand Oracle SETUP: - (By root user) 
 
[root@sujeet ~]#   chown -R oracle:dba /10g_setup
[root@sujeet ~]#   chmod -R 777 /10g_setup
 
 
14). Login as oracle:-
 
Go to setup location
 
[oracle@sujeet ~]#   cd /10g_setup/database/
[oracle@sujeet ~]#   $ ./runInstaller
 
 
  
Open new window>>>>>>>>>
 
 

Manual Oracle 10g Uninstall


UNIX

Uninstalling all products from UNIX is a lot more consistent. If you do need to resort to a manual uninstall you should do something like:
  • Uninstall all Oracle components using the Oracle Universal Installer (OUI).
  • Stop any outstanding processes using the appropriate utilities.
    # oemctl stop oms user/password
    # agentctl stop
    # lsnrctl stop
    Alternatively you can kill them using the kill -9 pid command as the root user.
  • Delete the files and directories below the $ORACLE_HOME.
    # cd $ORACLE_HOME
    # rm -Rf *
  • With the exception of the product directory, delete directories below the $ORACLE_BASE.
    # cd $ORACLE_BASE
    # rm -Rf admin doc jre o*
  • Delete the /etc/oratab file. If using 9iAS delete the /etc/emtab file also.
    # rm /etc/oratab /etc/emtab


Windows


  • Uninstall all Oracle components using the Oracle Universal Installer (OUI).
  • Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/Oracle key. This contains registry entires for all Oracle products.
  • If you are running 64-bit Windows, you should also delete the HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/Oracle key if it exists.
  • Delete any references to Oracle services left behind in the following part of the registry (HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*). It should be pretty obvious which ones relate to Oracle.
  • Reboot your machine.
  • Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE.
  • Delete the "C:\Program Files\Oracle" directory.
  • If you are running 64-bit Wiindows, you should also delete the "C:\Program Files (x86)\Oracle" directory.
  • Remove any Oracle-related subdirectories from the "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\" directory.
  • Empty the contents of your "C:\temp" directory.
  • Empty your recycle bin.
At this point your machine will be as clean of Oracle components as it can be without a complete OS reinstall.
Remember, manually editing your registry can be very destructive and force an OS reinstall so only do it as a last resort.
If some DLLs can't be deleted, try renaming them, the after a reboot delete them.

 

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...