Saturday 6 September 2014

Installation oracle database By using DBUA

                                         

*************************************
      Linux format
*************************************
OPEN terminal  and then follow steps
1.LogIn to the oracle User
[root@standalone ~]# su - oracle
2. To Enable the GUI Mode run from root user
[root@standalone ~]# xhost +
access control disabled, clients can connect from any host
3. check the zipped software files specified folder
bash-3.2$ pwd
/home
4.Unzip those softwares from Root User itself
[root@standalone upgrade]# unzip p10404530_112020_Linux-x86-64_1of7.zip
 [root@standalone upgrade]# unzip p10404530_112020_Linux-x86-64_2of7.zip
5. those files are extracted in to a new folder named 'Database' Automatically
bash-3.2$ pwd
/home/database
bash-3.2$ ls -ltr
total 64
-rwxr-xr-x  1 root root  5466 Aug 23  2011 welcome.html
drwxr-xr-x 12 root root  4096 Sep 19  2011 doc
-rwxr-xr-x  1 root root  3226 Sep 22  2011 runInstaller
drwxr-xr-x  2 root root  4096 Sep 22  2011 rpm
drwxr-xr-x  2 root root  4096 Sep 22  2011 response
drwxr-xr-x  4 root root  4096 Sep 22  2011 install
drwxr-xr-x 14 root root  4096 Sep 22  2011 stage
drwxr-xr-x  2 root root  4096 Sep 22  2011 sshsetup
-rwxr-xr-x  1 root root 28122 Sep 22  2011 readme.html
7. run setup file from Oracle User
bash-3.2$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 17322 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 8001 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-09-04_11-02-09AM. Please wait ...bash-3.2$
**************************************
        windows Format
**************************************

G:\oracle softwares\windows softwares\win64_112020_database\database
Double click on "setup"

*********From Here Same steps on linux and windows Operating Systems*****************
unchek the check box "I WISH TO RECEIVE......."
CLICK ON YES BUTTON.


SELECT RADIO BUTTON SKIP SOFTWARE UPDATE.


IN THIS OPTION SELECT 1ST RadioButton as "create and configure Database".
Here these three options specified as 
1.create and configure database is specified as after installing software, the database can be installed by using DBCA(database Configuration Assistent).
2.Install Database software only  is specified go for manually creation of database and new location of upgrations.  
3.upgrade the existing Database is specified as To upgrade the database in same location.

HERE SELECT SERVER CLASS.

SELECT SINGLE INSTANCE DATABASE INSTALLATION.

Select Install Type as "ADVANCED INSTALL"
Choose the Product Available languages default "ENGLISH" has been specified.
Choose the database Installation as Enterprise Edition.

Check the Oracle_base and Oracle_home locations as specified here 
Select database type we want to create as "General Purpose....."

Select the Oracle database name and oracle SID(Service Identifier).
Enable the Automatic Memory management in schemas tab enable all sample schemas.

Select Management options for Your Instance.

Select the database storage options as "file system" or "Automatic Storage Management". default it is "filesystem".

Specify that to enable or disable automated Backups.

Enter the password for schemas and then click YES to continue on th popup.

Oracle perform Pre-requisite checks
click "fix&checkagain" button, After that we get a popup as execute scripts.

Follow this Simple Steps:
1.open a terminal window
2.login as "root"
3.run script: /tmp/CVU_11.2.0.2.0_oracle/runfixup.sh
[root@standalone ~]# /tmp/CVU_11.2.0.2.0_oracle/runfixup.sh
/usr/bin/id
Response file being used is :/tmp/CVU_11.2.0.2.0_oracle/fixup.response
Enable file being used is :/tmp/CVU_11.2.0.2.0_oracle/fixup.enable
Log file location: /tmp/CVU_11.2.0.2.0_oracle/orarun.log
Setting Kernel Parameters...
fs.file-max = 327679
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.wmem_max = 262144
net.core.wmem_max = 1048576
click "ok".

and then it will show the summary of database locations and allocated memory and we get install Button, click on it.
After click on install, the process will be going on like..

we need to configure root scripts to complete the software installation which we seen in window like..
we have to run scripts from terminal as root user:
SCRIPT:1:-
[root@standalone ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
SCRIPT:2:-
[root@standalone ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
Running Oracle 11g root script...
The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

and then back to installation window click OK on popup.

A previously we had select "install software and database option"
For the above option database can be created By Using DBCA(Database Configuration Assistant.
installing database and software completed click on close.