=========================
change number=CHG0072154
-------------------on local system-----------------
[shahique@oc5327222715 Desktop]$ xclock
Warning: Missing charsets in String to FontSet conversion
[shahique@oc5327222715 Desktop]$
[shahique@oc5327222715 Desktop]$ xhost +10.245.18.175
10.245.18.175 being added to access control list
[shahique@oc5327222715 Desktop]$
[shahique@oc5327222715 Desktop]$ ifconfig -a
eth0 Link encap:Ethernet HWaddr 28:D2:44:27:AA:A6
inet addr:9.120.210.43
---------------------------boots db system--------
export DISPLAY=9.120.210.59:1:0
oracle@hlthrecdevdb response]$ export DISPLAY=9.120.210.43:0.0
[oracle@hlthrecdevdb response]$
[oracle@hlthrecdevdb response]$
[oracle@hlthrecdevdb response]$ xclock
-bash: xclock: command not found
[oracle@hlthrecdevdb response]$ echo $SHELL
/bin/bash
[oracle@hlthrecdevdb response]$
[oracle@hlthrecdevdb response]$ id
uid=532(oracle) gid=503(dba) groups=503(dba),502(oinstall),504(oper) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@hlthrecdevdb response]$ cd ..
[oracle@hlthrecdevdb database]$ ls -ltr
total 36
-rwxr-xr-x. 1 oracle dba 500 Feb 6 2013 welcome.html
-rwxr-xr-x. 1 oracle dba 8533 Jul 7 2014 runInstaller
drwxr-xr-x. 2 oracle dba 4096 Jul 7 2014 rpm
drwxrwxr-x. 2 oracle dba 4096 Jul 7 2014 sshsetup
drwxr-xr-x. 14 oracle dba 4096 Jul 7 2014 stage
drwxr-xr-x. 4 oracle dba 4096 Jul 7 2014 install
drwxrwxr-x. 2 oracle dba 4096 Oct 15 15:07 response
[oracle@hlthrecdevdb database]$ ./runInstaller
Source location is incomplete. Make sure you have downloaded and extracted
all the relevant archives.
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$ xclock
-bash: xclock: command not found
Most issues with remote installations occur in steps 4, 5, and 6. Make sure you’ve properly enabled remote-client
access to your local X server (running on your home computer) via the xhost command. The xhost command must
be run on the local computer on which you want the graphical display presented. Using the + (plus sign) with the
remote hostname adds a host to the local access list. This enables the remote server to display an X window on the
local host. If you type the xhost command by itself (with no parameters), it displays all remote hosts that can display X
sessions on the local computer:
$ xhost
access control disabled, clients can connect from any host
Setting the DISPLAY OS variable on the remote server is also crucial. This allows you to log in to another host
remotely and display an X application back to your local computer. The DISPLAY variable must be set on the remote
database server, to contain information that points it to the local computer on which you want the graphical screen
displayed.
=============================
to install from GUI
X Window System software should be installed
Use the tar -tvf <tarfile_name> command to preview which directories and files are restored without
a
ctually restoring them.
Listed next is a powerful one-line combination of commands that allows you to bundle the Oracle files, copy
them to a remote server, and have them extracted remotely:
$ tar -cvf - <locDir> | ssh <remoteNode> "cd <remoteDir>; tar -xvf -"
For instance, the following command copies everything in the dev_1 directory to the remote ora03 server
/home/oracle directory:
$ tar -cvf - dev_1 | ssh ora03 "cd /home/oracle; tar -xvf -"
I now have my servers handed over to me so we can now commence installation, backup and monitoring of Oracle 12c as previously communicated. Server details for this install are:
Host Name HLTHRECDEVDB
IP Address 10.245.18.175
O/S RHEL 6
Update / Service Pack U3
Classification Test
Type (physical, virtual, flex) Virtual
Data Centre Name Boots D125
Project Name Health Records Development Servers
BS version 1.7
https://support.oracle.com/epmos/#Linuxx8664
5:45:09 PM: pprasanj@in.ibm.com - Prince Prasanjit Das/India/Contr/IBM: SR 3-11530037001
passwd oracle
yum install oracle-rdbms-server-12cR1-preinstall
chown oracle:oinstall oraInst.loc
# chmod 664 oraInst.loc
rpm –ivh
rpm -ivh binutils-2.17.50.0.6
rpm -qa binutils-2.17.50.0.6
grep SwapTotal /proc/meminfo
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# uname -m
x86_64
[root@hlthrecdevdb ~]# uname -a
Linux hlthrecdevdb 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
[root@hlthrecdevdb ~]# free
total used free shared buffers cached
Mem: 32881524 3642528 29238996 0 221728 2683896
-/+ buffers/cache: 736904 32144620
Swap: 10485752 0 10485752
[root@hlthrecdevdb ~]# grep SwapTotal /proc/meminfo
SwapTotal: 10485752 kB
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# grep MemTotal /proc/meminfo
MemTotal: 32881524 kB
[root@hlthrecdevdb ~]#
# chown -R oracle:dba /u01
chown -R oracle:dba /oracle
# chown -R oracle:dba /u02
chown -R oracle:dba /Data1
chown -R oracle:dba /Data2
chown -R oracle:dba /arch
chown -R oracle:dba /backup
chown -R oracle:dba /oracle
chown -R oracle:dba /redo1
chown -R oracle:dba /redo2
chown -R oracle:dba /trace
chown -R oracle:dba /temp
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/vg-root 5160576 387748 4510684 8% /
tmpfs 16440760 0 16440760 0% /dev/shm
/dev/mapper/App_vg-App_lv 103208224 192116 97773436 1% /APP
/dev/mapper/oracle_vg-oracle_lv2 25803068 176064 24316284 1% /Data1
/dev/mapper/oracle_vg-oracle_lv3 25803068 176064 24316284 1% /Data2
/dev/mapper/oracle_vg-oracle_lv6 41284928 180104 39007672 1% /arch
/dev/mapper/oracle_vg-oracle_lv9 41284928 180104 39007672 1% /backup
/dev/sda1 516040 43680 446148 9% /boot
/dev/mapper/vg-home 6192704 144016 5734116 3% /home
/dev/mapper/vg-opt 8773016 249316 8078056 3% /opt
/dev/mapper/vg-ITM 4128448 379480 3539256 10% /opt/IBM/ITM
/dev/mapper/vg-IMB 4128448 139256 3779480 4% /opt/IMB
/dev/mapper/vg-tivoli 4128448 500760 3417976 13% /opt/tivoli
/dev/mapper/oracle_vg-oracle_lv1 41284928 180104 39007672 1% /oracle
/dev/mapper/oracle_vg-oracle_lv4 4128448 139256 3779480 4% /redo1
/dev/mapper/oracle_vg-oracle_lv5 4128448 139256 3779480 4% /redo2
/dev/mapper/oracle_vg-oracle_lv7 20642428 176064 19417788 1% /temp
/dev/mapper/vg-tmp 6192704 1823248 4054884 32% /tmp
/dev/mapper/oracle_vg-oracle_lv8 10321208 154100 9642820 2% /trace
/dev/mapper/vg-usr 6192704 1718144 4159988 30% /usr
/dev/mapper/vg-var 4128448 283856 3634880 8% /var
/dev/mapper/vg-perfmgr 2064208 68608 1890744 4% /var/adm/perfmgr
/dev/mapper/vg-software 10321208 6798440 2998480 70% /software
[root@hlthrecdevdb ~]#
cat /etc/group
wbpriv:x:88:
oinstall:x:502:
dba:x:503:oracle
[root@hlthrecdevdb ~]#
# groupadd oinstall
# groupadd dba
# groupadd oper
useradd -g oinstall -G dba oracle
useradd -u 502 -g oinstall -G dba,oper oracle
/usr/sbin/usermod -g dba -G oinstall,oper oracle
cat /etc/passwd
oracle:x:532:503::/home/oracle:/bin/bash
[root@hlthrecdevdb ~]#
If you need to modify a group, as root, use the groupmod command. If, for any reason, you need to remove a
group (as root) use the groupdel command
=======================
[root@hlthrecdevdb ~]# find / -name X11
/etc/X11
/usr/share/X11
/usr/lib64/X11
/usr/include/X11
[root@hlthrecdevdb ~]# cat /proc/version
Linux version 2.6.32-279.el6.x86_64 (mockbuild@x86-008.build.bos.redhat.com) (gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) ) #1 SMP Wed Jun 13 18:24:36 EDT 2012
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# repoquery -q -l xorg-x11-apps.x86_64 | grep xclock
Repository 'rhel-63-repo' is missing name in configuration, using id
Traceback (most recent call last):
File "/usr/bin/repoquery", line 1241, in <module>
main(sys.argv)
File "/usr/bin/repoquery", line 1235, in main
repoq.runQuery(regexs)
File "/usr/bin/repoquery", line 840, in runQuery
out = pkg.doQuery(oper)
File "/usr/bin/repoquery", line 197, in doQuery
return getattr(self, "fmt_%s" % method)(*args, **kw)
File "/usr/bin/repoquery", line 245, in fmt_list
return "\n".join(self.files())
File "/usr/bin/repoquery", line 498, in files
for ftype in self.pkg.returnFileTypes():
File "/usr/lib/python2.6/site-packages/yum/sqlitesack.py", line 372, in returnFileTypes
self._loadFiles()
File "/usr/lib/python2.6/site-packages/yum/sqlitesack.py", line 294, in _loadFiles
self.sack.populate(self.repo, mdtype='filelists')
File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 184, in populate
xml = repo_get_function()
File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 1634, in getFileListsXML
return self.retrieveMD('filelists')
File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 1552, in retrieveMD
return self._retrieveMD(mdtype)
File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 1608, in _retrieveMD
size=thisdata.size)
File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 835, in _getFile
raise Errors.NoMoreMirrorsRepoError, errstr
yum.Errors.NoMoreMirrorsRepoError: failure: repodata/filelists.xml.gz from yum_rpmsEL6-x86_64_level4: [Errno 256] No more mirrors to try.
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# repoquery -q -f */xclock
Repository 'rhel-63-repo' is missing name in configuration, using id
No package provides */xclock
[root@hlthrecdevdb ~]#
yum search xclock
1) log into console as root and open a terminal window within CDE
2) DISPLAY=:0.0
3) export DISPLAY
4) xhost +
5) su - oracle
6) DISPLAY=:0.0
7) export DISPLAY
8) /user/openwin/bin/xclock <launched xclock this way to ensure it was working, and it was>
9) changed back to the directory where the runInstaller was and launched.
============================
rpm -q gcc-4.4.4-13.el6*
Packages for Oracle Linux 6
and Red Hat Enterprise Linux
6
Oracle Linux 6 with the Unbreakable Enterprise kernel:
2.6.39-200.24.1.el6uek.x86_64 or later
Red Hat Enterprise Linux 6: 2.6.32-71.el6.x86_64 or later
The following packages (or later versions) must be installed:
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (i686)
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (i686)
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (i686)
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6 (i686)
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6 (i686)
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (i686)
libXext-1.1 (x86_64)
libXext-1.1 (i686)
libXtst-1.0.99.2 (x86_64)
libXtst-1.0.99.2 (i686)
libX11-1.3 (x86_64)
libX11-1.3 (i686)
libXau-1.0.5 (x86_64)
libXau-1.0.5 (i686)
libxcb-1.5 (x86_64)
libxcb-1.5 (i686)
libXi-1.3 (x86_64)
libXi-1.3 (i686)
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
rpm -q binutils compat-libstdc++ gcc glibc libaio libgcc libstdc++ \
make sysstat unixodbc
[root@hlthrecdevdb ~]# grep dba /etc/group
dba:x:503:oracle
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep sem
kernel.sem = 250 32000 32 128
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep shm
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.shm_rmid_forced = 0
vm.hugetlb_shm_group = 0
[root@hlthrecdevdb ~]# 536870912
-bash: 536870912: command not found
[root@hlthrecdevdb ~]#
# /sbin/sysctl -a | grep sem
This command displays the value of the semaphore parameters in the order listed.
shmall, shmmax, and shmmni # /sbin/sysctl -a | grep shm
file-max #
ip_local_port_range # /sbin/sysctl -a | grep ip_local_port_range
rmem_default # /sbin/sysctl -a | grep rmem_default
rmem_max # /sbin/sysctl -a | grep rmem_max
wmem_default # /sbin/sysctl -a | grep wmem_default
wmem_max # /sbin/sysctl -a | grep wmem_max
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep ip_local_port_range
net.ipv4.ip_local_port_range = 32768 61000
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep rmem_default
net.core.rmem_default = 229376
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep rmem_max
net.core.rmem_max = 131071
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep wmem_default
net.core.wmem_default = 229376
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep wmem_max
net.core.wmem_max = 131071
[root@hlthrecdevdb ~]#
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
kernel.shmall = 2097152
kernel.shmmax = 536870912
=================
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep sem
kernel.sem = 250 32000 100 128
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep file-max
fs.file-max = 6815744
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep ip_local_port_range
net.ipv4.ip_local_port_range = 9000 65500
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep rmem_default
net.core.rmem_default = 262144
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep rmem_max
net.core.rmem_max = 4194304
[root@hlthrecdevdb ~]# ulimit -Sn
1024
[root@hlthrecdevdb ~]# ulimit -Hn
4096
[root@hlthrecdevdb ~]# ulimit -Su
256734
[root@hlthrecdevdb ~]# ulimit -Hu
256734
[root@hlthrecdevdb ~]#
==============
ulimit -Hn
==========
[oracle@hlthrecdevdb ~]$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 256734
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1024
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[oracle@hlthrecdevdb ~]$ ulimit -Hn
4096
[oracle@hlthrecdevdb ~]$
recommend
$ ulimit -Hn
65536 To change this limit, edit the /etc/security/limits.conf file as root and make the following changes or add the following lines, respectively:
oracle soft nofile 4096
oracle hard nofile 63536
-----------
=================installation==============
Step 5: Creating oraInst.loc File
If an oraInst.loc file already exists on your server, then you can skip this step. Creating the oraInst.loc file only
needs to be performed the first time you install binaries on a server, using the silent install method. If you’re using the
OUI graphical installer, then the oraInst.loc file is created automatically for you.
On Linux servers the oraInst.loc file is usually located in the /etc directory. On other Unix systems (such as
Solaris) this file is located in the /var/opt/oracle directory. The oraInst.loc file contains the following information:
• Oracle inventory directory path
• Name of OS group that has permissions for installing and upgrading Oracle software
The Oracle inventory directory path is the location of files associated with managing Oracle installations and
upgrades. Typically, there is one Oracle inventory per host. Within this directory structure is the inventory.xml file,
which contains a record of where various versions of Oracle have been installed on the server.
The Oracle inventory OS group has the OS permissions required for installing and upgrading Oracle software.
Oracle recommends that you name this group oinstall. You’ll find that sometimes DBAs assign the inventory group
to the dba group. If your environment doesn’t require a separate group (such as oinstall), then using the dba group
is fine.
You can create the oraInst.loc file with a utility such as vi. Here are some sample entries in the file:
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
As root, ensure that the response file is owned by the oracle OS user and that it has the proper file
access privileges:
# chown oracle:oinstall oraInst.loc
# chmod 664 oraInst.loc
9
Chapter 1 ■ Installing the Oracle Binaries
./runInstaller -ignoreSysPrereqs -force -silent -responseFile \
/oracle/oracle_software/database/response/db_install_new.rsp
or
./runInstaller -ignoreSysPrereqs -force -silent -responseFile \
/oracle/oracle_software/database/response/db_install_new.rsp
./runInstaller -ignoreSysPrereqs -force -silent -responseFile /oracle/oracle_software/database/response/db_install_new.rsp
If you encounter errors with the installation process, you can view the associated log file. Each time you attempt
to run the installer, it creates a log file with a unique name that includes a timestamp. The log file is located in the
oraInventory/logs directory. You can stream the output to your screen as the OUI writes to it:
$ tail -f <logfile name>
Here is an example of a log file name:
installActions2012-04-33 11-42-52AM.log
If everything runs successfully, in the output you’re notified that you need to run the root.sh script as the
root user:
#Root scripts to run
/oracle/app/oracle/product/11.2.0/db_1/root.sh
==========
[oracle@hlthrecdevdb database]$ java -version
java version "1.6.0_33"
OpenJDK Runtime Environment (IcedTea6 1.13.5) (rhel-1.13.5.0.el6_6-x86_64)
OpenJDK 64-Bit Server VM (build 23.25-b01, mixed mode)
[oracle@hlthrecdevdb database]$
Check if some JDK is installed in your system:
$ java -version
Installing JDK 7 solved my problem:
$ sudo apt-get install openjdk-7-jre-headless
If the problem persists, log as root, then execute:
$ xhost +
============
You can create the oraInst.loc file with a utility such as vi. Here are some sample entries in the file:
inventory_loc=/oracle/oraInventory
inst_group=oinstall
vi oraInst.loc
# chown oracle:oinstall oraInst.loc
# chmod 664 oraInst.loc
=================================
rwxr-xr-x. 14 oracle dba 4096 Jul 7 2014 stage
drwxr-xr-x. 4 oracle dba 4096 Oct 16 11:59 install
drwxrwxr-x. 2 oracle dba 4096 Oct 26 15:42 response
[oracle@hlthrecdevdb database]$ ./runInstaller -ignoreSysPrereqs -force -silent
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 3145 MB Passed
Checking swap space: must be greater than 150 MB. Actual 10239 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-10-26_03 mandatory requirements.
CAUSE: Some of the mandatory prerequisites are not met. See logs for details.
ACTION: Identify the list of failed prerequisite checks from the log: /oracle ion manual find the appropriate configuration to meet the prerequisites and fix
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$ ./runInstaller -ignoreSysPrereqs -force -silent -responseFile /oracle/oracle_software/database/response/db_install_new.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 3136 MB Passed
Checking swap space: must be greater than 150 MB. Actual 10239 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-10-26_03-46-01PM. Please wait ...[oracle@hlthrecdevdb database]$ [FATAL] [INS-13013] Target environment does not meet some mandatory requirements.
CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /oracle/product/oraInventory/logs/installActions2015-10-26_03-46-01PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /oracle/product/oraInventory/logs/installActions2015-10-26_03-46-01PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
=====================
INFO: *********************************************
INFO: Hard Limit: maximum open file descriptors: This is a prerequisite condition to test whether the hard limit for "maximum open file descriptors" is set correctly.
INFO: Severity:CRITICAL
INFO: OverallStatus:VERIFICATION_FAILED
INFO: -----------------------------------------------
INFO: Verification Result for Node:hlthrecdevdb
INFO: Expected Value:65536
INFO: Actual Value:63536
INFO: Error Message:PRVF-4354 : Proper hard limit for resource "maximum open file descriptors" not found on node "hlthrecdevdb" [Expected = "65536" ; Found = "63536"]
INFO: Cause: Hard limit for the resource does not meet the requirement on the specified node.
INFO: Action: Modify the resource limits to meet the requiremen
INFO: *********************************************
INFO: Soft Limit: maximum user processes: This is a prerequisite condition to test whether the soft limit for "maximum user processes" is set correctly.
INFO: Severity:IGNORABLE
INFO: OverallStatus:VERIFICATION_FAILED
INFO: ------------------------------------
INFO: Verification Result for Node:hlthrecdevdb
INFO: Expected Value:2047
INFO: Actual Value:1024
INFO: Error Message:PRVF-4353 : Proper soft limit for resource "maximum user processes" not found on node "hlthrecdevdb" [Expected = "2047" ; Found = "1024"]
INFO: Cause: Soft limit for the resource does not meet the requirement on the specified node.
INFO: Action: Modify the resource limits to meet the requirement.
INFO: Severity:IGNORABLE
INFO: OverallStatus:VERIFICATION_FAILED
INFO: -----------------------------------------------
INFO: Verification Result for Node:hlthrecdevdb
INFO: Expected Value:16GB (1.6777216E7KB)
INFO: Actual Value:10GB (1.0485752E7KB)
INFO: Error Message:PRVF-7573 : Sufficient swap size is not available on node "hlthrecdevdb" [Required = 16GB (1.6777216E7KB) ; Found = 10GB (1.0485752E7KB)]
INFO: Cause: The swap size found does not meet the minimum requirement.
INFO: Action: Increase swap size to at least meet the minimum swap space requirement
/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
=========================
total 36
-rwxr-xr-x. 1 oracle dba 500 Feb 6 2013 welcome.html
-rwxr-xr-x. 1 oracle dba 8533 Jul 7 2014 runInstaller
drwxr-xr-x. 2 oracle dba 4096 Jul 7 2014 rpm
drwxrwxr-x. 2 oracle dba 4096 Jul 7 2014 sshsetup
drwxr-xr-x. 14 oracle dba 4096 Jul 7 2014 stage
drwxr-xr-x. 4 oracle dba 4096 Oct 16 11:59 install
drwxrwxr-x. 2 oracle dba 4096 Oct 26 15:42 response
[oracle@hlthrecdevdb database]$ ./runInstaller -ignoreSysPrereqs -force -silent -responseFile /oracle/oracle_software/database/response/db_install_new.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 3136 MB Passed
Checking swap space: must be greater than 150 MB. Actual 10239 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-10-26_04-14-38PM. Please wait ...[oracle@hlthrecdevdb database]$ [WARNING] [INS-13014] Target environment does not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
You can find the log of this install session at:
/oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log
The installation of Oracle Database 12c was successful.
Please check '/oracle/product/oraInventory/logs/silentInstall2015-10-26_04-14-38PM.log' for more details.
As a root user, execute the following script(s):
1. /oracle/product/12.1.0.2/root.sh
Successfully Setup Software.
[root@hlthrecdevdb ~]# /oracle/product/12.1.0.2/root.sh
Check /oracle/product/12.1.0.2/install/root_hlthrecdevdb_2015-10-26_16-27-52.log for the output of root script
[root@hlthrecdevdb ~]#
Checking Temp space: must be greater than 500 MB. Actual 3136 MB Passed
Checking swap space: must be greater than 150 MB. Actual 10239 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-10-26_04-14-38PM. Please wait ...[oracle@hlthrecdevdb database]$ [WARNING] [INS-13014] Target environment does not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
You can find the log of this install session at:
/oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log
=================Database creation=============
"/Data1/oradata/","/Data2/oradata/"
oracle@hlthrecdevdb Data1]$ cd oradata
[oracle@hlthrecdevdb oradata]$ ls -ltr
total 0
[oracle@hlthrecdevdb oradata]$ pwd
/Data1/oradata
[oracle@hlthrecdevdb oradata]$
[oracle@hlthrecdevdb oradata]$
[oracle@hlthrecdevdb oradata]$ cd /Data2
[oracle@hlthrecdevdb Data2]$ cd ^C
[oracle@hlthrecdevdb Data2]$
[oracle@hlthrecdevdb Data2]$ ls -ltr
total 20
drwx------. 2 oracle dba 16384 Oct 6 12:54 lost+found
drwxr-xr-x. 2 oracle dba 4096 Oct 15 13:27 oradata
[oracle@hlthrecdevdb Data2]$
[oracle@hlthrecdevdb oradata]$
[oracle@hlthrecdevdb oradata]$
[oracle@hlthrecdevdb oradata]$ cd /Data2
[oracle@hlthrecdevdb Data2]$ cd ^C
[oracle@hlthrecdevdb Data2]$
[oracle@hlthrecdevdb Data2]$ ls -ltr
total 20
drwx------. 2 oracle dba 16384 Oct 6 12:54 lost+found
drwxr-xr-x. 2 oracle dba 4096 Oct 15 13:27 oradata
[oracle@hlthrecdevdb Data2]$ cd /redo1
[oracle@hlthrecdevdb redo1]$ ls -ltr
total 20
drwx------. 2 oracle dba 16384 Oct 6 12:54 lost+found
drwxr-xr-x. 2 oracle dba 4096 Oct 15 13:28 oradata
[oracle@hlthrecdevdb redo1]$ cd /redo2
[oracle@hlthrecdevdb redo2]$
[oracle@hlthrecdevdb redo2]$ cd oradata
[oracle@hlthrecdevdb oradata]$ cd /temp
[oracle@hlthrecdevdb temp]$ cd oradata
[oracle@hlthrecdevdb oradata]$ cd /trace/oradata
[oracle@hlthrecdevdb oradata]$
Shahique - as below, database to be called "orionhealth" please.
Regards
Rob
===================
• ORACLE_HOME
• ORACLE_SID
• LD_LIBRARY_PATH
• PATH
$
$
$
export
export
export
export
export ORACLE_HOME=/oracle/product/12.1.0.2/
export ORACLE_SID=orionhealth
export LD_LIBRARY_PATH=/usr/lib:$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
orionhealth:/oracle/product/12.1.0.2:N
dbca -silent -responseFile /home/oracle/orainst/mydb.rsp
./dbca -silent -responseFile /oracle/oracle_software/database/response/dbca_new1.rsp
AL16UTF16
NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET WE8MSWIN1252
NLS_COMP BINARY
NLS_CURRENCY ú
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE ENGLISH
NLS_DUAL_CURRENCY Ç
NLS_ISO_CURRENCY UNITED KINGDOM
NLS_LANGUAGE ENGLISH
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CHARACTERSET AL16UTF16
dbca_new1.rsp
Bootoracle@123---pass -sys
==============================
[oracle@hlthrecdevdb bin]$ ./dbca -silent -responseFile /oracle/oracle_software/database/response/dbca_new1.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
37% complete
Creating and starting Oracle instance
DBCA Operation failed.
Look at the log file "/oracle/product/cfgtoollogs/dbca/orionhealth/orionhea.log" for further details.
[oracle@hlthrecdevdb bin]$
[oracle@hlthrecdevdb response]$ more /oracle/product/cfgtoollogs/dbca/orionhealth/orionhea.log
Unique database identifier check passed.
/oracle/ has enough space. Required space is 4560 MB , available space is 27407 MB.
/Data1/ has enough space. Required space is 1580 MB , available space is 23746 MB.
File Validations Successful.
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 11%
DBCA_PROGRESS : 18%
DBCA_PROGRESS : 37%
Creating and starting Oracle instance
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/Data1/oradata/'
ORA-27056: could not delete file
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/Data1/oradata/'
ORA-27056: could not delete file
DBCA_PROGRESS : DBCA Operation failed.
[oracle@hlthrecdevdb response]$
[oracle@hlthrecdevdb bin]$ ./dbca -silent -responseFile /oracle/oracle_software/database/response/dbca_new1.rsp
Cleaning up failed steps
5% complete
Copying database files
7% complete
9% complete
16% complete
23% complete
30% complete
41% complete
Creating and starting Oracle instance
43% complete
48% complete
53% complete
58% complete
59% complete
62% complete
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
96% complete
100% complete
Look at the log file "/oracle/product/cfgtoollogs/dbca/orionhealth/orionhea0.log" for further details.
[oracle@hlthrecdevdb bin]$
netca -silent -responsefile /oracle/oracle_software/database/response/netca_new.rsp
orionhealth =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = hlthrecdevdb)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = orionhealth)
)
)
SQL>
SQL> set linesize 200
SQL>
SQL> SQL>
SQL>
SELECT member FROM v$logfile
UNION ALL
SELECT name FROM v$datafile
UNION ALL
SELECT name FROM v$controlfile
union all
select file_name from dba_temp_filesSQL> 2 3 4 5 6 7
8 ;
MEMBER
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/Data1/oradata/orionhealth/redo03.log
/Data1/oradata/orionhealth/redo02.log
/Data1/oradata/orionhealth/redo01.log
/Data1/oradata/orionhealth/system01.dbf
/Data1/oradata/orionhealth/sysaux01.dbf
/Data1/oradata/orionhealth/undotbs01.dbf
/Data1/oradata/orionhealth/users01.dbf
/Data1/oradata/orionhealth/control01.ctl
/oracle/product/fast_recovery_area/orionhealth/control02.ctl
/Data1/oradata/orionhealth/temp01.dbf
10 rows selected.
SQL>
=to change path for temp file========
SELECT file_id, file_name FROM dba_temp_files;
Alter database tempfile '/Data1/oradata/orionhealth/temp01.dbf' offline;
mv /Data1/oradata/orionhealth/temp01.dbf /temp/oradata/orionhealth/temp01.dbf
Alter database rename file '/Data1/oradata/orionhealth/temp01.dbf' to '/temp/oradata/orionhealth/temp01.dbf';
SELECT file_id, file_name,status FROM dba_temp_files;
Alter database tempfile '/temp/oradata/orionhealth/temp01.dbf' online;
SELECT file_id, file_name,status FROM dba_temp_files;
================to change redo log============
SQL> column member format a55
SQL> select group#, member from v$logfile
2 ;
GROUP# MEMBER
---------- -------------------------------------------------------
3 /Data1/oradata/orionhealth/redo03.log
2 /Data1/oradata/orionhealth/redo02.log
1 /Data1/oradata/orionhealth/redo01.log
SQL>
SQL> SELECT * FROM V$LOG;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
1 1 7 52428800 512 3 NO CURRENT 1612504 27-OCT-15 2.8147E+14 0
2 1 5 52428800 512 3 NO INACTIVE 1612472 27-OCT-15 1612501 27-OCT-15 0
3 1 6 52428800 512 3 NO INACTIVE 1612501 27-OCT-15 1612504 27-OCT-15 0
ALTER DATABASE ADD LOGFILE MEMBER '/redo2/oradata/orionhealth/redo03B.log' TO GROUP 3;
ALTER DATABASE ADD LOGFILE MEMBER '/redo2/oradata/orionhealth/redo02B.log' TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER '/redo2/oradata/orionhealth/redo01B.log' TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER '/redo1/oradata/orionhealth/redo03A.log' TO GROUP 3;
ALTER DATABASE ADD LOGFILE MEMBER '/redo1/oradata/orionhealth/redo02A.log' TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER '/redo1/oradata/orionhealth/redo01A.log' TO GROUP 1;
switch log file and make sure log file is not current
alter system switch logfile;
alter database drop logfile member '/Data1/oradata/orionhealth/redo03.log';
alter database drop logfile member '/Data1/oradata/orionhealth/redo02.log';
alter database drop logfile member '/Data1/oradata/orionhealth/redo01.log';
rm /Data1/oradata/orionhealth/redo01.log
rm /Data1/oradata/orionhealth/redo02.log
rm /Data1/oradata/orionhealth/redo03.log
'
ls -ltr /Data1/oradata/orionhealth/redo01.log
ls -ltr /Data1/oradata/orionhealth/redo02.log
ls -ltr /Data1/oradata/orionhealth/redo03.log
column member format a55
select group#, member from v$logfile
SELECT * FROM V$LOG;
=============
orionDB
/oracle/product/diag/rdbms/oriondb/orionDB/trace
SQL> select value from v$diag_info where name='Diag Trace';
VALUE
--------------------------------------------------------------------------------
/oracle/product/diag/rdbms/oriondb/orionDB/trace
SQL> SQL>
SQL> show parameter control_files
======Identifying DBA-Created Accounts============
SQL> ;
1 select distinct u.username
2 ,case when d.user_name is null then 'DBA created account'
3 else 'Oracle created account'
4 end
5 from dba_users
6 u
7 ,default_pwd$ d
8* where u.username=d.user_name(+)
SQL>
SQL> /
USERNAME CASEWHEND.USER_NAMEISN
-------------------------------------------------------------------------------------------------------------------------------- ----------------------
SYSKM Oracle created account
SPATIAL_CSW_ADMIN_USR Oracle created account
ORDDATA Oracle created account
GSMADMIN_INTERNAL Oracle created account
SPATIAL_WFS_ADMIN_USR Oracle created account
APPQOSSYS Oracle created account
AUDSYS Oracle created account
LBACSYS Oracle created account
SYS Oracle created account
APEX_040200 Oracle created account
DVSYS Oracle created account
USERNAME CASEWHEND.USER_NAMEISN
-------------------------------------------------------------------------------------------------------------------------------- ----------------------
MDDATA Oracle created account
ORDSYS Oracle created account
DVF Oracle created account
SI_INFORMTN_SCHEMA Oracle created account
ANONYMOUS Oracle created account
XS$NULL Oracle created account
FLOWS_FILES Oracle created account
GSMUSER Oracle created account
ORDPLUGINS Oracle created account
XDB Oracle created account
SYSDG Oracle created account
USERNAME CASEWHEND.USER_NAMEISN
-------------------------------------------------------------------------------------------------------------------------------- ----------------------
OUTLN Oracle created account
CTXSYS Oracle created account
WMSYS Oracle created account
OLAPSYS Oracle created account
GSMCATUSER Oracle created account
OJVMSYS Oracle created account
SYSTEM Oracle created account
SCOTT Oracle created account
DIP Oracle created account
SYSBACKUP Oracle created account
DBSNMP Oracle created account
USERNAME CASEWHEND.USER_NAMEISN
-------------------------------------------------------------------------------------------------------------------------------- ----------------------
MDSYS Oracle created account
ORACLE_OCM Oracle created account
APEX_PUBLIC_USER Oracle created account
36 rows selected.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /Data1/oradata/orionDB/control
01.ctl, /oracle/product/fast_r
ecovery_area/orionDB/control02
.ctl
SQL>
select value from v$diag_info where name = 'Diag Trace';
SQL> ALTER SYSTEM SET diagnostic_dest='/u01/app/oracle';
alter system set audit_file_dest ='/trace/oradata/orionDB/adump' scope=spfile
System altered.
alter system set user_dump_dest ='/trace/oradata/orionDB/' scope=spfile
QL>
SQL> show parameter dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /oracle/product/12.1.0.2/rdbms
/log
core_dump_dest string /trace/oradata/orionDB/diag/rd
bms/oriondb/orionDB/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /oracle/product/12.1.0.2/rdbms
/log
SQL>
unified_audit_sga_queue_size integer 1048576
use_dedicated_broker boolean FALSE
use_indirect_data_buffers boolean FALSE
use_large_pages string TRUE
user_dump_dest string /oracle/product/12.1.0.2/rdbms
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
/log
utl_file_dir string
workarea_size_policy string AUTO
xml_db_events string enable
SQL>
SQL> !ls -ltr /oracle/product/12.1.0.2/rdbms
total 108
drwxr-xr-x. 3 oracle dba 4096 Oct 26 16:14 utl
drwxr-xr-x. 5 oracle dba 4096 Oct 26 16:14 xml
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:15 mesg
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:15 public
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:15 jlib
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:16 doc
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:16 demo
drwxr-xr-x. 2 oracle dba 65536 Oct 26 16:16 admin
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:16 lib
drwxr-xr-x. 5 oracle dba 4096 Oct 26 16:16 install
drwxr-xr-x. 2 oracle dba 4096 Oct 28 09:21 audit
drwxr-xr-x. 2 oracle dba 4096 Oct 28 10:52 log
SQL>
========================control ===============
alter system set control_files='/redo1/oradata/orionDB/control01.ctl',
'/redo2/oradata/orionDB/control02.ctl' scope=spfile;
4:29:52 PM: pprasanj@in.ibm.com - Prince Prasanjit Das/India/Contr/IBM:
4:29:53 PM: pprasanj@in.ibm.com - Prince Prasanjit Das/India/Contr/IBM:
4:29:54 PM: pprasanj@in.ibm.com - Prince Prasanjit Das/India/Contr/IBM: shut immediate
cd /Data1/oradata/orionDB/
mv control01.ctl /redo1/oradata/orionDB/
cd /oracle/product/fast_recovery_area/orionDB/
mv control02.ctl / redo2/oradata/orionDB/
SQL> show parameter diagnostic_dest
===========================
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
cell_offload_processing boolean TRUE
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 1000
processor_group_name string
SQL> show parameter open_cursors
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 300
SQL> alter system set open_cursors=500
2 ;
System altered.
SQL>
========================================
Hi Arijit/Shahique
Mitra has created the TDP node as follows (thanks Mitra):-
The TSM node has been registered on the ORACLE domain as per the proforma. Please use the below details for configuring the backups.
TSM node Name: HLTHRECDEVDB_ORA
TCP server address: TSM114G01 IP address: 10.220.2.16
Password: HLTHRECDEVDB_ORA
Please can you now configure TDP SW on the DB server and liaise with Mitra when you are ready to schedule the backups and let me know when done plus update me as things progress so that I know it is happening.
Regards
Rob
========tdp configuration=================
./tdpoconf showenv
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015. All rights reserved.
Data Protection for Oracle Information
Version: 7
Release: 1
Level: 3
Sublevel: 0
Platform: 64bit TDPO Linux86-64
Tivoli Storage Manager Server Information
Server Name: HLTHRECDEVDB_ORA
Server Address: 10.220.2.16
Server Type: AIX-RS/6000
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name:
Node Name: HLTHRECDEVDB_ORA
Node Type: TDPO Linux86-64
DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE: /opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /opt/tivoli/tsm/client/oracle/bin64
Compression: FALSE
License Information: License file exists and contains valid license data.
[root@hlthrecdevdb bin64]# pij^C
[root@hlthrecdevdb bin64]# ping 10.220.2.16
PING 10.220.2.16 (10.220.2.16) 56(84) bytes of data.
64 bytes from 10.220.2.16: icmp_seq=1 ttl=252 time=0.304 ms
64 bytes from 10.220.2.16: icmp_seq=2 ttl=252 time=0.296 ms
64 bytes from 10.220.2.16: icmp_seq=3 ttl=252 time=0.319 ms
^C
--- 10.220.2.16 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2741ms
rtt min/avg/max/mdev = 0.296/0.306/0.319/0.017 ms
[root@hlthrecdevdb bin64]#
./tdpoconf SHOWENVironment
tdpoconf showenv -TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
[root@hlthrecdevdb bin64]# pwd
/opt/tivoli/tsm/client/oracle/bin64
[root@hlthrecdevdb bin64]#
[root@hlthrecdevdb bin64]# cat dsm.sys
************************************************************************
* Tivoli Storage Manager *
* *
* Sample Client System Options file for UNIX (dsm.sys.smp) *
************************************************************************
* This file contains the minimum options required to get started
* using TSM. Copy dsm.sys.smp to dsm.sys. In the dsm.sys file,
* enter the appropriate values for each option listed below and
* remove the leading asterisk (*) for each one.
* If your client node communicates with multiple TSM servers, be
* sure to add a stanza, beginning with the SERVERNAME option, for
* each additional server.
new
************************************************************************
SErvername TSM114G01
COMMMethod TCPip
TCPPort 1500
TCPServeraddres 10.220.2.16
[root@hlthrecdevdb bin64]# ping TSM114G01
ping: unknown host TSM114G01
[root@hlthrecdevdb bin64]# ping TSM114G01
ping: unknown host TSM114G01
[root@hlthrecdevdb bin64]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.245.18.175 hlthrecdevdb hlthrecdevdb.centre1.uk.boots.com
10.234.3.15 itmprtems01 itmprtems01.centre1.uk.boots.com
[root@hlthrecdevdb bin64]#
[oracle@hlthrecdevdb bin64]$ cat tdpo.opt.smp
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the LinuxAMD64 Data Protection for Oracle
*********************************************************************
*DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
*DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64
*TDPO_FS /adsmorc
*TDPO_NODE HLTHRECDEVDB_ORA
*TDPO_OWNER <username>
*TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64
*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1
*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4
[oracle@hlthrecdevdb bin64]$
pass for tivoli==oracleoriondb
[oracleg@oracleserver.domainname ~]$ ln -s /opt/tivoli/tsm/client/oracle/bin64/libobk.so $ORACLE_HOME/lib
[oracle@oracleserver.domainname ~]$ ll $ORACLE_HOME/lib/libobk.so
lrwxrwxrwx 1 oraracle dba 45 Jul 13 12:00 /oracle/software/lib/libobk.so -> /opt/tivoli/tsm/client/oracle/bin64/libobk.so
Then ensure dba Unix group (better to provide access to DBA group in case you have multiple Oracle accounts on your server) is able to write in all log files you defined in all TSM configuration files and be able to read tdpo.opt configuration file.
With Unix commands it gives something like:
[root@oracleserver.domainname /]# chmod a+r /opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
[root@oracleserver.domainname /]# chown root:dba /opt/tivoli/tsm/client/oracle/bin64/tdpoerror.log
[root@oracleserver.domainname /]# chmod g+rw /opt/tivoli/tsm/client/oracle/bin64/tdpoerror.log
[root@oracleserver.domainname /]# chown -R root:dba /var/log/tsm
[root@oracleserver.domainname /]# chmod g+rw /var/log/tsm
All errors I personally encountered were linked to missing rights on either log files (write permission) and read rights on configuration files. Don’t be too generous while giving those rights…
And that’s it ! You are done, you can test all is working with (even before starting RMAN):
[oracle@oracleserver.domainname admin]$ sbttest test
The sbt function pointers are loaded from libobk.so library.
-- sbtinit succeeded
Return code -1 from sbtinit, bsercoer = 0, bsercerrno = 0
Message 0 not found; product=RDBMS; facility=SBT
run{ allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ieo2blptsmp01_ora/tdpo.opt)'; }
run
{
allocate channel c1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup database;
release channel c1 ;
}
f
run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\Tivoli Storage Manager\AgentOBA64\tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\Tivoli Storage Manager\AgentOBA64\tdpo.opt)';
backup
filesperset 6
format 'df_%t_%s_%p'
(archivelog all
delete input);
release channel t1;
release channel t2;
}
ln -s /opt/tivoli/tsm/client/oracle/bin64/libobk.so libobk64.so
ln -s /usr/tivoli/tsm/client/oracle/bin64/libobk64.a $ORACLE_HOME/lib/libobk64.a
[oracle@hlthrecdevdb bin64]$ sbttest a -libname libobk.so
The sbt function pointers are loaded from libobk.so library.
Return code -1 from sbtinit, bsercoer = 7011, bsercerrno = 2507
sbtopen: System error - eg. malloc, fork errors
[oracle@hlthrecdevdb bin64]$ sbttest a -libname /opt/tivoli/tsm/client/oracle/bin64/libobk.so
The sbt function pointers are loaded from /opt/tivoli/tsm/client/oracle/bin64/libobk.so library.
Return code -1 from sbtinit, bsercoer = 7011, bsercerrno = 2507
sbtopen: System error - eg. malloc, fork errors
[oracle@hlthrecdevdb bin64]$ sbttest TOTO -dbname orionDB
The sbt function pointers are loaded from libobk.so library.
Return code -1 from sbtinit, bsercoer = 7011, bsercerrno = 2507
sbtopen: System error - eg. malloc, fork errors
[oracle@hlthrecdevdb bin64]$
RMAN> run { allocate channel ch1 type sbt PARMS="SBT_LIBRARY=/opt/tivoli/tsm/client/oracle/bin64/libobk.so";}
ldd /opt/tivoli/tsm/client/oracle/bin64/libobk.so
RMAN> connect target
connected to target database: ORIONDB (DBID=2986822836)
RMAN> run { allocate channel ch1 type sbt PARMS="SBT_LIBRARY=/opt/tivoli/tsm/client/oracle/bin64/libobk.so";}
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ch1 channel at 11/20/2015 15:23:19
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux-x86_64 Error: 2507: Unknown system error
Additional information: 7011
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
SBT error = 7011, errno = 2507, sbtopen: system error
RMAN> exit
Recovery Manager complete.
[oracle@hlthrecdevdb bin64]$ ldd /opt/tivoli/tsm/client/oracle/bin64/libobk.so
linux-vdso.so.1 => (0x00007fff2a9ff000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fe0ee24a000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007fe0edf43000)
libm.so.6 => /lib64/libm.so.6 (0x00007fe0edcbf000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fe0edaa9000)
libc.so.6 => /lib64/libc.so.6 (0x00007fe0ed714000)
/lib64/ld-linux-x86-64.so.2 (0x0000003522600000)
[oracle@hlthrecdevdb bin64]$
Technote (troubleshooting)
Problem(Abstract)
When the oracle database is loaded with svrctl for the cluster access, then the backup fails with:
ORA-27211: Failed to load Media Management Library
Additional information: 2
Symptom
Errors seen:
run
{
allocate channel t1 type sbt parms='ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup database;
}
using target database control file instead of recovery catalog
RMAN-00571: ===============================================
RMAN-00569: ======== ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571: ===============================================
RMAN-03009: failure of allocate command on t1 channel at 08/08/2014 08:51:48
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2
Cause
The environment for the running Oracle application needs to include the library path for the Data Protection libobk file.
Environment
Oracle 11gR2 RAC
Diagnosing the problem
If SQLPlus is used to start the database, then it will successfully load the library.
Also, if the database is set to stand-alone mode, the Data Protection for Oracle library can be loaded.
The problem to load the library is only seen when the Oracle grid software is used to startup the Oracle database in cluster mode.
Resolving the problem
The issue is that the Oracle grid needs to know the Library paths, such that it can search for and load the necessary library files from these related paths. As mentioned in the Oracle Metalink document 1439674.1, you would want to set the paths in the grid for example:
srvctl setenv database -d dbname -t "PATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib, LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib, LIBPATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib:/usr/lib/libobk.a, SHLIB_PATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib:/usr/lib/libobk.a"
Please note that it is necessary to bounce/restart the database via srvctl even though this extra step is not stated within the Metalink document.
This should allow the database to be started/controlled by the Oracle grid and allow the backups to work successfully with the Data Protection for Oracle library interface.
==============
11/20/15 15:07:35 TID<14013> ==> API Run Time Header Level = 7.1.0
11/20/15 15:07:35 TID<14013> ==> API Compile Time Header Level = 7.1.3
11/20/15 15:07:35 TID<14013> ==> ANU2507E Runtime API version is outdated
11/20/15 15:09:34 TID<14052> ==> API Run Time Header Level = 7.1.0
11/20/15 15:09:34 TID<14052> ==> API Compile Time Header Level = 7.1.3
11/20/15 15:09:34 TID<14052> ==> ANU2507E Runtime API version is outdated
12/07/15 14:32:04 TID<25331> ==> API Run Time Header Level = 7.1.0
12/07/15 14:32:04 TID<25331> ==> API Compile Time Header Level = 7.1.3
12/07/15 14:32:04 TID<25331> ==> ANU2507E Runtime API version is outdated
[root@hlthrecdevdb bin64]# pwd
/opt/tivoli/tsm/client/oracle/bin64
[root@hlthrecdevdb bin64]# date
Mon Dec 7 15:28:40 GMT 2015
[root@hlthrecdevdb bin64]#
run {
allocate channel t1 type disk;
backup current controlfile format '/backup/db_backup/rman/%d_%u_%s';
backup database format '/backup/db_backup/rman/%d_%u_%s';
backup archivelog all format '/backup/db_backup/rman/arch_%d_%u_%s';
release channel t1;
}
-----------
#ln -s /opt/tivoli/tsm/client/ba/bin/dsm.sys /opt/tivoli/tsm/client/api/bin64/dsm.sys
ln -s /opt/tivoli/tsm/client/ba/bin/dsm.sys /opt/tivoli/tsm/client/oracle/bin64/dsm.sys
tdpoconf password -TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
[root@hlthrecdevdb bin64]# tdpoconf password -TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015. All rights reserved.
***************************************************************
* IBM Tivoli Storage Manager for Databases Utility
* Password file initialization/update program
***************************************************************
Please enter current password:
Please enter new password:
Please reenter new password for verification:
ANU0260I Password successfully changed.
[root@hlthrecdevdb bin64]#
[root@hlthrecdevdb bin64]# \\
tivoli password==pass for tivoli==oracleoriondb_new1
===================================================
There are two passwords - the TDP for Oracle password set at the dsmc prompt (dsmc -se=<TDP_Server_name>) and the TDPO password set at tdpoconf password.
To check if these are OK, login with dsmc -se=<TDP_Server_name> and if the password is OK, you will not be prompted.
The TDPO side should be checked by your DBA team. If they engage RMAN manually, they would know if the password has expired.
But, ask first if there has been any other changes before chasing after paswords.
------------------
/var/opt/tivoli/tsm/log/dsmerror.log
[oracle@hlthrecdevdb bin64]$ cat /opt/tivoli/tsm/client/ba/bin/dsm.sys
Servername TSM114G01
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.220.2.16
schedmode polling
*passwordaccess generate
schedlogname /var/opt/tivoli/tsm/log/dsmsched.log
schedlogretention 10
errorlogname /var/opt/tivoli/tsm/log/dsmerror.log
errorlogretention 10
inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl
nodename hlthrecdevdb
Domain ALL-LOCAL
[oracle@hlthrecdevdb bin64]$
[oracle@hlthrecdevdb bin64]$
/var/opt/tivoli/tsm/log/dsmerror.log [Sent]
/var/opt/tivoli/tsm/log/dsmsched.log
================================
1.) Are you trying to run two rman backup streams, i.e. allocating two
channels?. I know on some trial versions you can only allocate one channel.
2.) Is this Oracle 8 or Oracle 9? What o/s? 32 or 64 bit?
3.) If Oracle 8 please double check to see that the Oracle backup library
is still linked from $ORACLE_HOME/lib/libobk.so to /usr/lib/libobk.so to
/opt/tivoli/tsm/client/oracle/bin/libobk.so. I don't know why they'd be
unlinked, but just in case.
4.) Look at your rman script make sure it's pointing to the correct
tdpo.opt file.
5.) Also check the Unix file/modes permission's on the tdpo.opt files as
well as the permission's in the /opt/tivoli/tsm/client/oracle/bin directory
structure. (/usr/...*) if AIX.
6.) Check the nodename your using, see if the nodename in the dsm.opt file
for Oracle can authenticate into the tsm server: "dsmc q ses
-server=tdpo_server_stanza"
7.) Also check to see that the tdpo software can authenticate into the tsm
server: tdpoconf password
This is all assuming it's running on a Unix client system?
If you run through these suggestions and everything looks good. Let me know
and I'll try to help you further.
Thanks!
--Justin Richard Bleistein
Unix/TSM System Administrator
|---------+------------------------------>
| | "Slaughter, Bill" |
| | <BillSlaughter@TUPP|
| | ERWARE.COM> |
| | Sent by: "ADSM: |
| | Dist Stor Manager" |
| | <ADSM-L@VM.MARIST.E|
| | DU> |
| | |
| | |
| | 06/16/2004 03:22 PM|
| | Please respond to |
| | "ADSM: Dist Stor |
| | Manager" |
| | |
|---------+------------------------------>
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: ADSM-L AT VM.MARIST DOT EDU
|
| cc:
|
| Subject: TDPO Error message
|
>------------------------------------------------------------------------------------------------------------------------------|
We are trialing TDPO so I can't call in for support yet.
This was working and starting today we are having trouble.
We started getting the following message when using TDPO.
RMAN> crosscheck backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 06/16/2004 11:14:31
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux Error: 2517: Unknown system error
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 2517, sbtopen: system error
Does anybody know what could be going wrong?
Or
Where I can look up these messages.
I never see the client connecting to the server in the ACTLOG.
"tdpoconf Shoeenv" command returns the following:
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 2, Level 0.0
(C) Copyright IBM Corporation 1997, 2003. All rights reserved.
DATA PROTECTION FOR ORACLE INFORMATION
Version: 5
Release: 2
Level: 0
Sublevel: 0
Platform: 32bit TDPO Linux86
TSM SERVER INFORMATION
Server Name: TDPO
Server Address: UXAS02
Server Type: HP-UX
Server Port: 1500
Communication Method: TCP/IP
SESSION INFORMATION
Owner Name: oracle
Node Name: us1lxas160_rman
Node Type: TDPO Linux86
DSMI_DIR: /opt/tivoli/tsm/client/api/bin
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/oracle/bin/dsm.opt
TDPO_OPTFILE: /opt/tivoli/tsm/client/oracle/bin/tdpo.opt
Password Directory: /opt/tivoli/tsm/client/oracle/bin
Compression: FALSE
===============
******************RMAN BACKUP**************************************
SERVERNAME TSM114G01
COMMmethod TCPip
TCPPort 1500
* Address for BOOT TSM Server
TCPServeraddress 10.220.2.16
TCPBUFFSIZE 32
TCPWINDOWSIZE 64
NODENAME HLTHRECDEVDB_ORA
PASSWORDACCESS prompt
TXNBYTELIMIT 25600
SCHEDMODE PROMPTED
=====================================FINAL STEPS======================================================
TDP configuration
--------------------------
[root@hlthrecdevdb bin64]#
[root@hlthrecdevdb bin64]# dsmc q sess
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 7, Release 1, Level 0.0
Client date/time: 12/14/2015 15:03:07
(c) Copyright by IBM Corporation and other(s) 1990, 2013. All Rights Reserved.
Node Name: HLTHRECDEVDB
Session established with server TSM114G01: AIX-RS/6000
Server Version 5, Release 5, Level 2.0
Server date/time: 12/14/2015 14:56:02 Last access: 12/14/2015 13:29:08
TSM Server Connection Information
Home Server Name........: TSM114G01
Server Type.............: AIX-RS/6000
Archive Retain Protect..: "No"
Server Version..........: Ver. 5, Rel. 5, Lev. 2.0
Last Access Date........: 12/14/2015 13:29:08
Delete Backup Files.....: "Yes"
Delete Archive Files....: "Yes"
Deduplication...........: None
Node Name...............: HLTHRECDEVDB
User Name...............: root
Secondary Server Information
Not configured for failover
[root@hlthrecdevdb bin64]#
------------------
To check tivoli client version and TDP version
----------------------------------------------
[oracle@hlthrecdevdb ~]$ rpm -qa | grep TDP
TDP-Oracle-7.1.3-0.x86_64
TDP-Oracle.Utility-7.1.3-0.x86_64
[oracle@hlthrecdevdb ~]$ rpm -qa | grep TIV
TIVsm-BA-7.1.0-0.x86_64
TIVsm-API64-7.1.0-0.x86_64
[oracle@hlthrecdevdb ~]$ uname -a
Linux hlthrecdevdb 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
To check file system which are being backed up on TAP
-----------------------------------------------------
[oracle@hlthrecdevdb ~]$ dsmc q fi
ANS2036W Pruning functions cannot open one of the Tivoli Storage Manager prune files: /var/opt/tivoli/tsm/log/dsmprune30218.log. errno = 13, Permission denied
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 7, Release 1, Level 0.0
Client date/time: 12/14/2015 13:26:39
(c) Copyright by IBM Corporation and other(s) 1990, 2013. All Rights Reserved.
Node Name: HLTHRECDEVDB
Session established with server TSM114G01: AIX-RS/6000
Server Version 5, Release 5, Level 2.0
Server date/time: 12/14/2015 13:19:34 Last access: 12/14/2015 12:56:49
# Last Incr Date Type File Space Name
--------------------------------------------------------------------------------
1 12/13/2015 04:00:54 EXT4 /
2 12/13/2015 03:34:44 EXT4 /APP
3 12/13/2015 03:42:27 EXT4 /Data1
4 12/13/2015 03:42:27 EXT4 /Data2
5 12/13/2015 03:42:41 EXT4 /arch
6 12/13/2015 03:42:41 EXT4 /backup
7 12/13/2015 03:42:41 EXT4 /boot
8 12/13/2015 03:42:41 EXT4 /home
9 12/13/2015 03:42:44 EXT4 /opt
10 12/13/2015 03:43:00 EXT4 /opt/IBM/ITM
11 12/13/2015 03:43:00 EXT4 /opt/IMB
12 12/13/2015 03:43:16 EXT4 /opt/tivoli
13 12/13/2015 04:00:20 EXT4 /oracle
14 12/13/2015 04:00:46 EXT4 /redo1
15 12/13/2015 04:01:14 EXT4 /redo2
16 12/13/2015 04:01:21 EXT4 /temp
17 12/13/2015 04:01:31 EXT4 /trace
18 12/13/2015 04:04:01 EXT4 /usr
19 12/13/2015 04:04:57 EXT4 /var
20 12/13/2015 03:34:44 EXT4 /var/adm/perfmgr
[oracle@hlthrecdevdb ~]$
============oracle backup configuration=============
There are three most important files to configure RMAN TAP backup
dsm.sys and dsm.opt in /opt/tivoli/tsm/client/ba/bin location and tdpo.opt in /opt/tivoli/tsm/client/oracle/bin64
rwxrwxrwx 1 root root 869 Dec 14 12:28 dsm.sys
-rw-r--r-- 1 root root 189 Dec 14 12:29 dsmerror.log
-rwxrwxrwx 1 root root 0 Dec 14 12:29 dsm.opt
[root@hlthrecdevdb bin]# pwd
/opt/tivoli/tsm/client/ba/bin
[root@hlthrecdevdb bin]#
if file system backup is already running then add stanza for RMAN TAP backup as below
[root@hlthrecdevdb bin]# cat dsm.sys
Servername TSM114G01
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.220.2.16
schedmode polling
passwordaccess generate
schedlogname /var/opt/tivoli/tsm/log/dsmsched.log
schedlogretention 10
errorlogname /var/opt/tivoli/tsm/log/dsmerror.log
errorlogretention 10
inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl
nodename hlthrecdevdb
Domain ALL-LOCAL
******************RMAN BACKUP**************************************
SERVERNAME oracle
COMMmethod TCPip
TCPPort 1500
* Address for BOOT TSM Server
TCPServeraddress 10.220.2.16
TCPBUFFSIZE 32
TCPWINDOWSIZE 64
NODENAME HLTHRECDEVDB_ORA
PASSWORDACCESS prompt
TXNBYTELIMIT 25600
SCHEDMODE PROMPTED
lrwxrwxrwx 1 oracle dba 37 Dec 8 13:28 dsm.sys -> /opt/tivoli/tsm/client/ba/bin/dsm.sys
-rwxrwxrwx. 1 root root 721 Dec 9 12:14 tdpo.opt
-rwxrwxrwx 1 root root 739 Dec 14 12:31 dsm.opt
-rw-r--r--. 1 root root 48 Dec 14 12:40 TDPO.HLTHRECDEVDB_ORA
-rwxrwxrwx. 1 oracle dba 16220 Dec 14 12:47 tdpoerror.log
[root@hlthrecdevdb bin64]# cat tdpo.opt
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the LinuxAMD64 Data Protection for Oracle
*********************************************************************
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64
*TDPO_FS /adsmorc
TDPO_NODE HLTHRECDEVDB_ORA
TDPO_OWNER oracle
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64
*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1
*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4
[root@hlthrecdevdb bin64]# dsm.opt
-bash: dsm.opt: command not found
[root@hlthrecdevdb bin64]# cat dsm.opt
************************************************************************
* Tivoli Storage Manager *
* *
* Sample Client User Options file for UNIX (dsm.opt.smp) *
************************************************************************
* This file contains an option you can use to specify the TSM
* server to contact if more than one is defined in your client
* system options file (dsm.sys). Copy dsm.opt.smp to dsm.opt.
* If you enter a server name for the option below, remove the
* leading asterisk (*).
************************************************************************
SERVERNAME oracle
[root@hlthrecdevdb bin64]# pwd
/opt/tivoli/tsm/client/oracle/bin64
[root@hlthrecdevdb bin64]#
and make soft link for dsm.sys in /opt/tivoli/tsm/client/oracle/bin64 from oracle user and from root user in /opt/tivoli/tsm/client/api/bin64
lrwxrwxrwx 1 oracle dba 37 Dec 8 13:28 dsm.sys -> /opt/tivoli/tsm/client/ba/bin/dsm.sys
lrwxrwxrwx 1 root root 37 Dec 8 13:25 dsm.sys -> /opt/tivoli/tsm/client/ba/bin/dsm.sys
lrwxrwxrwx 1 root root 43 Dec 14 12:36 dsm.opt -> /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
[root@hlthrecdevdb bin64]# pwd
/opt/tivoli/tsm/client/api/bin64
[root@hlthrecdevdb bin64]#
[root@hlthrecdevdb bin]#
create link for libobk from oralce_home/lib
--------------------------------------------
[oracleg@oracleserver.domainname ~]$ ln -s /opt/tivoli/tsm/client/oracle/bin64/libobk.so $ORACLE_HOME/lib
[oracle@oracleserver.domainname ~]$ ll $ORACLE_HOME/lib/libobk.so
lrwxrwxrwx 1 oraracle dba 45 Jul 13 12:00 /oracle/software/lib/libobk.so -> /opt/tivoli/tsm/client/oracle/bin64/libobk.so
tdpoconf password -TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
[root@hlthrecdevdb bin64]#
[root@hlthrecdevdb bin64]# tdpoconf showenv
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015. All rights reserved.
Data Protection for Oracle Information
Version: 7
Release: 1
Level: 3
Sublevel: 0
Platform: 64bit TDPO Linux86-64
Tivoli Storage Manager Server Information
Server Name: ORACLE
Server Address: 10.220.2.16
Server Type: AIX-RS/6000
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name: oracle
Node Name: HLTHRECDEVDB_ORA
Node Type: TDPO Linux86-64
DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE: /opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /opt/tivoli/tsm/client/oracle/bin64
Compression: FALSE
License Information: License file exists and contains valid license data.
[root@hlthrecdevdb bin64]#
===============================
CATPROC - Packages and Types Invalid in Dba_registry
When i looked in to the DBA_REGISTRY, I found that the Oracle Database Packages and Types Column in the Table is in INVALID state.
I had this problem after my database has been upgraded from Oracle 10gR2 to 11gR2.
SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10)
comp_id,substr(version,1,12) version,status from dba_registry;
2
COMP_NAME COMP_ID VERSION STATUS
------------------------------ ---------- ------------ -----------
Oracle XML Database XDB 11.2.0.2.0 VALID
Oracle Expression Filter EXF 11.2.0.2.0 VALID
Oracle Rule Manager RUL 11.2.0.2.0 VALID
Oracle Workspace Manager OWM 11.2.0.2.0 VALID
Oracle Database Catalog Views CATALOG 11.2.0.2.0 VALID
Oracle Database Packages and T CATPROC 11.2.0.2.0 INVALID
JServer JAVA Virtual Machine JAVAVM 11.2.0.2.0 VALID
Oracle XDK XML 11.2.0.2.0 VALID
Oracle Database Java Packages CATJAVA 11.2.0.2.0 VALID
9 rows selected.
Causes:
The probable causes for dba_registry components became invalid could be any of the following.
· Applied a patch and after the patch application because of some dependent object status change registry can become invalid
· Installed a new component and the new component installation got failed then registry components could become invalid
· catalog.sql or catproc.sql was not successfully ran after database creation. Any of them would have failed somewhere or any of the dependent object got invalid afterward
You can try the below steps to validate if you don’t have any invalid object in the database
SQL> select count(*) from dba_objects where status=’INVALID’;
COUNT(*)
———-
0
SQL> exec DBMS_REGISTRY_SYS.VALIDATE_CATPROC;
If you have any invalid objects in the database then follow the below steps
SQL> SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
449
1 row selected.
'Packages and Types' can usually be validated by running catalog and catproc scripts:
$sqlplus "/as sysdba"
SQL> startup restrict
SQL > @?/rdbms/admin/catalog.sql
SQL > @?/rdbms/admin/catproc.sql
SQL > @?/rdbms/admin/utlrp.sql
SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10)
comp_id,substr(version,1,12) version,status from dba_registry;
2
COMP_NAME COMP_ID VERSION STATUS
---------------------------------------- ---------- ------------ -----------
Oracle XML Database XDB 11.2.0.2.0 VALID
Oracle Expression Filter EXF 11.2.0.2.0 VALID
Oracle Rule Manager RUL 11.2.0.2.0 VALID
Oracle Workspace Manager OWM 11.2.0.2.0 VALID
Oracle Database Catalog Views CATALOG 11.2.0.2.0 VALID
Oracle Database Packages and T CATPROC 11.2.0.2.0 VALID
JServer JAVA Virtual Machine JAVAVM 11.2.0.2.0 VALID
Oracle XDK XML 11.2.0.2.0 VALID
Oracle Database Java Packages CATJAVA 11.2.0.2.0 VALID
9 rows selected.
Shutdown your database in the normal mode and startup with the normal mode.
change number=CHG0072154
-------------------on local system-----------------
[shahique@oc5327222715 Desktop]$ xclock
Warning: Missing charsets in String to FontSet conversion
[shahique@oc5327222715 Desktop]$
[shahique@oc5327222715 Desktop]$ xhost +10.245.18.175
10.245.18.175 being added to access control list
[shahique@oc5327222715 Desktop]$
[shahique@oc5327222715 Desktop]$ ifconfig -a
eth0 Link encap:Ethernet HWaddr 28:D2:44:27:AA:A6
inet addr:9.120.210.43
---------------------------boots db system--------
export DISPLAY=9.120.210.59:1:0
oracle@hlthrecdevdb response]$ export DISPLAY=9.120.210.43:0.0
[oracle@hlthrecdevdb response]$
[oracle@hlthrecdevdb response]$
[oracle@hlthrecdevdb response]$ xclock
-bash: xclock: command not found
[oracle@hlthrecdevdb response]$ echo $SHELL
/bin/bash
[oracle@hlthrecdevdb response]$
[oracle@hlthrecdevdb response]$ id
uid=532(oracle) gid=503(dba) groups=503(dba),502(oinstall),504(oper) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@hlthrecdevdb response]$ cd ..
[oracle@hlthrecdevdb database]$ ls -ltr
total 36
-rwxr-xr-x. 1 oracle dba 500 Feb 6 2013 welcome.html
-rwxr-xr-x. 1 oracle dba 8533 Jul 7 2014 runInstaller
drwxr-xr-x. 2 oracle dba 4096 Jul 7 2014 rpm
drwxrwxr-x. 2 oracle dba 4096 Jul 7 2014 sshsetup
drwxr-xr-x. 14 oracle dba 4096 Jul 7 2014 stage
drwxr-xr-x. 4 oracle dba 4096 Jul 7 2014 install
drwxrwxr-x. 2 oracle dba 4096 Oct 15 15:07 response
[oracle@hlthrecdevdb database]$ ./runInstaller
Source location is incomplete. Make sure you have downloaded and extracted
all the relevant archives.
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$ xclock
-bash: xclock: command not found
Most issues with remote installations occur in steps 4, 5, and 6. Make sure you’ve properly enabled remote-client
access to your local X server (running on your home computer) via the xhost command. The xhost command must
be run on the local computer on which you want the graphical display presented. Using the + (plus sign) with the
remote hostname adds a host to the local access list. This enables the remote server to display an X window on the
local host. If you type the xhost command by itself (with no parameters), it displays all remote hosts that can display X
sessions on the local computer:
$ xhost
access control disabled, clients can connect from any host
Setting the DISPLAY OS variable on the remote server is also crucial. This allows you to log in to another host
remotely and display an X application back to your local computer. The DISPLAY variable must be set on the remote
database server, to contain information that points it to the local computer on which you want the graphical screen
displayed.
=============================
to install from GUI
X Window System software should be installed
Use the tar -tvf <tarfile_name> command to preview which directories and files are restored without
a
ctually restoring them.
Listed next is a powerful one-line combination of commands that allows you to bundle the Oracle files, copy
them to a remote server, and have them extracted remotely:
$ tar -cvf - <locDir> | ssh <remoteNode> "cd <remoteDir>; tar -xvf -"
For instance, the following command copies everything in the dev_1 directory to the remote ora03 server
/home/oracle directory:
$ tar -cvf - dev_1 | ssh ora03 "cd /home/oracle; tar -xvf -"
I now have my servers handed over to me so we can now commence installation, backup and monitoring of Oracle 12c as previously communicated. Server details for this install are:
Host Name HLTHRECDEVDB
IP Address 10.245.18.175
O/S RHEL 6
Update / Service Pack U3
Classification Test
Type (physical, virtual, flex) Virtual
Data Centre Name Boots D125
Project Name Health Records Development Servers
BS version 1.7
https://support.oracle.com/epmos/#Linuxx8664
5:45:09 PM: pprasanj@in.ibm.com - Prince Prasanjit Das/India/Contr/IBM: SR 3-11530037001
passwd oracle
yum install oracle-rdbms-server-12cR1-preinstall
chown oracle:oinstall oraInst.loc
# chmod 664 oraInst.loc
rpm –ivh
rpm -ivh binutils-2.17.50.0.6
rpm -qa binutils-2.17.50.0.6
grep SwapTotal /proc/meminfo
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# uname -m
x86_64
[root@hlthrecdevdb ~]# uname -a
Linux hlthrecdevdb 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
[root@hlthrecdevdb ~]# free
total used free shared buffers cached
Mem: 32881524 3642528 29238996 0 221728 2683896
-/+ buffers/cache: 736904 32144620
Swap: 10485752 0 10485752
[root@hlthrecdevdb ~]# grep SwapTotal /proc/meminfo
SwapTotal: 10485752 kB
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# grep MemTotal /proc/meminfo
MemTotal: 32881524 kB
[root@hlthrecdevdb ~]#
# chown -R oracle:dba /u01
chown -R oracle:dba /oracle
# chown -R oracle:dba /u02
chown -R oracle:dba /Data1
chown -R oracle:dba /Data2
chown -R oracle:dba /arch
chown -R oracle:dba /backup
chown -R oracle:dba /oracle
chown -R oracle:dba /redo1
chown -R oracle:dba /redo2
chown -R oracle:dba /trace
chown -R oracle:dba /temp
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/vg-root 5160576 387748 4510684 8% /
tmpfs 16440760 0 16440760 0% /dev/shm
/dev/mapper/App_vg-App_lv 103208224 192116 97773436 1% /APP
/dev/mapper/oracle_vg-oracle_lv2 25803068 176064 24316284 1% /Data1
/dev/mapper/oracle_vg-oracle_lv3 25803068 176064 24316284 1% /Data2
/dev/mapper/oracle_vg-oracle_lv6 41284928 180104 39007672 1% /arch
/dev/mapper/oracle_vg-oracle_lv9 41284928 180104 39007672 1% /backup
/dev/sda1 516040 43680 446148 9% /boot
/dev/mapper/vg-home 6192704 144016 5734116 3% /home
/dev/mapper/vg-opt 8773016 249316 8078056 3% /opt
/dev/mapper/vg-ITM 4128448 379480 3539256 10% /opt/IBM/ITM
/dev/mapper/vg-IMB 4128448 139256 3779480 4% /opt/IMB
/dev/mapper/vg-tivoli 4128448 500760 3417976 13% /opt/tivoli
/dev/mapper/oracle_vg-oracle_lv1 41284928 180104 39007672 1% /oracle
/dev/mapper/oracle_vg-oracle_lv4 4128448 139256 3779480 4% /redo1
/dev/mapper/oracle_vg-oracle_lv5 4128448 139256 3779480 4% /redo2
/dev/mapper/oracle_vg-oracle_lv7 20642428 176064 19417788 1% /temp
/dev/mapper/vg-tmp 6192704 1823248 4054884 32% /tmp
/dev/mapper/oracle_vg-oracle_lv8 10321208 154100 9642820 2% /trace
/dev/mapper/vg-usr 6192704 1718144 4159988 30% /usr
/dev/mapper/vg-var 4128448 283856 3634880 8% /var
/dev/mapper/vg-perfmgr 2064208 68608 1890744 4% /var/adm/perfmgr
/dev/mapper/vg-software 10321208 6798440 2998480 70% /software
[root@hlthrecdevdb ~]#
cat /etc/group
wbpriv:x:88:
oinstall:x:502:
dba:x:503:oracle
[root@hlthrecdevdb ~]#
# groupadd oinstall
# groupadd dba
# groupadd oper
useradd -g oinstall -G dba oracle
useradd -u 502 -g oinstall -G dba,oper oracle
/usr/sbin/usermod -g dba -G oinstall,oper oracle
cat /etc/passwd
oracle:x:532:503::/home/oracle:/bin/bash
[root@hlthrecdevdb ~]#
If you need to modify a group, as root, use the groupmod command. If, for any reason, you need to remove a
group (as root) use the groupdel command
=======================
[root@hlthrecdevdb ~]# find / -name X11
/etc/X11
/usr/share/X11
/usr/lib64/X11
/usr/include/X11
[root@hlthrecdevdb ~]# cat /proc/version
Linux version 2.6.32-279.el6.x86_64 (mockbuild@x86-008.build.bos.redhat.com) (gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) ) #1 SMP Wed Jun 13 18:24:36 EDT 2012
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# repoquery -q -l xorg-x11-apps.x86_64 | grep xclock
Repository 'rhel-63-repo' is missing name in configuration, using id
Traceback (most recent call last):
File "/usr/bin/repoquery", line 1241, in <module>
main(sys.argv)
File "/usr/bin/repoquery", line 1235, in main
repoq.runQuery(regexs)
File "/usr/bin/repoquery", line 840, in runQuery
out = pkg.doQuery(oper)
File "/usr/bin/repoquery", line 197, in doQuery
return getattr(self, "fmt_%s" % method)(*args, **kw)
File "/usr/bin/repoquery", line 245, in fmt_list
return "\n".join(self.files())
File "/usr/bin/repoquery", line 498, in files
for ftype in self.pkg.returnFileTypes():
File "/usr/lib/python2.6/site-packages/yum/sqlitesack.py", line 372, in returnFileTypes
self._loadFiles()
File "/usr/lib/python2.6/site-packages/yum/sqlitesack.py", line 294, in _loadFiles
self.sack.populate(self.repo, mdtype='filelists')
File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 184, in populate
xml = repo_get_function()
File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 1634, in getFileListsXML
return self.retrieveMD('filelists')
File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 1552, in retrieveMD
return self._retrieveMD(mdtype)
File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 1608, in _retrieveMD
size=thisdata.size)
File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 835, in _getFile
raise Errors.NoMoreMirrorsRepoError, errstr
yum.Errors.NoMoreMirrorsRepoError: failure: repodata/filelists.xml.gz from yum_rpmsEL6-x86_64_level4: [Errno 256] No more mirrors to try.
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# repoquery -q -f */xclock
Repository 'rhel-63-repo' is missing name in configuration, using id
No package provides */xclock
[root@hlthrecdevdb ~]#
yum search xclock
1) log into console as root and open a terminal window within CDE
2) DISPLAY=:0.0
3) export DISPLAY
4) xhost +
5) su - oracle
6) DISPLAY=:0.0
7) export DISPLAY
8) /user/openwin/bin/xclock <launched xclock this way to ensure it was working, and it was>
9) changed back to the directory where the runInstaller was and launched.
============================
rpm -q gcc-4.4.4-13.el6*
Packages for Oracle Linux 6
and Red Hat Enterprise Linux
6
Oracle Linux 6 with the Unbreakable Enterprise kernel:
2.6.39-200.24.1.el6uek.x86_64 or later
Red Hat Enterprise Linux 6: 2.6.32-71.el6.x86_64 or later
The following packages (or later versions) must be installed:
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (i686)
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (i686)
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (i686)
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6 (i686)
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6 (i686)
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (i686)
libXext-1.1 (x86_64)
libXext-1.1 (i686)
libXtst-1.0.99.2 (x86_64)
libXtst-1.0.99.2 (i686)
libX11-1.3 (x86_64)
libX11-1.3 (i686)
libXau-1.0.5 (x86_64)
libXau-1.0.5 (i686)
libxcb-1.5 (x86_64)
libxcb-1.5 (i686)
libXi-1.3 (x86_64)
libXi-1.3 (i686)
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
rpm -q binutils compat-libstdc++ gcc glibc libaio libgcc libstdc++ \
make sysstat unixodbc
[root@hlthrecdevdb ~]# grep dba /etc/group
dba:x:503:oracle
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep sem
kernel.sem = 250 32000 32 128
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]#
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep shm
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.shm_rmid_forced = 0
vm.hugetlb_shm_group = 0
[root@hlthrecdevdb ~]# 536870912
-bash: 536870912: command not found
[root@hlthrecdevdb ~]#
# /sbin/sysctl -a | grep sem
This command displays the value of the semaphore parameters in the order listed.
shmall, shmmax, and shmmni # /sbin/sysctl -a | grep shm
file-max #
ip_local_port_range # /sbin/sysctl -a | grep ip_local_port_range
rmem_default # /sbin/sysctl -a | grep rmem_default
rmem_max # /sbin/sysctl -a | grep rmem_max
wmem_default # /sbin/sysctl -a | grep wmem_default
wmem_max # /sbin/sysctl -a | grep wmem_max
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep ip_local_port_range
net.ipv4.ip_local_port_range = 32768 61000
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep rmem_default
net.core.rmem_default = 229376
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep rmem_max
net.core.rmem_max = 131071
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep wmem_default
net.core.wmem_default = 229376
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep wmem_max
net.core.wmem_max = 131071
[root@hlthrecdevdb ~]#
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
kernel.shmall = 2097152
kernel.shmmax = 536870912
=================
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep sem
kernel.sem = 250 32000 100 128
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep file-max
fs.file-max = 6815744
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep ip_local_port_range
net.ipv4.ip_local_port_range = 9000 65500
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep rmem_default
net.core.rmem_default = 262144
[root@hlthrecdevdb ~]# /sbin/sysctl -a | grep rmem_max
net.core.rmem_max = 4194304
[root@hlthrecdevdb ~]# ulimit -Sn
1024
[root@hlthrecdevdb ~]# ulimit -Hn
4096
[root@hlthrecdevdb ~]# ulimit -Su
256734
[root@hlthrecdevdb ~]# ulimit -Hu
256734
[root@hlthrecdevdb ~]#
==============
ulimit -Hn
==========
[oracle@hlthrecdevdb ~]$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 256734
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1024
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[oracle@hlthrecdevdb ~]$ ulimit -Hn
4096
[oracle@hlthrecdevdb ~]$
recommend
$ ulimit -Hn
65536 To change this limit, edit the /etc/security/limits.conf file as root and make the following changes or add the following lines, respectively:
oracle soft nofile 4096
oracle hard nofile 63536
-----------
=================installation==============
Step 5: Creating oraInst.loc File
If an oraInst.loc file already exists on your server, then you can skip this step. Creating the oraInst.loc file only
needs to be performed the first time you install binaries on a server, using the silent install method. If you’re using the
OUI graphical installer, then the oraInst.loc file is created automatically for you.
On Linux servers the oraInst.loc file is usually located in the /etc directory. On other Unix systems (such as
Solaris) this file is located in the /var/opt/oracle directory. The oraInst.loc file contains the following information:
• Oracle inventory directory path
• Name of OS group that has permissions for installing and upgrading Oracle software
The Oracle inventory directory path is the location of files associated with managing Oracle installations and
upgrades. Typically, there is one Oracle inventory per host. Within this directory structure is the inventory.xml file,
which contains a record of where various versions of Oracle have been installed on the server.
The Oracle inventory OS group has the OS permissions required for installing and upgrading Oracle software.
Oracle recommends that you name this group oinstall. You’ll find that sometimes DBAs assign the inventory group
to the dba group. If your environment doesn’t require a separate group (such as oinstall), then using the dba group
is fine.
You can create the oraInst.loc file with a utility such as vi. Here are some sample entries in the file:
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
As root, ensure that the response file is owned by the oracle OS user and that it has the proper file
access privileges:
# chown oracle:oinstall oraInst.loc
# chmod 664 oraInst.loc
9
Chapter 1 ■ Installing the Oracle Binaries
./runInstaller -ignoreSysPrereqs -force -silent -responseFile \
/oracle/oracle_software/database/response/db_install_new.rsp
or
./runInstaller -ignoreSysPrereqs -force -silent -responseFile \
/oracle/oracle_software/database/response/db_install_new.rsp
./runInstaller -ignoreSysPrereqs -force -silent -responseFile /oracle/oracle_software/database/response/db_install_new.rsp
If you encounter errors with the installation process, you can view the associated log file. Each time you attempt
to run the installer, it creates a log file with a unique name that includes a timestamp. The log file is located in the
oraInventory/logs directory. You can stream the output to your screen as the OUI writes to it:
$ tail -f <logfile name>
Here is an example of a log file name:
installActions2012-04-33 11-42-52AM.log
If everything runs successfully, in the output you’re notified that you need to run the root.sh script as the
root user:
#Root scripts to run
/oracle/app/oracle/product/11.2.0/db_1/root.sh
==========
[oracle@hlthrecdevdb database]$ java -version
java version "1.6.0_33"
OpenJDK Runtime Environment (IcedTea6 1.13.5) (rhel-1.13.5.0.el6_6-x86_64)
OpenJDK 64-Bit Server VM (build 23.25-b01, mixed mode)
[oracle@hlthrecdevdb database]$
Check if some JDK is installed in your system:
$ java -version
Installing JDK 7 solved my problem:
$ sudo apt-get install openjdk-7-jre-headless
If the problem persists, log as root, then execute:
$ xhost +
============
You can create the oraInst.loc file with a utility such as vi. Here are some sample entries in the file:
inventory_loc=/oracle/oraInventory
inst_group=oinstall
vi oraInst.loc
# chown oracle:oinstall oraInst.loc
# chmod 664 oraInst.loc
=================================
rwxr-xr-x. 14 oracle dba 4096 Jul 7 2014 stage
drwxr-xr-x. 4 oracle dba 4096 Oct 16 11:59 install
drwxrwxr-x. 2 oracle dba 4096 Oct 26 15:42 response
[oracle@hlthrecdevdb database]$ ./runInstaller -ignoreSysPrereqs -force -silent
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 3145 MB Passed
Checking swap space: must be greater than 150 MB. Actual 10239 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-10-26_03 mandatory requirements.
CAUSE: Some of the mandatory prerequisites are not met. See logs for details.
ACTION: Identify the list of failed prerequisite checks from the log: /oracle ion manual find the appropriate configuration to meet the prerequisites and fix
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$
[oracle@hlthrecdevdb database]$ ./runInstaller -ignoreSysPrereqs -force -silent -responseFile /oracle/oracle_software/database/response/db_install_new.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 3136 MB Passed
Checking swap space: must be greater than 150 MB. Actual 10239 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-10-26_03-46-01PM. Please wait ...[oracle@hlthrecdevdb database]$ [FATAL] [INS-13013] Target environment does not meet some mandatory requirements.
CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /oracle/product/oraInventory/logs/installActions2015-10-26_03-46-01PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /oracle/product/oraInventory/logs/installActions2015-10-26_03-46-01PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
=====================
INFO: *********************************************
INFO: Hard Limit: maximum open file descriptors: This is a prerequisite condition to test whether the hard limit for "maximum open file descriptors" is set correctly.
INFO: Severity:CRITICAL
INFO: OverallStatus:VERIFICATION_FAILED
INFO: -----------------------------------------------
INFO: Verification Result for Node:hlthrecdevdb
INFO: Expected Value:65536
INFO: Actual Value:63536
INFO: Error Message:PRVF-4354 : Proper hard limit for resource "maximum open file descriptors" not found on node "hlthrecdevdb" [Expected = "65536" ; Found = "63536"]
INFO: Cause: Hard limit for the resource does not meet the requirement on the specified node.
INFO: Action: Modify the resource limits to meet the requiremen
INFO: *********************************************
INFO: Soft Limit: maximum user processes: This is a prerequisite condition to test whether the soft limit for "maximum user processes" is set correctly.
INFO: Severity:IGNORABLE
INFO: OverallStatus:VERIFICATION_FAILED
INFO: ------------------------------------
INFO: Verification Result for Node:hlthrecdevdb
INFO: Expected Value:2047
INFO: Actual Value:1024
INFO: Error Message:PRVF-4353 : Proper soft limit for resource "maximum user processes" not found on node "hlthrecdevdb" [Expected = "2047" ; Found = "1024"]
INFO: Cause: Soft limit for the resource does not meet the requirement on the specified node.
INFO: Action: Modify the resource limits to meet the requirement.
INFO: Severity:IGNORABLE
INFO: OverallStatus:VERIFICATION_FAILED
INFO: -----------------------------------------------
INFO: Verification Result for Node:hlthrecdevdb
INFO: Expected Value:16GB (1.6777216E7KB)
INFO: Actual Value:10GB (1.0485752E7KB)
INFO: Error Message:PRVF-7573 : Sufficient swap size is not available on node "hlthrecdevdb" [Required = 16GB (1.6777216E7KB) ; Found = 10GB (1.0485752E7KB)]
INFO: Cause: The swap size found does not meet the minimum requirement.
INFO: Action: Increase swap size to at least meet the minimum swap space requirement
/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
=========================
total 36
-rwxr-xr-x. 1 oracle dba 500 Feb 6 2013 welcome.html
-rwxr-xr-x. 1 oracle dba 8533 Jul 7 2014 runInstaller
drwxr-xr-x. 2 oracle dba 4096 Jul 7 2014 rpm
drwxrwxr-x. 2 oracle dba 4096 Jul 7 2014 sshsetup
drwxr-xr-x. 14 oracle dba 4096 Jul 7 2014 stage
drwxr-xr-x. 4 oracle dba 4096 Oct 16 11:59 install
drwxrwxr-x. 2 oracle dba 4096 Oct 26 15:42 response
[oracle@hlthrecdevdb database]$ ./runInstaller -ignoreSysPrereqs -force -silent -responseFile /oracle/oracle_software/database/response/db_install_new.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 3136 MB Passed
Checking swap space: must be greater than 150 MB. Actual 10239 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-10-26_04-14-38PM. Please wait ...[oracle@hlthrecdevdb database]$ [WARNING] [INS-13014] Target environment does not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
You can find the log of this install session at:
/oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log
The installation of Oracle Database 12c was successful.
Please check '/oracle/product/oraInventory/logs/silentInstall2015-10-26_04-14-38PM.log' for more details.
As a root user, execute the following script(s):
1. /oracle/product/12.1.0.2/root.sh
Successfully Setup Software.
[root@hlthrecdevdb ~]# /oracle/product/12.1.0.2/root.sh
Check /oracle/product/12.1.0.2/install/root_hlthrecdevdb_2015-10-26_16-27-52.log for the output of root script
[root@hlthrecdevdb ~]#
Checking Temp space: must be greater than 500 MB. Actual 3136 MB Passed
Checking swap space: must be greater than 150 MB. Actual 10239 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-10-26_04-14-38PM. Please wait ...[oracle@hlthrecdevdb database]$ [WARNING] [INS-13014] Target environment does not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
You can find the log of this install session at:
/oracle/product/oraInventory/logs/installActions2015-10-26_04-14-38PM.log
=================Database creation=============
"/Data1/oradata/","/Data2/oradata/"
oracle@hlthrecdevdb Data1]$ cd oradata
[oracle@hlthrecdevdb oradata]$ ls -ltr
total 0
[oracle@hlthrecdevdb oradata]$ pwd
/Data1/oradata
[oracle@hlthrecdevdb oradata]$
[oracle@hlthrecdevdb oradata]$
[oracle@hlthrecdevdb oradata]$ cd /Data2
[oracle@hlthrecdevdb Data2]$ cd ^C
[oracle@hlthrecdevdb Data2]$
[oracle@hlthrecdevdb Data2]$ ls -ltr
total 20
drwx------. 2 oracle dba 16384 Oct 6 12:54 lost+found
drwxr-xr-x. 2 oracle dba 4096 Oct 15 13:27 oradata
[oracle@hlthrecdevdb Data2]$
[oracle@hlthrecdevdb oradata]$
[oracle@hlthrecdevdb oradata]$
[oracle@hlthrecdevdb oradata]$ cd /Data2
[oracle@hlthrecdevdb Data2]$ cd ^C
[oracle@hlthrecdevdb Data2]$
[oracle@hlthrecdevdb Data2]$ ls -ltr
total 20
drwx------. 2 oracle dba 16384 Oct 6 12:54 lost+found
drwxr-xr-x. 2 oracle dba 4096 Oct 15 13:27 oradata
[oracle@hlthrecdevdb Data2]$ cd /redo1
[oracle@hlthrecdevdb redo1]$ ls -ltr
total 20
drwx------. 2 oracle dba 16384 Oct 6 12:54 lost+found
drwxr-xr-x. 2 oracle dba 4096 Oct 15 13:28 oradata
[oracle@hlthrecdevdb redo1]$ cd /redo2
[oracle@hlthrecdevdb redo2]$
[oracle@hlthrecdevdb redo2]$ cd oradata
[oracle@hlthrecdevdb oradata]$ cd /temp
[oracle@hlthrecdevdb temp]$ cd oradata
[oracle@hlthrecdevdb oradata]$ cd /trace/oradata
[oracle@hlthrecdevdb oradata]$
Shahique - as below, database to be called "orionhealth" please.
Regards
Rob
===================
• ORACLE_HOME
• ORACLE_SID
• LD_LIBRARY_PATH
• PATH
$
$
$
export
export
export
export
export ORACLE_HOME=/oracle/product/12.1.0.2/
export ORACLE_SID=orionhealth
export LD_LIBRARY_PATH=/usr/lib:$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
orionhealth:/oracle/product/12.1.0.2:N
dbca -silent -responseFile /home/oracle/orainst/mydb.rsp
./dbca -silent -responseFile /oracle/oracle_software/database/response/dbca_new1.rsp
AL16UTF16
NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET WE8MSWIN1252
NLS_COMP BINARY
NLS_CURRENCY ú
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE ENGLISH
NLS_DUAL_CURRENCY Ç
NLS_ISO_CURRENCY UNITED KINGDOM
NLS_LANGUAGE ENGLISH
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CHARACTERSET AL16UTF16
dbca_new1.rsp
Bootoracle@123---pass -sys
==============================
[oracle@hlthrecdevdb bin]$ ./dbca -silent -responseFile /oracle/oracle_software/database/response/dbca_new1.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
37% complete
Creating and starting Oracle instance
DBCA Operation failed.
Look at the log file "/oracle/product/cfgtoollogs/dbca/orionhealth/orionhea.log" for further details.
[oracle@hlthrecdevdb bin]$
[oracle@hlthrecdevdb response]$ more /oracle/product/cfgtoollogs/dbca/orionhealth/orionhea.log
Unique database identifier check passed.
/oracle/ has enough space. Required space is 4560 MB , available space is 27407 MB.
/Data1/ has enough space. Required space is 1580 MB , available space is 23746 MB.
File Validations Successful.
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 11%
DBCA_PROGRESS : 18%
DBCA_PROGRESS : 37%
Creating and starting Oracle instance
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/Data1/oradata/'
ORA-27056: could not delete file
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/Data1/oradata/'
ORA-27056: could not delete file
DBCA_PROGRESS : DBCA Operation failed.
[oracle@hlthrecdevdb response]$
[oracle@hlthrecdevdb bin]$ ./dbca -silent -responseFile /oracle/oracle_software/database/response/dbca_new1.rsp
Cleaning up failed steps
5% complete
Copying database files
7% complete
9% complete
16% complete
23% complete
30% complete
41% complete
Creating and starting Oracle instance
43% complete
48% complete
53% complete
58% complete
59% complete
62% complete
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
96% complete
100% complete
Look at the log file "/oracle/product/cfgtoollogs/dbca/orionhealth/orionhea0.log" for further details.
[oracle@hlthrecdevdb bin]$
netca -silent -responsefile /oracle/oracle_software/database/response/netca_new.rsp
orionhealth =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = hlthrecdevdb)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = orionhealth)
)
)
SQL>
SQL> set linesize 200
SQL>
SQL> SQL>
SQL>
SELECT member FROM v$logfile
UNION ALL
SELECT name FROM v$datafile
UNION ALL
SELECT name FROM v$controlfile
union all
select file_name from dba_temp_filesSQL> 2 3 4 5 6 7
8 ;
MEMBER
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/Data1/oradata/orionhealth/redo03.log
/Data1/oradata/orionhealth/redo02.log
/Data1/oradata/orionhealth/redo01.log
/Data1/oradata/orionhealth/system01.dbf
/Data1/oradata/orionhealth/sysaux01.dbf
/Data1/oradata/orionhealth/undotbs01.dbf
/Data1/oradata/orionhealth/users01.dbf
/Data1/oradata/orionhealth/control01.ctl
/oracle/product/fast_recovery_area/orionhealth/control02.ctl
/Data1/oradata/orionhealth/temp01.dbf
10 rows selected.
SQL>
=to change path for temp file========
SELECT file_id, file_name FROM dba_temp_files;
Alter database tempfile '/Data1/oradata/orionhealth/temp01.dbf' offline;
mv /Data1/oradata/orionhealth/temp01.dbf /temp/oradata/orionhealth/temp01.dbf
Alter database rename file '/Data1/oradata/orionhealth/temp01.dbf' to '/temp/oradata/orionhealth/temp01.dbf';
SELECT file_id, file_name,status FROM dba_temp_files;
Alter database tempfile '/temp/oradata/orionhealth/temp01.dbf' online;
SELECT file_id, file_name,status FROM dba_temp_files;
================to change redo log============
SQL> column member format a55
SQL> select group#, member from v$logfile
2 ;
GROUP# MEMBER
---------- -------------------------------------------------------
3 /Data1/oradata/orionhealth/redo03.log
2 /Data1/oradata/orionhealth/redo02.log
1 /Data1/oradata/orionhealth/redo01.log
SQL>
SQL> SELECT * FROM V$LOG;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
1 1 7 52428800 512 3 NO CURRENT 1612504 27-OCT-15 2.8147E+14 0
2 1 5 52428800 512 3 NO INACTIVE 1612472 27-OCT-15 1612501 27-OCT-15 0
3 1 6 52428800 512 3 NO INACTIVE 1612501 27-OCT-15 1612504 27-OCT-15 0
ALTER DATABASE ADD LOGFILE MEMBER '/redo2/oradata/orionhealth/redo03B.log' TO GROUP 3;
ALTER DATABASE ADD LOGFILE MEMBER '/redo2/oradata/orionhealth/redo02B.log' TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER '/redo2/oradata/orionhealth/redo01B.log' TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER '/redo1/oradata/orionhealth/redo03A.log' TO GROUP 3;
ALTER DATABASE ADD LOGFILE MEMBER '/redo1/oradata/orionhealth/redo02A.log' TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER '/redo1/oradata/orionhealth/redo01A.log' TO GROUP 1;
switch log file and make sure log file is not current
alter system switch logfile;
alter database drop logfile member '/Data1/oradata/orionhealth/redo03.log';
alter database drop logfile member '/Data1/oradata/orionhealth/redo02.log';
alter database drop logfile member '/Data1/oradata/orionhealth/redo01.log';
rm /Data1/oradata/orionhealth/redo01.log
rm /Data1/oradata/orionhealth/redo02.log
rm /Data1/oradata/orionhealth/redo03.log
'
ls -ltr /Data1/oradata/orionhealth/redo01.log
ls -ltr /Data1/oradata/orionhealth/redo02.log
ls -ltr /Data1/oradata/orionhealth/redo03.log
column member format a55
select group#, member from v$logfile
SELECT * FROM V$LOG;
=============
orionDB
/oracle/product/diag/rdbms/oriondb/orionDB/trace
SQL> select value from v$diag_info where name='Diag Trace';
VALUE
--------------------------------------------------------------------------------
/oracle/product/diag/rdbms/oriondb/orionDB/trace
SQL> SQL>
SQL> show parameter control_files
======Identifying DBA-Created Accounts============
SQL> ;
1 select distinct u.username
2 ,case when d.user_name is null then 'DBA created account'
3 else 'Oracle created account'
4 end
5 from dba_users
6 u
7 ,default_pwd$ d
8* where u.username=d.user_name(+)
SQL>
SQL> /
USERNAME CASEWHEND.USER_NAMEISN
-------------------------------------------------------------------------------------------------------------------------------- ----------------------
SYSKM Oracle created account
SPATIAL_CSW_ADMIN_USR Oracle created account
ORDDATA Oracle created account
GSMADMIN_INTERNAL Oracle created account
SPATIAL_WFS_ADMIN_USR Oracle created account
APPQOSSYS Oracle created account
AUDSYS Oracle created account
LBACSYS Oracle created account
SYS Oracle created account
APEX_040200 Oracle created account
DVSYS Oracle created account
USERNAME CASEWHEND.USER_NAMEISN
-------------------------------------------------------------------------------------------------------------------------------- ----------------------
MDDATA Oracle created account
ORDSYS Oracle created account
DVF Oracle created account
SI_INFORMTN_SCHEMA Oracle created account
ANONYMOUS Oracle created account
XS$NULL Oracle created account
FLOWS_FILES Oracle created account
GSMUSER Oracle created account
ORDPLUGINS Oracle created account
XDB Oracle created account
SYSDG Oracle created account
USERNAME CASEWHEND.USER_NAMEISN
-------------------------------------------------------------------------------------------------------------------------------- ----------------------
OUTLN Oracle created account
CTXSYS Oracle created account
WMSYS Oracle created account
OLAPSYS Oracle created account
GSMCATUSER Oracle created account
OJVMSYS Oracle created account
SYSTEM Oracle created account
SCOTT Oracle created account
DIP Oracle created account
SYSBACKUP Oracle created account
DBSNMP Oracle created account
USERNAME CASEWHEND.USER_NAMEISN
-------------------------------------------------------------------------------------------------------------------------------- ----------------------
MDSYS Oracle created account
ORACLE_OCM Oracle created account
APEX_PUBLIC_USER Oracle created account
36 rows selected.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /Data1/oradata/orionDB/control
01.ctl, /oracle/product/fast_r
ecovery_area/orionDB/control02
.ctl
SQL>
select value from v$diag_info where name = 'Diag Trace';
SQL> ALTER SYSTEM SET diagnostic_dest='/u01/app/oracle';
alter system set audit_file_dest ='/trace/oradata/orionDB/adump' scope=spfile
System altered.
alter system set user_dump_dest ='/trace/oradata/orionDB/' scope=spfile
QL>
SQL> show parameter dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /oracle/product/12.1.0.2/rdbms
/log
core_dump_dest string /trace/oradata/orionDB/diag/rd
bms/oriondb/orionDB/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /oracle/product/12.1.0.2/rdbms
/log
SQL>
unified_audit_sga_queue_size integer 1048576
use_dedicated_broker boolean FALSE
use_indirect_data_buffers boolean FALSE
use_large_pages string TRUE
user_dump_dest string /oracle/product/12.1.0.2/rdbms
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
/log
utl_file_dir string
workarea_size_policy string AUTO
xml_db_events string enable
SQL>
SQL> !ls -ltr /oracle/product/12.1.0.2/rdbms
total 108
drwxr-xr-x. 3 oracle dba 4096 Oct 26 16:14 utl
drwxr-xr-x. 5 oracle dba 4096 Oct 26 16:14 xml
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:15 mesg
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:15 public
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:15 jlib
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:16 doc
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:16 demo
drwxr-xr-x. 2 oracle dba 65536 Oct 26 16:16 admin
drwxr-xr-x. 2 oracle dba 4096 Oct 26 16:16 lib
drwxr-xr-x. 5 oracle dba 4096 Oct 26 16:16 install
drwxr-xr-x. 2 oracle dba 4096 Oct 28 09:21 audit
drwxr-xr-x. 2 oracle dba 4096 Oct 28 10:52 log
SQL>
========================control ===============
alter system set control_files='/redo1/oradata/orionDB/control01.ctl',
'/redo2/oradata/orionDB/control02.ctl' scope=spfile;
4:29:52 PM: pprasanj@in.ibm.com - Prince Prasanjit Das/India/Contr/IBM:
4:29:53 PM: pprasanj@in.ibm.com - Prince Prasanjit Das/India/Contr/IBM:
4:29:54 PM: pprasanj@in.ibm.com - Prince Prasanjit Das/India/Contr/IBM: shut immediate
cd /Data1/oradata/orionDB/
mv control01.ctl /redo1/oradata/orionDB/
cd /oracle/product/fast_recovery_area/orionDB/
mv control02.ctl / redo2/oradata/orionDB/
SQL> show parameter diagnostic_dest
===========================
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
cell_offload_processing boolean TRUE
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 1000
processor_group_name string
SQL> show parameter open_cursors
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 300
SQL> alter system set open_cursors=500
2 ;
System altered.
SQL>
========================================
Hi Arijit/Shahique
Mitra has created the TDP node as follows (thanks Mitra):-
The TSM node has been registered on the ORACLE domain as per the proforma. Please use the below details for configuring the backups.
TSM node Name: HLTHRECDEVDB_ORA
TCP server address: TSM114G01 IP address: 10.220.2.16
Password: HLTHRECDEVDB_ORA
Please can you now configure TDP SW on the DB server and liaise with Mitra when you are ready to schedule the backups and let me know when done plus update me as things progress so that I know it is happening.
Regards
Rob
========tdp configuration=================
./tdpoconf showenv
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015. All rights reserved.
Data Protection for Oracle Information
Version: 7
Release: 1
Level: 3
Sublevel: 0
Platform: 64bit TDPO Linux86-64
Tivoli Storage Manager Server Information
Server Name: HLTHRECDEVDB_ORA
Server Address: 10.220.2.16
Server Type: AIX-RS/6000
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name:
Node Name: HLTHRECDEVDB_ORA
Node Type: TDPO Linux86-64
DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE: /opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /opt/tivoli/tsm/client/oracle/bin64
Compression: FALSE
License Information: License file exists and contains valid license data.
[root@hlthrecdevdb bin64]# pij^C
[root@hlthrecdevdb bin64]# ping 10.220.2.16
PING 10.220.2.16 (10.220.2.16) 56(84) bytes of data.
64 bytes from 10.220.2.16: icmp_seq=1 ttl=252 time=0.304 ms
64 bytes from 10.220.2.16: icmp_seq=2 ttl=252 time=0.296 ms
64 bytes from 10.220.2.16: icmp_seq=3 ttl=252 time=0.319 ms
^C
--- 10.220.2.16 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2741ms
rtt min/avg/max/mdev = 0.296/0.306/0.319/0.017 ms
[root@hlthrecdevdb bin64]#
./tdpoconf SHOWENVironment
tdpoconf showenv -TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
[root@hlthrecdevdb bin64]# pwd
/opt/tivoli/tsm/client/oracle/bin64
[root@hlthrecdevdb bin64]#
[root@hlthrecdevdb bin64]# cat dsm.sys
************************************************************************
* Tivoli Storage Manager *
* *
* Sample Client System Options file for UNIX (dsm.sys.smp) *
************************************************************************
* This file contains the minimum options required to get started
* using TSM. Copy dsm.sys.smp to dsm.sys. In the dsm.sys file,
* enter the appropriate values for each option listed below and
* remove the leading asterisk (*) for each one.
* If your client node communicates with multiple TSM servers, be
* sure to add a stanza, beginning with the SERVERNAME option, for
* each additional server.
new
************************************************************************
SErvername TSM114G01
COMMMethod TCPip
TCPPort 1500
TCPServeraddres 10.220.2.16
[root@hlthrecdevdb bin64]# ping TSM114G01
ping: unknown host TSM114G01
[root@hlthrecdevdb bin64]# ping TSM114G01
ping: unknown host TSM114G01
[root@hlthrecdevdb bin64]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.245.18.175 hlthrecdevdb hlthrecdevdb.centre1.uk.boots.com
10.234.3.15 itmprtems01 itmprtems01.centre1.uk.boots.com
[root@hlthrecdevdb bin64]#
[oracle@hlthrecdevdb bin64]$ cat tdpo.opt.smp
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the LinuxAMD64 Data Protection for Oracle
*********************************************************************
*DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
*DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64
*TDPO_FS /adsmorc
*TDPO_NODE HLTHRECDEVDB_ORA
*TDPO_OWNER <username>
*TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64
*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1
*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4
[oracle@hlthrecdevdb bin64]$
pass for tivoli==oracleoriondb
[oracleg@oracleserver.domainname ~]$ ln -s /opt/tivoli/tsm/client/oracle/bin64/libobk.so $ORACLE_HOME/lib
[oracle@oracleserver.domainname ~]$ ll $ORACLE_HOME/lib/libobk.so
lrwxrwxrwx 1 oraracle dba 45 Jul 13 12:00 /oracle/software/lib/libobk.so -> /opt/tivoli/tsm/client/oracle/bin64/libobk.so
Then ensure dba Unix group (better to provide access to DBA group in case you have multiple Oracle accounts on your server) is able to write in all log files you defined in all TSM configuration files and be able to read tdpo.opt configuration file.
With Unix commands it gives something like:
[root@oracleserver.domainname /]# chmod a+r /opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
[root@oracleserver.domainname /]# chown root:dba /opt/tivoli/tsm/client/oracle/bin64/tdpoerror.log
[root@oracleserver.domainname /]# chmod g+rw /opt/tivoli/tsm/client/oracle/bin64/tdpoerror.log
[root@oracleserver.domainname /]# chown -R root:dba /var/log/tsm
[root@oracleserver.domainname /]# chmod g+rw /var/log/tsm
All errors I personally encountered were linked to missing rights on either log files (write permission) and read rights on configuration files. Don’t be too generous while giving those rights…
And that’s it ! You are done, you can test all is working with (even before starting RMAN):
[oracle@oracleserver.domainname admin]$ sbttest test
The sbt function pointers are loaded from libobk.so library.
-- sbtinit succeeded
Return code -1 from sbtinit, bsercoer = 0, bsercerrno = 0
Message 0 not found; product=RDBMS; facility=SBT
run{ allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ieo2blptsmp01_ora/tdpo.opt)'; }
run
{
allocate channel c1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup database;
release channel c1 ;
}
f
run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\Tivoli Storage Manager\AgentOBA64\tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\Tivoli Storage Manager\AgentOBA64\tdpo.opt)';
backup
filesperset 6
format 'df_%t_%s_%p'
(archivelog all
delete input);
release channel t1;
release channel t2;
}
ln -s /opt/tivoli/tsm/client/oracle/bin64/libobk.so libobk64.so
ln -s /usr/tivoli/tsm/client/oracle/bin64/libobk64.a $ORACLE_HOME/lib/libobk64.a
[oracle@hlthrecdevdb bin64]$ sbttest a -libname libobk.so
The sbt function pointers are loaded from libobk.so library.
Return code -1 from sbtinit, bsercoer = 7011, bsercerrno = 2507
sbtopen: System error - eg. malloc, fork errors
[oracle@hlthrecdevdb bin64]$ sbttest a -libname /opt/tivoli/tsm/client/oracle/bin64/libobk.so
The sbt function pointers are loaded from /opt/tivoli/tsm/client/oracle/bin64/libobk.so library.
Return code -1 from sbtinit, bsercoer = 7011, bsercerrno = 2507
sbtopen: System error - eg. malloc, fork errors
[oracle@hlthrecdevdb bin64]$ sbttest TOTO -dbname orionDB
The sbt function pointers are loaded from libobk.so library.
Return code -1 from sbtinit, bsercoer = 7011, bsercerrno = 2507
sbtopen: System error - eg. malloc, fork errors
[oracle@hlthrecdevdb bin64]$
RMAN> run { allocate channel ch1 type sbt PARMS="SBT_LIBRARY=/opt/tivoli/tsm/client/oracle/bin64/libobk.so";}
ldd /opt/tivoli/tsm/client/oracle/bin64/libobk.so
RMAN> connect target
connected to target database: ORIONDB (DBID=2986822836)
RMAN> run { allocate channel ch1 type sbt PARMS="SBT_LIBRARY=/opt/tivoli/tsm/client/oracle/bin64/libobk.so";}
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ch1 channel at 11/20/2015 15:23:19
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux-x86_64 Error: 2507: Unknown system error
Additional information: 7011
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
SBT error = 7011, errno = 2507, sbtopen: system error
RMAN> exit
Recovery Manager complete.
[oracle@hlthrecdevdb bin64]$ ldd /opt/tivoli/tsm/client/oracle/bin64/libobk.so
linux-vdso.so.1 => (0x00007fff2a9ff000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fe0ee24a000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007fe0edf43000)
libm.so.6 => /lib64/libm.so.6 (0x00007fe0edcbf000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fe0edaa9000)
libc.so.6 => /lib64/libc.so.6 (0x00007fe0ed714000)
/lib64/ld-linux-x86-64.so.2 (0x0000003522600000)
[oracle@hlthrecdevdb bin64]$
Technote (troubleshooting)
Problem(Abstract)
When the oracle database is loaded with svrctl for the cluster access, then the backup fails with:
ORA-27211: Failed to load Media Management Library
Additional information: 2
Symptom
Errors seen:
run
{
allocate channel t1 type sbt parms='ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup database;
}
using target database control file instead of recovery catalog
RMAN-00571: ===============================================
RMAN-00569: ======== ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571: ===============================================
RMAN-03009: failure of allocate command on t1 channel at 08/08/2014 08:51:48
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2
Cause
The environment for the running Oracle application needs to include the library path for the Data Protection libobk file.
Environment
Oracle 11gR2 RAC
Diagnosing the problem
If SQLPlus is used to start the database, then it will successfully load the library.
Also, if the database is set to stand-alone mode, the Data Protection for Oracle library can be loaded.
The problem to load the library is only seen when the Oracle grid software is used to startup the Oracle database in cluster mode.
Resolving the problem
The issue is that the Oracle grid needs to know the Library paths, such that it can search for and load the necessary library files from these related paths. As mentioned in the Oracle Metalink document 1439674.1, you would want to set the paths in the grid for example:
srvctl setenv database -d dbname -t "PATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib, LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib, LIBPATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib:/usr/lib/libobk.a, SHLIB_PATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib:/usr/lib/libobk.a"
Please note that it is necessary to bounce/restart the database via srvctl even though this extra step is not stated within the Metalink document.
This should allow the database to be started/controlled by the Oracle grid and allow the backups to work successfully with the Data Protection for Oracle library interface.
==============
11/20/15 15:07:35 TID<14013> ==> API Run Time Header Level = 7.1.0
11/20/15 15:07:35 TID<14013> ==> API Compile Time Header Level = 7.1.3
11/20/15 15:07:35 TID<14013> ==> ANU2507E Runtime API version is outdated
11/20/15 15:09:34 TID<14052> ==> API Run Time Header Level = 7.1.0
11/20/15 15:09:34 TID<14052> ==> API Compile Time Header Level = 7.1.3
11/20/15 15:09:34 TID<14052> ==> ANU2507E Runtime API version is outdated
12/07/15 14:32:04 TID<25331> ==> API Run Time Header Level = 7.1.0
12/07/15 14:32:04 TID<25331> ==> API Compile Time Header Level = 7.1.3
12/07/15 14:32:04 TID<25331> ==> ANU2507E Runtime API version is outdated
[root@hlthrecdevdb bin64]# pwd
/opt/tivoli/tsm/client/oracle/bin64
[root@hlthrecdevdb bin64]# date
Mon Dec 7 15:28:40 GMT 2015
[root@hlthrecdevdb bin64]#
run {
allocate channel t1 type disk;
backup current controlfile format '/backup/db_backup/rman/%d_%u_%s';
backup database format '/backup/db_backup/rman/%d_%u_%s';
backup archivelog all format '/backup/db_backup/rman/arch_%d_%u_%s';
release channel t1;
}
-----------
#ln -s /opt/tivoli/tsm/client/ba/bin/dsm.sys /opt/tivoli/tsm/client/api/bin64/dsm.sys
ln -s /opt/tivoli/tsm/client/ba/bin/dsm.sys /opt/tivoli/tsm/client/oracle/bin64/dsm.sys
tdpoconf password -TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
[root@hlthrecdevdb bin64]# tdpoconf password -TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015. All rights reserved.
***************************************************************
* IBM Tivoli Storage Manager for Databases Utility
* Password file initialization/update program
***************************************************************
Please enter current password:
Please enter new password:
Please reenter new password for verification:
ANU0260I Password successfully changed.
[root@hlthrecdevdb bin64]#
[root@hlthrecdevdb bin64]# \\
tivoli password==pass for tivoli==oracleoriondb_new1
===================================================
There are two passwords - the TDP for Oracle password set at the dsmc prompt (dsmc -se=<TDP_Server_name>) and the TDPO password set at tdpoconf password.
To check if these are OK, login with dsmc -se=<TDP_Server_name> and if the password is OK, you will not be prompted.
The TDPO side should be checked by your DBA team. If they engage RMAN manually, they would know if the password has expired.
But, ask first if there has been any other changes before chasing after paswords.
------------------
/var/opt/tivoli/tsm/log/dsmerror.log
[oracle@hlthrecdevdb bin64]$ cat /opt/tivoli/tsm/client/ba/bin/dsm.sys
Servername TSM114G01
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.220.2.16
schedmode polling
*passwordaccess generate
schedlogname /var/opt/tivoli/tsm/log/dsmsched.log
schedlogretention 10
errorlogname /var/opt/tivoli/tsm/log/dsmerror.log
errorlogretention 10
inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl
nodename hlthrecdevdb
Domain ALL-LOCAL
[oracle@hlthrecdevdb bin64]$
[oracle@hlthrecdevdb bin64]$
/var/opt/tivoli/tsm/log/dsmerror.log [Sent]
/var/opt/tivoli/tsm/log/dsmsched.log
================================
1.) Are you trying to run two rman backup streams, i.e. allocating two
channels?. I know on some trial versions you can only allocate one channel.
2.) Is this Oracle 8 or Oracle 9? What o/s? 32 or 64 bit?
3.) If Oracle 8 please double check to see that the Oracle backup library
is still linked from $ORACLE_HOME/lib/libobk.so to /usr/lib/libobk.so to
/opt/tivoli/tsm/client/oracle/bin/libobk.so. I don't know why they'd be
unlinked, but just in case.
4.) Look at your rman script make sure it's pointing to the correct
tdpo.opt file.
5.) Also check the Unix file/modes permission's on the tdpo.opt files as
well as the permission's in the /opt/tivoli/tsm/client/oracle/bin directory
structure. (/usr/...*) if AIX.
6.) Check the nodename your using, see if the nodename in the dsm.opt file
for Oracle can authenticate into the tsm server: "dsmc q ses
-server=tdpo_server_stanza"
7.) Also check to see that the tdpo software can authenticate into the tsm
server: tdpoconf password
This is all assuming it's running on a Unix client system?
If you run through these suggestions and everything looks good. Let me know
and I'll try to help you further.
Thanks!
--Justin Richard Bleistein
Unix/TSM System Administrator
|---------+------------------------------>
| | "Slaughter, Bill" |
| | <BillSlaughter@TUPP|
| | ERWARE.COM> |
| | Sent by: "ADSM: |
| | Dist Stor Manager" |
| | <ADSM-L@VM.MARIST.E|
| | DU> |
| | |
| | |
| | 06/16/2004 03:22 PM|
| | Please respond to |
| | "ADSM: Dist Stor |
| | Manager" |
| | |
|---------+------------------------------>
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: ADSM-L AT VM.MARIST DOT EDU
|
| cc:
|
| Subject: TDPO Error message
|
>------------------------------------------------------------------------------------------------------------------------------|
We are trialing TDPO so I can't call in for support yet.
This was working and starting today we are having trouble.
We started getting the following message when using TDPO.
RMAN> crosscheck backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 06/16/2004 11:14:31
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux Error: 2517: Unknown system error
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 2517, sbtopen: system error
Does anybody know what could be going wrong?
Or
Where I can look up these messages.
I never see the client connecting to the server in the ACTLOG.
"tdpoconf Shoeenv" command returns the following:
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 2, Level 0.0
(C) Copyright IBM Corporation 1997, 2003. All rights reserved.
DATA PROTECTION FOR ORACLE INFORMATION
Version: 5
Release: 2
Level: 0
Sublevel: 0
Platform: 32bit TDPO Linux86
TSM SERVER INFORMATION
Server Name: TDPO
Server Address: UXAS02
Server Type: HP-UX
Server Port: 1500
Communication Method: TCP/IP
SESSION INFORMATION
Owner Name: oracle
Node Name: us1lxas160_rman
Node Type: TDPO Linux86
DSMI_DIR: /opt/tivoli/tsm/client/api/bin
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/oracle/bin/dsm.opt
TDPO_OPTFILE: /opt/tivoli/tsm/client/oracle/bin/tdpo.opt
Password Directory: /opt/tivoli/tsm/client/oracle/bin
Compression: FALSE
===============
******************RMAN BACKUP**************************************
SERVERNAME TSM114G01
COMMmethod TCPip
TCPPort 1500
* Address for BOOT TSM Server
TCPServeraddress 10.220.2.16
TCPBUFFSIZE 32
TCPWINDOWSIZE 64
NODENAME HLTHRECDEVDB_ORA
PASSWORDACCESS prompt
TXNBYTELIMIT 25600
SCHEDMODE PROMPTED
=====================================FINAL STEPS======================================================
TDP configuration
--------------------------
[root@hlthrecdevdb bin64]#
[root@hlthrecdevdb bin64]# dsmc q sess
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 7, Release 1, Level 0.0
Client date/time: 12/14/2015 15:03:07
(c) Copyright by IBM Corporation and other(s) 1990, 2013. All Rights Reserved.
Node Name: HLTHRECDEVDB
Session established with server TSM114G01: AIX-RS/6000
Server Version 5, Release 5, Level 2.0
Server date/time: 12/14/2015 14:56:02 Last access: 12/14/2015 13:29:08
TSM Server Connection Information
Home Server Name........: TSM114G01
Server Type.............: AIX-RS/6000
Archive Retain Protect..: "No"
Server Version..........: Ver. 5, Rel. 5, Lev. 2.0
Last Access Date........: 12/14/2015 13:29:08
Delete Backup Files.....: "Yes"
Delete Archive Files....: "Yes"
Deduplication...........: None
Node Name...............: HLTHRECDEVDB
User Name...............: root
Secondary Server Information
Not configured for failover
[root@hlthrecdevdb bin64]#
------------------
To check tivoli client version and TDP version
----------------------------------------------
[oracle@hlthrecdevdb ~]$ rpm -qa | grep TDP
TDP-Oracle-7.1.3-0.x86_64
TDP-Oracle.Utility-7.1.3-0.x86_64
[oracle@hlthrecdevdb ~]$ rpm -qa | grep TIV
TIVsm-BA-7.1.0-0.x86_64
TIVsm-API64-7.1.0-0.x86_64
[oracle@hlthrecdevdb ~]$ uname -a
Linux hlthrecdevdb 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
To check file system which are being backed up on TAP
-----------------------------------------------------
[oracle@hlthrecdevdb ~]$ dsmc q fi
ANS2036W Pruning functions cannot open one of the Tivoli Storage Manager prune files: /var/opt/tivoli/tsm/log/dsmprune30218.log. errno = 13, Permission denied
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 7, Release 1, Level 0.0
Client date/time: 12/14/2015 13:26:39
(c) Copyright by IBM Corporation and other(s) 1990, 2013. All Rights Reserved.
Node Name: HLTHRECDEVDB
Session established with server TSM114G01: AIX-RS/6000
Server Version 5, Release 5, Level 2.0
Server date/time: 12/14/2015 13:19:34 Last access: 12/14/2015 12:56:49
# Last Incr Date Type File Space Name
--------------------------------------------------------------------------------
1 12/13/2015 04:00:54 EXT4 /
2 12/13/2015 03:34:44 EXT4 /APP
3 12/13/2015 03:42:27 EXT4 /Data1
4 12/13/2015 03:42:27 EXT4 /Data2
5 12/13/2015 03:42:41 EXT4 /arch
6 12/13/2015 03:42:41 EXT4 /backup
7 12/13/2015 03:42:41 EXT4 /boot
8 12/13/2015 03:42:41 EXT4 /home
9 12/13/2015 03:42:44 EXT4 /opt
10 12/13/2015 03:43:00 EXT4 /opt/IBM/ITM
11 12/13/2015 03:43:00 EXT4 /opt/IMB
12 12/13/2015 03:43:16 EXT4 /opt/tivoli
13 12/13/2015 04:00:20 EXT4 /oracle
14 12/13/2015 04:00:46 EXT4 /redo1
15 12/13/2015 04:01:14 EXT4 /redo2
16 12/13/2015 04:01:21 EXT4 /temp
17 12/13/2015 04:01:31 EXT4 /trace
18 12/13/2015 04:04:01 EXT4 /usr
19 12/13/2015 04:04:57 EXT4 /var
20 12/13/2015 03:34:44 EXT4 /var/adm/perfmgr
[oracle@hlthrecdevdb ~]$
============oracle backup configuration=============
There are three most important files to configure RMAN TAP backup
dsm.sys and dsm.opt in /opt/tivoli/tsm/client/ba/bin location and tdpo.opt in /opt/tivoli/tsm/client/oracle/bin64
rwxrwxrwx 1 root root 869 Dec 14 12:28 dsm.sys
-rw-r--r-- 1 root root 189 Dec 14 12:29 dsmerror.log
-rwxrwxrwx 1 root root 0 Dec 14 12:29 dsm.opt
[root@hlthrecdevdb bin]# pwd
/opt/tivoli/tsm/client/ba/bin
[root@hlthrecdevdb bin]#
if file system backup is already running then add stanza for RMAN TAP backup as below
[root@hlthrecdevdb bin]# cat dsm.sys
Servername TSM114G01
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.220.2.16
schedmode polling
passwordaccess generate
schedlogname /var/opt/tivoli/tsm/log/dsmsched.log
schedlogretention 10
errorlogname /var/opt/tivoli/tsm/log/dsmerror.log
errorlogretention 10
inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl
nodename hlthrecdevdb
Domain ALL-LOCAL
******************RMAN BACKUP**************************************
SERVERNAME oracle
COMMmethod TCPip
TCPPort 1500
* Address for BOOT TSM Server
TCPServeraddress 10.220.2.16
TCPBUFFSIZE 32
TCPWINDOWSIZE 64
NODENAME HLTHRECDEVDB_ORA
PASSWORDACCESS prompt
TXNBYTELIMIT 25600
SCHEDMODE PROMPTED
lrwxrwxrwx 1 oracle dba 37 Dec 8 13:28 dsm.sys -> /opt/tivoli/tsm/client/ba/bin/dsm.sys
-rwxrwxrwx. 1 root root 721 Dec 9 12:14 tdpo.opt
-rwxrwxrwx 1 root root 739 Dec 14 12:31 dsm.opt
-rw-r--r--. 1 root root 48 Dec 14 12:40 TDPO.HLTHRECDEVDB_ORA
-rwxrwxrwx. 1 oracle dba 16220 Dec 14 12:47 tdpoerror.log
[root@hlthrecdevdb bin64]# cat tdpo.opt
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the LinuxAMD64 Data Protection for Oracle
*********************************************************************
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64
*TDPO_FS /adsmorc
TDPO_NODE HLTHRECDEVDB_ORA
TDPO_OWNER oracle
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64
*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1
*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4
[root@hlthrecdevdb bin64]# dsm.opt
-bash: dsm.opt: command not found
[root@hlthrecdevdb bin64]# cat dsm.opt
************************************************************************
* Tivoli Storage Manager *
* *
* Sample Client User Options file for UNIX (dsm.opt.smp) *
************************************************************************
* This file contains an option you can use to specify the TSM
* server to contact if more than one is defined in your client
* system options file (dsm.sys). Copy dsm.opt.smp to dsm.opt.
* If you enter a server name for the option below, remove the
* leading asterisk (*).
************************************************************************
SERVERNAME oracle
[root@hlthrecdevdb bin64]# pwd
/opt/tivoli/tsm/client/oracle/bin64
[root@hlthrecdevdb bin64]#
and make soft link for dsm.sys in /opt/tivoli/tsm/client/oracle/bin64 from oracle user and from root user in /opt/tivoli/tsm/client/api/bin64
lrwxrwxrwx 1 oracle dba 37 Dec 8 13:28 dsm.sys -> /opt/tivoli/tsm/client/ba/bin/dsm.sys
lrwxrwxrwx 1 root root 37 Dec 8 13:25 dsm.sys -> /opt/tivoli/tsm/client/ba/bin/dsm.sys
lrwxrwxrwx 1 root root 43 Dec 14 12:36 dsm.opt -> /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
[root@hlthrecdevdb bin64]# pwd
/opt/tivoli/tsm/client/api/bin64
[root@hlthrecdevdb bin64]#
[root@hlthrecdevdb bin]#
create link for libobk from oralce_home/lib
--------------------------------------------
[oracleg@oracleserver.domainname ~]$ ln -s /opt/tivoli/tsm/client/oracle/bin64/libobk.so $ORACLE_HOME/lib
[oracle@oracleserver.domainname ~]$ ll $ORACLE_HOME/lib/libobk.so
lrwxrwxrwx 1 oraracle dba 45 Jul 13 12:00 /oracle/software/lib/libobk.so -> /opt/tivoli/tsm/client/oracle/bin64/libobk.so
tdpoconf password -TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
[root@hlthrecdevdb bin64]#
[root@hlthrecdevdb bin64]# tdpoconf showenv
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015. All rights reserved.
Data Protection for Oracle Information
Version: 7
Release: 1
Level: 3
Sublevel: 0
Platform: 64bit TDPO Linux86-64
Tivoli Storage Manager Server Information
Server Name: ORACLE
Server Address: 10.220.2.16
Server Type: AIX-RS/6000
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name: oracle
Node Name: HLTHRECDEVDB_ORA
Node Type: TDPO Linux86-64
DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE: /opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /opt/tivoli/tsm/client/oracle/bin64
Compression: FALSE
License Information: License file exists and contains valid license data.
[root@hlthrecdevdb bin64]#
===============================
CATPROC - Packages and Types Invalid in Dba_registry
When i looked in to the DBA_REGISTRY, I found that the Oracle Database Packages and Types Column in the Table is in INVALID state.
I had this problem after my database has been upgraded from Oracle 10gR2 to 11gR2.
SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10)
comp_id,substr(version,1,12) version,status from dba_registry;
2
COMP_NAME COMP_ID VERSION STATUS
------------------------------ ---------- ------------ -----------
Oracle XML Database XDB 11.2.0.2.0 VALID
Oracle Expression Filter EXF 11.2.0.2.0 VALID
Oracle Rule Manager RUL 11.2.0.2.0 VALID
Oracle Workspace Manager OWM 11.2.0.2.0 VALID
Oracle Database Catalog Views CATALOG 11.2.0.2.0 VALID
Oracle Database Packages and T CATPROC 11.2.0.2.0 INVALID
JServer JAVA Virtual Machine JAVAVM 11.2.0.2.0 VALID
Oracle XDK XML 11.2.0.2.0 VALID
Oracle Database Java Packages CATJAVA 11.2.0.2.0 VALID
9 rows selected.
Causes:
The probable causes for dba_registry components became invalid could be any of the following.
· Applied a patch and after the patch application because of some dependent object status change registry can become invalid
· Installed a new component and the new component installation got failed then registry components could become invalid
· catalog.sql or catproc.sql was not successfully ran after database creation. Any of them would have failed somewhere or any of the dependent object got invalid afterward
You can try the below steps to validate if you don’t have any invalid object in the database
SQL> select count(*) from dba_objects where status=’INVALID’;
COUNT(*)
———-
0
SQL> exec DBMS_REGISTRY_SYS.VALIDATE_CATPROC;
If you have any invalid objects in the database then follow the below steps
SQL> SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
449
1 row selected.
'Packages and Types' can usually be validated by running catalog and catproc scripts:
$sqlplus "/as sysdba"
SQL> startup restrict
SQL > @?/rdbms/admin/catalog.sql
SQL > @?/rdbms/admin/catproc.sql
SQL > @?/rdbms/admin/utlrp.sql
SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10)
comp_id,substr(version,1,12) version,status from dba_registry;
2
COMP_NAME COMP_ID VERSION STATUS
---------------------------------------- ---------- ------------ -----------
Oracle XML Database XDB 11.2.0.2.0 VALID
Oracle Expression Filter EXF 11.2.0.2.0 VALID
Oracle Rule Manager RUL 11.2.0.2.0 VALID
Oracle Workspace Manager OWM 11.2.0.2.0 VALID
Oracle Database Catalog Views CATALOG 11.2.0.2.0 VALID
Oracle Database Packages and T CATPROC 11.2.0.2.0 VALID
JServer JAVA Virtual Machine JAVAVM 11.2.0.2.0 VALID
Oracle XDK XML 11.2.0.2.0 VALID
Oracle Database Java Packages CATJAVA 11.2.0.2.0 VALID
9 rows selected.
Shutdown your database in the normal mode and startup with the normal mode.
No comments:
Post a Comment