Dear
Readers,
My
name is Franz Devantier, creator of this blog. I am an Oracle Certified
Professional (OCP DBA 11g) Security DBA.
I will be sharing with you the basic duties of an Oracle DBA, and also
some of the undocumented, and not so well known tasks.
For Companies:
Free Database health check, for your database installation. One months free database support, for you, as a proof of concept.
For individuals:
Refer me to a company for a database support contract.
=> I will then give you 10% of the monthly contract value, for the duration of the contract. Plus when the contract is extended or renewed you will still get 10% of the monthly contract value, until I no longer support the company, sometime in the future.
=> This 10% is my marketing budget, so if you refer me to a company I will give you my marketing budget. Now that is probably the best deal you will ever get for a referral.
Contact: devantierf@gmail.com
Oracle
Database Preinstallation – Part 14
Configuring the
oracle User’s Environment
You are almost ready now to
run Oracle Universal Installer(OUI) from the oracle account.
You run Oracle Universal
Installer from the oracle
account.
However, before you start Oracle Universal Installer, you must configure the
environment of the oracle
user. To
configure the environment, you must:
=> Set the default file
mode creation mask. The 022 is an octal
number representation. The 755 is the
decimal number that is derived from converting the binary number: 111 101 101
to 755
Octal value : Permission
0 : read, write and execute
1 : read and write
2 : read and execute
3 : read only
4 : write and execute
5 : write only
6 : execute only
7 : no permissions
$ umask 022
This effectively gives the
permissions of 755
Which means:
User : read, write and execute
Group: read and execute
Other : read and execute
To set the oracle user’s environment:
=> Start a new terminal
session, for example, an X terminal, by using a tool such as xterm.
=> Make sure that X
Windows applications can display on this system
$ xhost fred.oracle.oneway.com
=> Log onto the system
where you want to install the software as the oracle user.
=> If you are logged in as
root, then you can just:
$ su – oracle
=> Determine which shell you
are logged in to.
$ echo $SHELL
=> run the shell startup
script.
Bash shell
$ ../.bash_profile
Bourne or Korn shell
$ ../.profile
C shell
% source ./.login
=> If yo are not installing
the software on the local computer, then run the following command on the
remote computer to set the DISPLAY variable.
Bourne, Bash, or Korn shell
$ export DISPLAY=<Host name
or IP address>:0.0
C shell
% setenv DISPLAY <Host name or IP
address>:0.0
Verify that the SHELL and
DISPLAY environment variables are set properly on the remote computer.
$ echo $SHELL
$ echo $DISPLAY
Now back to the local computer, and
enable X applications
$ xhost + <fully qualified remote host
name>
Run the xclock application to verify that
all is working corerectly
$xclock
You should get a small window popping up
on your screen showing a clock. You can
close this application now.
Xclock is usually located at
/usr/X11R6/bin/sclocks
=> if the /tmp directory has less than
1GB of free space, then find a file system with enough space, and set the TMP
and TMPDIR environment variables to this identified file system.
$ df –h /tmp
$ sudo mkdir /<mount_point>/tmp
$ sudo chmod 760 /<mount_point>/tmp
$ TMP = /<mount_point>/tmp
$ TMPDIR = /<mount_point>/tmp
$ export TMP TMPDIR
=> set the ORACLE_BASE and
ORACLE_SID environment variables.
$ export the ORACLE_BASE=/u01/app/oracle
$ export ORACLE_SID=SELLER
=> Make sure that the
ORACLE_HOME and TNS_ADMIN environment variable is not set.
$ unset ORALE_HOME
$ unset TNS_ADMIN
Oracle recommends that if you
set the ORACLE_BASE environment variable, that you should unset the ORACLE_HONE
environment variable. If you set the
ORACLE_HOME environment variable, then OUI will use that value as the default
path for the Oracle home directory.
Franz
Devantier,
Need
a database health check?
devantierf@gmail.com
Classifieds
No comments:
Post a Comment