--------------------------------------------------------------------------------------------------------------
pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibms SUNWsprot SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt
--------------------------------------------------------------------------------------------------------------
mkdir /export/home/oracle
groupadd dba
groupadd oinstall
groupadd oper
useradd -g oinstall -G oracle -d /export/home/oracle -m -s /bin/bash oracle
passwd oracle
chown oracle:oinstall /export/home/oracle
----------------------------------------------------------------------------------------------------------------
projadd oracle
projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle
atleat once login as oracle
su - oracle
--------------------------------------------------------------------------------------------------------------
login as root and issue
mkdir /u01/app/oracle/product/11.2./db_1
chown oracle:oinstall /u01/app
chmod 775 /u01/app
Create the /var/opt/oracle directory and make it owned by the oracle user. After installation, this directory will contain a few small text files that briefly describe the Oracle software installations and databases on the server. These commands will create the directory and give it appropriate permissions:
$ mkdir /var/opt/oracle
$ chown oracle:dba /var/opt/oracle
$ chmod 755 /var/opt/oracle
-------------------------------------------------------------------------------------------------------------------------
make profile file for oracle user
touch /export/home/oracle/.bash_profile
edit the profile file
gedit /export/home/oracle/.bash_profile
--------------------------------------------------------------------------------------------------------------------------
.bash_profile contents
#Oracle Environment Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=RMGC; export ORACLE_SID
PATH=$PATH:/usr/local/bin:/usr/ccs/bin:/usr/sfw/bin:$ORACLE_HOME/bin
-------------------------------------------------------------------------------------------------------------
DISPLAY=myworkstation:0.0 export DISPLAY
xhost +COMPUTERNAME OR IP
/cdrom
./runInstaller
--------------------------------------------------------------------------------------------------------------
ARCSDE INSTALLTION FOR SOLARIS
Create ArcSDE user home dir
mkdir /export/home/sde
useradd -g oinstall -G dba -d /export/home/sde
passwd sde
Give ownership of home dir to sde
chown sde:oinstall /export/home/sde
create profile file for sde user
touch /export/home/sde/.profile
gedit /export/home/sde/.profile
-----------------------------------------------------------------------------------------
Add Following parameters in .profile
-----------------------------------------------------------------------------------------
#Change your parameter according to your setting e.g. DB Version
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
SDEHOME=/export/home/sde/sdeexe9.3/sdeexe93; export SDEHOME
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=RMGC; export ORACLE_SID
TNS_ADMIN=/u01/app/oracle/product/11.2.0/db_1/network/admin; export TNS_ADMIN
PATH=$SDEHOME/bin:$ORACLE_HOME/bin:/usr/bin:/usr/ucb:/etc:.; export PATH
LD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
----------------------------------------------------------------------------------------------
component installation
cd /cdrom/oracle or where you copied your installation
go to the directory of your installation e.g. /cdrom/esri/solaris/Oracle_10g or Oracle_11g
------------------------------------------------------------------------------
issue this command
u+x install (it will make your script executable)
./install -load
ESRI is willing to license the software to you only if you accept
and agree to the enclosed license agreement. If you have read and
agree with the terms in the enclosed license agreement type 'yes' to
continue the installation process, if not press or type
'no' to exit installation process. [no] yes
Enter product number to load: [1] 12
Enter pathname to install directory: [/home/sde/ESRI-linux/oracle10g]
The pathname to the install directory must not contain any upper-case letters Enter pathname to install directory: [/home/sde/ESRI-linux/oracle10g] export/home/sde/sdeexe9.3
Directory does not exist: export/home/sde/sdeexe9.3
Would you like to create it? [yes]
ArcSDE Product
Package numbers to load: [all]
Package selection complete
You have chosen the following packages to be loaded
ArcSDE Product
ArcSDE Server
Is this correct? [yes]
List file names while loading? [no] yes
--------------------------------------------------------------
* Uncomment esri_sde 5151/tcp # ArcSDE service on pinetree
in $SDEHOME/etc/services.sde
-----------------------------------------------------------------
Copy the createsdeoracle.sql script to oracle home ------- (/export/home/oracle)
cp export/home/sde/sdeexe9.3/sdeexe93/tools/oracle/createsdeoracle.sql /home/ora10g/
-------------------------------------------------------------------------------------------
Switch to Oracle user
Modify the createsdeoracle.sql file to replace the LOCATION variable in the line
datafile '/LOCATION/sde.dbf' size 400M
to
datafile '/u01/oradata/SRVSDE/sde.dbf' size 400M ----- (YOU CAN WRITE YOUR OWN DATAFILES PATH)
* Execute the script
---------------------------------------------------------------------------------------------------------------------
NOTES: 1. Before running this script
Replace the word LOCATION with the pathname for the sde.dbf datafile to be created.
use the sys user to run this script. ** You will also need to the system password
LOGIN TO sqlplus with sys user
sys as sysdba
@createsdeoracle.sql (OR YOU CAN WRITE THE PATH WHERE SCRIPT FILE IS LOCATED)
-------------------------------------------------------------------------------------------------
* Connect as system/ to create the sde* tablespace and user.Enter password: Connected.
* Create the sde tablespace.
* Before you run this script update LOCATION for the desired datafile pathname.Tablespace created.
* Create the sde user
* The password for the sde user is set to "XXX". You may
* change this if you wish.User created.
* Granting the required privileges to the sde user.
Grant succeeded.
Grant succeeded.
Grant succeeded.
rant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
* SELECT ANY TABLE is required for compressing the database
* This privilege needs to be granted whenever a compress is run.Grant succeeded.
* ADMINISTER DATABASE TRIGGER can be revoked after installGrant succeeded.
-------------------------------------------------------------------------------------------------
CONNECT TO DATABASE AS sys as sysdba
and issue these statements
SQL> GRANT EXECUTE ON dbms_pipe TO public;
GRANT EXECUTE ON dbms_lock TO public;
Grant succeeded.
Grant succeeded
exit
----------------------------------------------------------------------------------------------------
now go to
$SDEHOME/bin directory and issue this command
sdesetup -o install -d ORACLE11G -s RMGC -u sde -l /u01/sdelic.ecp
-d Database Version (e.g. ORACLE10G, ORACLE11G)
-s database name
-u user
-l licensefile path
ESRI ArcSDE Server Setup Utility Thu Jul 2 10:43:51 2009
--------------------------------------------
Install or update ArcSDE, GDB schema objects:
Are you sure? (Y/N): y
-------------------------------------------------------------------------------------------------------
Creating ArcSde schema.....
Successfully created ArcSde schema.
Installing locators.....
Successfully installed locators.
Creating geodatabase schema.....
Successfully created GDB schema.
Registering authorization key.....
Successfully registered authorization key.
Successfully installed ArcSDE components.
Refer SDEHOME\etc\sde_setup.log for more details.
-------------------------------------------------------------------------------------------------------
Start the sde service
sdemon -o start
Please enter ArcSDE DBA password:
-------------------------------------------------------
ArcSDE 9.3 for Oracle10g Build 508 Thu Apr 17 12:23:18 2008-------------------------------------------------------
ST_Geometry Schema Owner: (SDE) Type Release: 1007
Instance initialized for ((sde)) . . .Connected to instance . . .
DBMS Connection established...
RDBMS: "Oracle"
Instance Name: "esri_sde"
IOMGR Process ID (PID): 13547
ArcSDE Instance esri_sde started Thu Jul 2 11:05:33 2009
-------------------------------------------------------------------------------------------------------
No comments:
Post a Comment