Linux

Changing SYS Password in Dataguard Environment

If you change SYS password with ALTER USER SYS IDENTIFIED BY NEWPASSWORD on the primary database of a dataguard environment, primary side stops to transfer archivelogs to standby and you will see an error on primary database alertlog file like:

In this situation set your password file in standby server with:
orapwd file=$ORACLE_HOME/dbs/orapwSID password=newpassword; (don’t forget to move/delete old one)

Create a password file in ASM diskgroup:

orapwd file=‘+DATA/orapwORCL’ ENTRIES=10 DBUNIQUENAME=‘ORCL’

We can view users authenticated through password file in v$pwfile_users table

SQL> select username,sysdba from v$pwfile_users;
USERNAME  SYSDB
SYS       TRUE
Advertisements
Standard
Linux

How to Add New Disks Using LVM to an Existing Linux System

 

[oracle@ermantest ~]$ su –
Password:
[root@ermantest ~]# clear
[root@ermantest ~]# fdisk -l

Disk /dev/sda: 32.2 GB, 32212254720 bytes
255 heads, 63 sectors/track, 3916 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000accd6

Device Boot Start End Blocks Id System
/dev/sda1 * 1 64 512000 83 Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2 64 3917 30944256 8e Linux LVM

Disk /dev/sdb: 2147 MB, 2147483648 bytes
255 heads, 63 sectors/track, 261 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
Disk /dev/sdc: 4294 MB, 4294967296 bytes
255 heads, 63 sectors/track, 522 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
Disk /dev/mapper/vg_ermantest-lv_root: 28.5 GB, 28496101376 bytes
255 heads, 63 sectors/track, 3464 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
Disk /dev/mapper/vg_ermantest-lv_swap: 3187 MB, 3187671040 bytes
255 heads, 63 sectors/track, 387 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

[root@ermantest ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0xdf59b502.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won’t be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

WARNING: DOS-compatible mode is deprecated. It’s strongly recommended to
switch off the mode (command ‘c’) and change display units to
sectors (command ‘u’).

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4):
Value out of range.
Partition number (1-4): 1
First cylinder (1-261, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-261, default 261):
Using default value 261

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@ermantest ~]# fdisk /dev/sdc
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0xd3696a9a.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won’t be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

WARNING: DOS-compatible mode is deprecated. It’s strongly recommended to
switch off the mode (command ‘c’) and change display units to
sectors (command ‘u’).

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-522, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-522, default 522):
Using default value 522

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@ermantest ~]#
[root@ermantest ~]# fdisk -l

Disk /dev/sda: 32.2 GB, 32212254720 bytes
255 heads, 63 sectors/track, 3916 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000accd6

Device Boot Start End Blocks Id System
/dev/sda1 * 1 64 512000 83 Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2 64 3917 30944256 8e Linux LVM

Disk /dev/sdb: 2147 MB, 2147483648 bytes
255 heads, 63 sectors/track, 261 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xdf59b502

Device Boot Start End Blocks Id System
/dev/sdb1 1 261 2096451 83 Linux

Disk /dev/sdc: 4294 MB, 4294967296 bytes
255 heads, 63 sectors/track, 522 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xd3696a9a

Device Boot Start End Blocks Id System
/dev/sdc1 1 522 4192933+ 83 Linux

Disk /dev/mapper/vg_ermantest-lv_root: 28.5 GB, 28496101376 bytes
255 heads, 63 sectors/track, 3464 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
Disk /dev/mapper/vg_ermantest-lv_swap: 3187 MB, 3187671040 bytes
255 heads, 63 sectors/track, 387 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

[root@ermantest ~]# pvcreate /dev/sdb1
Physical volume “/dev/sdb1” successfully created
You have new mail in /var/spool/mail/root
[root@ermantest ~]# pvcreate /dev/sdc1
Physical volume “/dev/sdc1” successfully created
[root@ermantest ~]# vgcreate oracledb /dev/sdb1 /dev/sdc1
Volume group “oracledb” successfully created
[root@ermantest ~]# vgdisplay oracledb
— Volume group —
VG Name oracledb
System ID
Format lvm2
Metadata Areas 2
Metadata Sequence No 1
VG Access read/write
VG Status resizable
MAX LV 0
Cur LV 0
Open LV 0
Max PV 0
Cur PV 2
Act PV 2
VG Size 5.99 GiB
PE Size 4.00 MiB
Total PE 1534
Alloc PE / Size 0 / 0
Free PE / Size 1534 / 5.99 GiB
VG UUID 8wD0HH-OZwX-rYXn-idYf-7zxR-JDuT-0A6jWN

[root@ermantest ~]# lvcreate -n lv_db1 –size 2G oracledb
Logical volume “lv_db1” created
[root@ermantest ~]# lvcreate -n lv_db1 –size 1G oracledb
Logical volume “lv_db1” already exists in volume group “oracledb”
[root@ermantest ~]# lvcreate -n lv_db2 –size 1G oracledb
Logical volume “lv_db2” created
[root@ermantest ~]# lvdisplay oracledb
— Logical volume —
LV Path /dev/oracledb/lv_db1
LV Name lv_db1
VG Name oracledb
LV UUID cu6uqE-4fpY-ihnN-IxJr-uoBP-ckQ0-s61uiV
LV Write Access read/write
LV Creation host, time ermantest, 2018-08-30 13:02:17 +0300
LV Status available
# open 0
LV Size 2.00 GiB
Current LE 512
Segments 1
Allocation inherit
Read ahead sectors auto
– currently set to 256
Block device 252:2

— Logical volume —
LV Path /dev/oracledb/lv_db2
LV Name lv_db2
VG Name oracledb
LV UUID 91HVRv-8pBZ-tfko-dleI-UqUH-0P6w-KnMTfB
LV Write Access read/write
LV Creation host, time ermantest, 2018-08-30 13:02:33 +0300
LV Status available
# open 0
LV Size 1.00 GiB
Current LE 256
Segments 1
Allocation inherit
Read ahead sectors auto
– currently set to 256
Block device 252:3

[root@ermantest ~]# mkfs.ext4 /dev/oracledb/lv_db1
mke2fs 1.43-WIP (20-Jun-2013)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
131072 inodes, 524288 blocks
26214 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=536870912
16 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912

Allocating group tables: done
Writing inode tables: done
Creating journal (16384 blocks): done
Writing superblocks and filesystem accounting information: done

[root@ermantest ~]# mkfs.ext4 /dev/oracledb/lv_db2
mke2fs 1.43-WIP (20-Jun-2013)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
65536 inodes, 262144 blocks
13107 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=268435456
8 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376

Allocating group tables: done
Writing inode tables: done
Creating journal (8192 blocks): done
Writing superblocks and filesystem accounting information: done

[root@ermantest ~]# mount /dev/oracledb/lv_db1 /db1
mount: mount point /db1 does not exist
[root@ermantest ~]# mkdir /data1
[root@ermantest ~]# mkdir /data2
[root@ermantest ~]# mount /dev/oracledb/lv_db1 /data1
[root@ermantest ~]# mount /dev/oracledb/lv_db1 /data2
[root@ermantest ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_ermantest-lv_root 26G 19G 5.9G 77% /
tmpfs 1.5G 721M 797M 48% /dev/shm
/dev/sda1 477M 55M 397M 13% /boot
/dev/mapper/oracledb-lv_db1 2.0G 3.0M 1.9G 1% /data1
/dev/mapper/oracledb-lv_db1 2.0G 3.0M 1.9G 1% /data2
[root@ermantest ~]#

Standard
Linux

OpenSSH

Install/Update OpenSSH Server
OpenSSH Server packages is available under default apt repositories under all versions of operating systems. You can install or update latest OpenSSH server using following command.

sudo apt-get update
sudo apt-get install openssh-server

>Versiyon:
ssh -V

>Status:
sudo systemctl status ssh

>Stop,Start,Status OpenSSH:
sudo stop ssh
sudo start ssh
sudo restart ssh
sudo status ssh

>If you are using iptables to secure your server, use following command to open port for SSH access.

sudo iptables -A INPUT -s 192.168.1.0/24 -p tcp –dport 22 -j ACCEPT
sudo ufw allow from 192.168.1.0/24 to any port 22

Standard
Linux, Oracle

Oracle TFA upgrade from 18.1 to 18.3 on RAC database

[root@prod ~]# /u01/app/12.2.0/grid/bin/tfactl status

.——————————————————————————————————-.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+—————–+—————+——-+——+————+———————-+——————+
| prod | RUNNING | 32071 | 5000 | 18.1.1.0.0 | 18110020180328025002 | COMPLETE |
| prod2 | RUNNING | 6505 | 5000 | 18.1.1.0.0 | 18110020180328025002 | COMPLETE |
‘—————–+—————+——-+——+————+———————-+——————‘

[root@prod tmp]# ./installTFA-LINUX
TFA Installation Log will be written to File : /tmp/tfa_install_25637_2018_08_28-11_21_28.log

Starting TFA installation

TFA Version: 183000 Build Date: 201808081359

TFA HOME : /u01/app/12.2.0/grid/tfa/prod/tfa_home

Installed Build Version: 181100 Build Date: 201803280250

TFA is already installed. Patching /u01/app/12.2.0/grid/tfa/prod/tfa_home…
TFA patching typical install from zipfile is written to /u01/app/12.2.0/grid/tfa/prod/tfapatch.log

TFA will be Patched on:
prod
prod2

Do you want to continue with patching TFA? [Y|N] [Y]: y
Checking for ssh equivalency in prod2
prod2 is configured for ssh user equivalency for root user
Using SSH to patch TFA to remote nodes :

Applying Patch on prod2:

TFA_HOME: /u01/app/12.2.0/grid/tfa/prod2/tfa_home
Stopping TFA Support Tools…
Shutting down TFA
Removed symlink /etc/systemd/system/graphical.target.wants/oracle-tfa.service.
Removed symlink /etc/systemd/system/multi-user.target.wants/oracle-tfa.service.
. . . . .
. . .
Successfully shutdown TFA..
Copying files from prod to prod2…

Current version of Berkeley DB in prod2 is 5 or higher, so no DbPreUpgrade required
Running commands to fix init.tfa and tfactl in prod2…
Updating init.tfa in prod2…
Starting TFA in prod2…
Starting TFA..
Created symlink from /etc/systemd/system/multi-user.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service.
Created symlink from /etc/systemd/system/graphical.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service.
Waiting up to 100 seconds for TFA to be started..
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands

Enabling Access for Non-root Users on prod2…
Applying Patch on prod:

Stopping TFA Support Tools…

Shutting down TFA for Patching…

Shutting down TFA
Removed symlink /etc/systemd/system/graphical.target.wants/oracle-tfa.service.
Removed symlink /etc/systemd/system/multi-user.target.wants/oracle-tfa.service.
. . . . .
. . .
Successfully shutdown TFA..

No Berkeley DB upgrade required

Copying TFA Certificates…

Running commands to fix init.tfa and tfactl in localhost
Starting TFA in prod…

Starting TFA..
Created symlink from /etc/systemd/system/multi-user.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service.
Created symlink from /etc/systemd/system/graphical.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service.
Waiting up to 100 seconds for TFA to be started..
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands

Enabling Access for Non-root Users on prod…

.———————————————————————–.
| Host | TFA Version | TFA Build ID | Upgrade Status |
+—————–+————-+———————-+—————-+
| prod | 18.3.0.0.0 | 18300020180808135947 | UPGRADED |
| prod2 | 18.3.0.0.0 | 18300020180808135947 | UPGRADED |
‘—————–+————-+———————-+—————-‘

cleanup serializable files

[root@prod tmp]# /u01/app/oracle/product/12.2.0.1/db_1/bin/tfactl toolstatus
-bash: /u01/app/oracle/product/12.2.0.1/db_1/bin/tfactl: No such file or directory
[root@prod tmp]# /u01/app/12.2.0/grid/bin/tfactl toolstatus

.——————————————————————.
| TOOLS STATUS – HOST : prod |
+———————-+————–+————–+————-+
| Tool Type | Tool | Version | Status |
+———————-+————–+————–+————-+
| Development Tools | orachk | 12.2.0.1.3 | DEPLOYED |
| | oratop | 14.1.2 | DEPLOYED |
+———————-+————–+————–+————-+
| Support Tools Bundle | darda | 2.10.0.R6036 | DEPLOYED |
| | oswbb | 8.0.1 | RUNNING |
| | prw | 12.1.13.11.4 | NOT RUNNING |
+———————-+————–+————–+————-+
| TFA Utilities | alertsummary | 12.2.1.1.0 | DEPLOYED |
| | calog | 12.2.0.1.0 | DEPLOYED |
| | dbcheck | 18.3.0.0.0 | DEPLOYED |
| | dbglevel | 12.2.1.1.0 | DEPLOYED |
| | grep | 12.2.1.1.0 | DEPLOYED |
| | history | 12.2.1.1.0 | DEPLOYED |
| | ls | 12.2.1.1.0 | DEPLOYED |
| | managelogs | 12.2.1.1.0 | DEPLOYED |
| | menu | 12.2.1.1.0 | DEPLOYED |
| | param | 12.2.1.1.0 | DEPLOYED |
| | ps | 12.2.1.1.0 | DEPLOYED |
| | pstack | 12.2.1.1.0 | DEPLOYED |
| | summary | 12.2.1.1.0 | DEPLOYED |
| | tail | 12.2.1.1.0 | DEPLOYED |
| | triage | 12.2.1.1.0 | DEPLOYED |
| | vi | 12.2.1.1.0 | DEPLOYED |
‘———————-+————–+————–+————-‘

Note :-
DEPLOYED : Installed and Available – To be configured or run interactively.
NOT RUNNING : Configured and Available – Currently turned off interactively.
RUNNING : Configured and Available.

[root@prod tmp]# ps -ef |grep osw
grid 1881 1 0 11:24 ? 00:00:00 /bin/sh ./OSWatcher.sh 30 48 NONE /u01/app/grid/tfa/repository/suptools/prod/oswbb/grid/archive
grid 4687 1881 0 11:25 ? 00:00:00 /bin/sh ./OSWatcherFM.sh 48 /u01/app/grid/tfa/repository/suptools/prod/oswbb/grid/archive
root 18797 15763 0 11:27 pts/0 00:00:00 grep –color=auto osw
[root@prod tmp]# ls


[root@prod2 ~]# /u01/app/12.2.0/grid/bin/tfactl status

.——————————————————————————————————-.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+—————–+—————+——-+——+————+———————-+——————+
| prod2 | RUNNING | 24858 | 5000 | 18.3.0.0.0 | 18300020180808135947 | COMPLETE |
| xqaytidmdbprod1 | RUNNING | 908 | 5000 | 18.3.0.0.0 | 18300020180808135947 | RUNNING |
‘—————–+—————+——-+——+————+———————-+——————‘
[root@prod2 ~]# /u01/app/12.2.0/grid/bin/tfactl toolstatus

.——————————————————————.
| TOOLS STATUS – HOST : prod2 |
+———————-+————–+————–+————-+
| Tool Type | Tool | Version | Status |
+———————-+————–+————–+————-+
| Development Tools | orachk | 12.2.0.1.3 | DEPLOYED |
| | oratop | 14.1.2 | DEPLOYED |
+———————-+————–+————–+————-+
| Support Tools Bundle | darda | 2.10.0.R6036 | DEPLOYED |
| | oswbb | 8.0.1 | RUNNING |
| | prw | 12.1.13.11.4 | NOT RUNNING |
+———————-+————–+————–+————-+
| TFA Utilities | alertsummary | 12.2.1.1.0 | DEPLOYED |
| | calog | 12.2.0.1.0 | DEPLOYED |
| | dbcheck | 18.3.0.0.0 | DEPLOYED |
| | dbglevel | 12.2.1.1.0 | DEPLOYED |
| | grep | 12.2.1.1.0 | DEPLOYED |
| | history | 12.2.1.1.0 | DEPLOYED |
| | ls | 12.2.1.1.0 | DEPLOYED |
| | managelogs | 12.2.1.1.0 | DEPLOYED |
| | menu | 12.2.1.1.0 | DEPLOYED |
| | param | 12.2.1.1.0 | DEPLOYED |
| | ps | 12.2.1.1.0 | DEPLOYED |
| | pstack | 12.2.1.1.0 | DEPLOYED |
| | summary | 12.2.1.1.0 | DEPLOYED |
| | tail | 12.2.1.1.0 | DEPLOYED |
| | triage | 12.2.1.1.0 | DEPLOYED |
| | vi | 12.2.1.1.0 | DEPLOYED |
‘———————-+————–+————–+————-‘

Note :-
DEPLOYED : Installed and Available – To be configured or run interactively.
NOT RUNNING : Configured and Available – Currently turned off interactively.
RUNNING : Configured and Available.

[root@prod2 ~]# ps -ef |grep osw
grid 25682 1 0 11:22 ? 00:00:00 /bin/sh ./OSWatcher.sh 30 48 NONE /u01/app/grid/tfa/repository/suptools/prod2/oswbb/grid/archive
root 25948 20854 0 11:29 pts/0 00:00:00 grep –color=auto osw
grid 27200 25682 0 11:23 ? 00:00:00 /bin/sh ./OSWatcherFM.sh 48 /u01/app/grid/tfa/repository/suptools/prod2/oswbb/grid/archive
[root@prod2 ~]#

 

Br. Erman.

Standard
Linux

Oracle Database TFA(Trace File Analyzer) upgrade from 12.2 to 18.3

Hello,Oracle releases a new version of Oracle Trace File Analyzer. Download the latest version of Oracle Trace File Analyzer with Oracle Database support tools bundle from My Oracle Support note 1513912.1.

Upgrading is similar to first-time install. As root, use the installTFAplatform script.
exaple for linux > ./installTFA-Linux.

step by steps upgrade TFA from 12.2 to 18.3.

check curently version of TFA.

[root@ermantest tmp]# /u01/app/oracle/product/12.1.0.2/db_1/bin/tfactl status

.————————————————————————————————-.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+———–+—————+——+——-+————+———————-+——————+
| ermantest | RUNNING | 3610 | 62675 | 12.2.1.0.0 | 12210020161122170355 | COMPLETE |
‘———–+—————+——+——-+————+———————-+——————‘

  • Downloand TFA 18.3 under the tmp file, then run this file.

[root@ermantest tmp]# ./installTFA-LINUX
TFA Installation Log will be written to File : /tmp/tfa_install_4423_2018_08_27-17_40_27.log

Starting TFA installation

TFA Version: 183000 Build Date: 201808081359

TFA HOME : /u01/app/oracle/tfa/ermantest/tfa_home

Installed Build Version: 122100 Build Date: 201611221703

TFA is already installed. Patching /u01/app/oracle/tfa/ermantest/tfa_home…
TFA patching typical install from zipfile is written to /u01/app/oracle/tfa/ermantest/tfapatch.log

TFA will be Patched on Node ermantest:

Do you want to continue with patching TFA? [Y|N] [Y]: y

Applying Patch on ermantest:

Stopping TFA Support Tools…

Shutting down TFA for Patching…

Shutting down TFA
oracle-tfa stop/waiting
. . . . .
. . .
Successfully shutdown TFA..

No Berkeley DB upgrade required

Copying TFA Certificates…

Running commands to fix init.tfa and tfactl in localhost

Starting TFA in ermantest…

Starting TFA..
oracle-tfa start/running, process 5070
Waiting up to 100 seconds for TFA to be started..
. . . . .
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands

Enabling Access for Non-root Users on ermantest…

WARNING – TFA Software is older than 180 days. Please consider upgrading TFA to the latest version.
WARNING – TFA Software is older than 180 days. Please consider upgrading TFA to the latest version.
.—————————————————————–.
| Host | TFA Version | TFA Build ID | Upgrade Status |
+———–+————-+———————-+—————-+
| ermantest | 18.3.0.0.0 | 18300020180808135947 | UPGRADED |
‘———–+————-+———————-+—————-‘

cleanup serializable files

You have new mail in /var/spool/mail/root

  • show new version of TFA.

[root@ermantest tmp]# /u01/app/oracle/product/12.1.0.2/db_1/bin/tfactl status

.————————————————————————————————-.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+———–+—————+——+——-+————+———————-+——————+
| ermantest | RUNNING | 5153 | 15218 | 18.3.0.0.0 | 18300020180808135947 | UPGRADED |
‘———–+—————+——+——-+————+———————-+——————‘

[root@ermantest tmp]#

root@ermantest tmp]# /u01/app/oracle/product/12.1.0.2/db_1/bin/tfactl toolstatus

.——————————————————————.
| TOOLS STATUS – HOST : ermantest |
+———————-+————–+————–+————-+
| Tool Type | Tool | Version | Status |
+———————-+————–+————–+————-+
| Development Tools | orachk | 12.2.0.1.3 | DEPLOYED |
| | oratop | 14.1.2 | DEPLOYED |
+———————-+————–+————–+————-+
| Support Tools Bundle | darda | 2.10.0.R6036 | DEPLOYED |
| | oswbb | 8.0.1 | NOT RUNNING |
| | prw | 12.1.13.11.4 | NOT RUNNING |
+———————-+————–+————–+————-+
| TFA Utilities | alertsummary | 12.2.1.1.0 | DEPLOYED |
| | calog | 12.2.0.1.0 | DEPLOYED |
| | dbcheck | 18.3.0.0.0 | DEPLOYED |
| | dbglevel | 12.2.1.1.0 | DEPLOYED |
| | grep | 12.2.1.1.0 | DEPLOYED |
| | history | 12.2.1.1.0 | DEPLOYED |
| | ls | 12.2.1.1.0 | DEPLOYED |
| | managelogs | 12.2.1.1.0 | DEPLOYED |
| | menu | 12.2.1.1.0 | DEPLOYED |
| | param | 12.2.1.1.0 | DEPLOYED |
| | ps | 12.2.1.1.0 | DEPLOYED |
| | pstack | 12.2.1.1.0 | DEPLOYED |
| | summary | 12.2.1.1.0 | DEPLOYED |
| | tail | 12.2.1.1.0 | DEPLOYED |
| | triage | 12.2.1.1.0 | DEPLOYED |
| | vi | 12.2.1.1.0 | DEPLOYED |
‘———————-+————–+————–+————-‘

Note :-
DEPLOYED : Installed and Available – To be configured or run interactively.
NOT RUNNING : Configured and Available – Currently turned off interactively.
RUNNING : Configured and Available.

Nice, Br. Erman.

Standard
Linux

Oracle Database Trace File Analyzer Installation – Oracle database 12.2

[root@ermantest ~]# cd /u01/app/oracle/product/12.1.0.2/db_1/
[root@ermantest db_1]# ./root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.1.0.2/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of “dbhome” have not changed. No need to overwrite.
The contents of “oraenv” have not changed. No need to overwrite.
The contents of “coraenv” have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] :
yes
Installing Oracle Trace File Analyzer (TFA).
Log File: /u01/app/oracle/product/12.1.0.2/db_1/install/root_ermantest_2018-08-27_12-39-02-731205117.log
Finished installing Oracle Trace File Analyzer (TFA)
[root@ermantest db_1]# cd ü
-bash: cd: ü: No such file or directory
[root@ermantest db_1]# cd /u01/app/oracle/product/12.1.0.2/db_1/
addnode/ dbjava/ inventory/ odbc/ plsql/ sqlpatch/
apex/ dbs/ javavm/ olap/ precomp/ sqlplus/
assistants/ dc_ocm/ jdbc/ OPatch/ QOpatch/ srvm/
bin/ deinstall/ jdk/ opmn/ R/ suptools/
ccr/ demo/ jlib/ oracore/ racg/ sysman/
cdata/ diagnostics/ ldap/ oraInst.loc rdbms/ ucp/
cfgtoollogs/ dmu/ lib/ ord/ relnotes/ usm/
clone/ dv/ log/ ordim/ http://root.sh utl/
crs/ env.ora md/ ords/ schagent.conf wwg/
css/ has/ mgw/ oss/ scheduler/ xdk/
ctx/ hs/ network/ oui/ slax/
cv/ install/ nls/ owm/ sqldeveloper/
data/ instantclient/ oc4j/ perl/ sqlj/
[root@ermantest db_1]# cd /u01/app/oracle/product/12.1.0.2/db_1/bin/
[root@ermantest bin]# ./tfactl status

.————————————————————————————————–.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+———–+—————+——-+——-+————+———————-+——————+
| ermantest | RUNNING | 10589 | 59891 | 12.2.1.0.0 | 12210020161122170355 | COMPLETE |
‘———–+—————+——-+——-+————+———————-+——————‘
br. erman

Standard
Linux

Trace File Analyzer Collector – TFA install and deinstall

[root@ermantest ~]# cd /tmp/
[root@ermantest tmp]# ./installTFA-LINUX
TFA Installation Log will be written to File : /tmp/tfa_install_1227_2018_08_27-11_45_20.log

Starting TFA installation

TFA Version: 183000 Build Date: 201808081359

Enter a location for installing TFA (/tfa will be appended if not supplied) [/tmp/tfa]:

Running Auto Setup for TFA as user root…

Would you like to do a [L]ocal only or [C]lusterwide installation ? [L|l|C|c] [C] : l
Installing TFA now…

Discovering Nodes and Oracle resources

Starting Discovery…

No Grid Infrastructure Discovered on this system . . . . .

ermantest
Searching for running databases…
1. TESTDB

Searching out ORACLE_HOME for selected databases…

Getting Oracle Inventory…

ORACLE INVENTORY: /u01/app/oraInventory

Discovery Complete…

TFA Will be Installed on ermantest…

TFA will scan the following Directories
++++++++++++++++++++++++++++++++++++++++++++

.——————————————————————.
| ermantest |
+——————————————————-+———-+
| Trace Directory | Resource |
+——————————————————-+———-+
| /u01/app/oraInventory/ContentsXML | INSTALL |
| /u01/app/oraInventory/logs | INSTALL |
| /u01/app/oracle/cfgtoollogs | CFGTOOLS |
| /u01/app/oracle/diag/rdbms/testdb/TESTDB/cdump | RDBMS |
| /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace | RDBMS |
| /u01/app/oracle/diag/tnslsnr/ermantest/listener/cdump | TNS |
| /u01/app/oracle/diag/tnslsnr/ermantest/listener/trace | TNS |
| /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs | CFGTOOLS |
| /u01/app/oracle/product/12.1.0.2/db_1/install | INSTALL |
‘——————————————————-+———-‘

Installing TFA on ermantest:
HOST: ermantestTFA_HOME: /tmp/tfa/ermantest/tfa_home

.——————————————————————————.
| Host | Status of TFA | PID | Port | Version | Build ID |
+———–+—————+——+——-+————+———————-+
| ermantest | RUNNING | 1715 | 30560 | 18.3.0.0.0 | 18300020180808135947 |
‘———–+—————+——+——-+————+———————-‘

Running Inventory in All Nodes…

Enabling Access for Non-root Users on ermantest…

Please add world execute permissions for all directories above /tmp to enable TFA Non-Root Access

Adding default users to TFA Access list…

Summary of TFA Installation:
.—————————————————.
| ermantest |
+———————+—————————–+
| Parameter | Value |
+———————+—————————–+
| Install location | /tmp/tfa/ermantest/tfa_home |
| Repository location | /tmp/tfa/repository |
‘———————+—————————–‘

TFA is successfully installed…

Usage : /tmp/tfa/bin/tfactl <command> [options]
commands:diagcollect|collection|analyze|ips|run|start|stop|enable|disable|status|print|access|purge|directory|host|receiver|set|toolstatus|uninstall|diagnosetfa|syncnodes|setupmos|upload|availability|rest|events|search|changes|isa
For detailed help on each command use:
/tmp/tfa/bin/tfactl <command> -help

[root@ermantest tmp]# /u01/app/oracle/product/12.1.0.2/db_1/bin/tfactl status

.————————————————————————————————-.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+———–+—————+——+——-+————+———————-+——————+
| ermantest | RUNNING | 1715 | 30560 | 18.3.0.0.0 | 18300020180808135947 | COMPLETE |
‘———–+—————+——+——-+————+———————-+——————‘

[root@ermantest tmp]# /u01/app/oracle/product/12.1.0.2/db_1/bin/tfactl toolstatus

.——————————————————————.
| TOOLS STATUS – HOST : ermantest |
+———————-+————–+————–+————-+
| Tool Type | Tool | Version | Status |
+———————-+————–+————–+————-+
| Development Tools | orachk | 12.2.0.1.3 | DEPLOYED |
| | oratop | 14.1.2 | DEPLOYED |
+———————-+————–+————–+————-+
| Support Tools Bundle | darda | 2.10.0.R6036 | DEPLOYED |
| | oswbb | 8.0.1 | NOT RUNNING |
| | prw | 12.1.13.11.4 | NOT RUNNING |
+———————-+————–+————–+————-+
| TFA Utilities | alertsummary | 12.2.1.1.0 | DEPLOYED |
| | calog | 12.2.0.1.0 | DEPLOYED |
| | dbcheck | 18.3.0.0.0 | DEPLOYED |
| | dbglevel | 12.2.1.1.0 | DEPLOYED |
| | grep | 12.2.1.1.0 | DEPLOYED |
| | history | 12.2.1.1.0 | DEPLOYED |
| | ls | 12.2.1.1.0 | DEPLOYED |
| | managelogs | 12.2.1.1.0 | DEPLOYED |
| | menu | 12.2.1.1.0 | DEPLOYED |
| | param | 12.2.1.1.0 | DEPLOYED |
| | ps | 12.2.1.1.0 | DEPLOYED |
| | pstack | 12.2.1.1.0 | DEPLOYED |
| | summary | 12.2.1.1.0 | DEPLOYED |
| | tail | 12.2.1.1.0 | DEPLOYED |
| | triage | 12.2.1.1.0 | DEPLOYED |
| | vi | 12.2.1.1.0 | DEPLOYED |
‘———————-+————–+————–+————-‘

Note :-
DEPLOYED : Installed and Available – To be configured or run interactively.
NOT RUNNING : Configured and Available – Currently turned off interactively.
RUNNING : Configured and Available.

[root@ermantest tmp]#

Erman KARA
[root@ermantest tmp]# /u01/app/oracle/product/12.1.0.2/db_1/bin/
Display all 195 possibilities? (y or n)
[root@ermantest tmp]# /u01/app/oracle/product/12.1.0.2/db_1/bin/tfactl uninstall
TFA will be uninstalled on ermantest :

Removing TFA from ermantest…

Stopping TFA Support Tools…

Stopping TFA in ermantest…

Shutting down TFA
oracle-tfa stop/waiting
. . . . .
Killing TFA running with pid 1715
. . .
Successfully shutdown TFA..

TFA-00002 Oracle Trace File Analyzer (TFA) is not running
Deleting TFA support files on ermantest:
Removing /etc/rc.d/rc0.d/K17init.tfa
Removing /etc/rc.d/rc1.d/K17init.tfa
Removing /etc/rc.d/rc2.d/K17init.tfa
Removing /etc/rc.d/rc4.d/K17init.tfa
Removing /etc/rc.d/rc6.d/K17init.tfa
Removing /etc/init.d/init.tfa…
Removing /tmp/tfa/bin…
Removing /tmp/tfa/ermantest…

[root@ermantest tmp]#
[root@ermantest tmp]#
[root@ermantest tmp]#
[root@ermantest tmp]#

Standard