Skip to main content

Installing Oracle 10g on SOLARIS


Run_ALL_Commands_as_User_ROOT
-----------------------------------------------------------------------

  • Run Check

bash# /usr/sbin/prtconf | grep "Memory size" [Check RAM size]
bash# /usr/sbin/swap -s [check swap]
bash# df -k /tmp [check /tmp size (>400mb)]
bash# uname -r [check solaris version]

bash# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWsprot SUNWsprox SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt

bash# cat /etc/nsswitch.conf | grep hosts
bash# hostname
bash# domainname


  • Fist of all add 3 OS groups.
bash#groupadd dba
bash#groupadd oinstall
bash#groupadd oper
  • Create user 'oracle'
{Determine oracle user exist or not)
bash# id -a oracle
{if exist, should be look like this=
uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper))

{create oracle user)
# useradd -d /export/home/oracle -g dba -G oinstall -m -s /bin/ksh oracle

#
#chown oracle:dba /export/home/oracle

{set password=
# passwd -r files oracle

or you can simply do it from SMC (Sun Management Console)

  • Run 'smc' from command promt and create user 'oracle'
  • Change ownership
chown -R oracle /app                 (here oracle software will be installed)
chown -R oracle /datafile                 (here oravle datafiles will be stored)
chmod -R 777 /app/database/      (here Oracle installer will be stored)
chown -R oracle /app/database/
  • Copy 3 configuration files: system,user_attr,.profile

scp oracle@172.17.1.100:/etc/system /etc/
scp oracle@172.17.1.100:/etc/user_attr /etc/
scp oracle@172.17.1.100:/export/home/oracle/.profile /export/home/oracle/


bash#reboot


------------------------------------------------------------------------100%

Log on as root and run the following commands in command prompt.
bash#projadd -c "Oracle" 'user.oracle'
bash#projmod -s -K "process.max-sem-nsems=(privileged,256,deny)" 'user.oracle'
bash#projmod -s -K "project.max-shm-memory=(privileged,24GB,deny)" 'user.oracle'
bash#projmod -s -K "project.max-shm-ids=(privileged,256,deny)" 'user.oracle'
bash#projmod -s -K "project.max-sem-ids=(privileged,256,deny)" 'user.oracle'


Now go to installation folder and doublclick
Run 'runinstaller.exe'

Or you can also run this exe from command promt.
after successful installation create database by following command.

  • Run 'dbca' from command prompt

----------------------------------------------------------------------------------------
Thanks for reading this article. Have a good day.

Comments

Post a Comment

Popular posts from this blog

EXPDP/IMPDP Export/Import dumpfile to a Remote Server Using Network_Link.

EXPDP/IMPDP Export/Import dumpfile to a Remote Server Using Network_Link. Step 1:   First you have to create a TNS entry at destination database which will be used to connect to the remote target database. pumplink =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.1.171)(PORT = 1521))     )     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = Ultimus)     )   ) Step 2:   Connect to SQL plus: --Issue the following command to create db link on destination database: CREATE PUBLIC DATABASE LINK pumplink    connect to scott identified by tiger USING 'pumplink'; Step 3:   Issue the expdp command on the destination server using Network_link parameter: expdp scott/tiger directory= dumpdir logfile=impi_temp.log network_link= pumplink  schemas=scott dump...
5 comments
Read more

All Dictionary View Tables:

All Dictionary View Tables: TABLE_NAME COMMENTS ALL_ALL_TABLES Description of all object and relational tables accessible to the user ALL_APPLY Details about each apply process that dequeues from the queue visible to the current user ALL_APPLY_CONFLICT_COLUMNS Details about conflict resolution on tables visible to the current user ALL_APPLY_DML_HANDLERS Details about the dml handler on tables visible to the current user ALL_APPLY_ENQUEUE Details about the apply enqueue action for user accessible rules where the destination queue exists and is visible to the user ALL_APPLY_ERROR Error transactions that were generated after dequeuing from the queue visible to the current user ALL_APPLY_EXECUTE Details about the apply execute action for all rules visible to the user ALL_APPLY_KEY_COLUMNS Alternative key columns for a STREAMS table visible to the current user ALL_APPLY_PARAME...
1 comment
Read more

Solution of problem: Resultset Exceeds the Maximum Size (100 MB)

Solution of problem: Resultset Exceeds the Maximum Size (100 MB) I was running a select statement in PL/SQL Developer. it was a short query but the data volume that the query was fetching was huge. But when ever i Click the button Fetch Last Page or press 'ALT+End' button a message box comes after a while saying: Then I started looking for the exact reason of this sort of problem in Google. When I realized there was no direct solution in the web, I started looking the PL/SQL Developer Software menu and found the ultimate solution. The reason of this problem is there is a parameter of maximum result set size in PL/SQL Developer Software which is by default set to 100 MB. To change this parameter you have to go to the following location: 1. Goto Edit Menu and click ' PL/SQL Beautifier Options '. A new window will open. 2. Click SQL Window of " Window Types ". 3. Now Change the value of "Maximum Result Set Size( 0 is unlimited)"  ...
6 comments
Read more