Wednesday, June 6, 2018

Oracle support TLS 1.2 Only

Oracle removing support for legacy Transport Layer Security (TLS) protocols in order to ensure improved security and performance. Beginning on July 31, 2018, Object Storage Classic will no longer support TLS 1.0/1.1 and will support only TLS 1.2 or higher.

we need to update all client-server combinations to use TLS version 1.2. Additionally, we recommend that you update any tooling which connects to Object Storage Classic (e.g., cloudberry, rman backups, etc.) to use TLS 1.2. To help ensure a smooth transition, we recommend using Java Runtime Environment release 7 or higher. Additionally, for those who use File Transfer Manager command-line interface (FTM CLI), we recommend using version 2.4 or higher to address unrelated feature enhancements and fixes; however, updating FTM CLI is not required to accommodate the transition from TLS 1.0/1.1.

How to determine Java version

Java (Unix/Linux) 
Run the following from the command line: 
 java -version
FTM CLI
Run the following from the command line:

 java -jar ftmcli.jar -v
 
 
 

Tuesday, June 5, 2018

Cipher Options for Oracle Fusion Middleware's

New SSL Protocol and Cipher Options for Oracle Fusion Middleware's OPMN/ONS Component ( Doc ID 1905314.1 )

Saturday, May 26, 2018

X11 forwarding

xclock and local forwarding

Make sure xclock is installed.
.profile

MAIL=/usr/mail/${LOGNAME:?}
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/NX/bin:/sbin:/usr/sbin:/usr/local/sbin:.
export EDITOR=vi
HOSTNAME=`hostname|cut -f 1 -d .`

if [[ ! "$SUDO_USER" = "" ]]
then
  export OS_HOME=`dirname $HOME`
  export XAUTHORITY=$OS_HOME/$SUDO_USER/.Xauthority
  echo "XAUTHORITY = $XAUTHORITY"
fi

WHOAMI=`whoami`
export PS1='$WHOAMI@$HOSTNAME$'
set -o vi
umask 027
alias lsf='ls -F'
alias lsa='ls -aF'
alias bdf='df -k'
alias psa='ps -afe|grep $1'
alias cdp='cd /apps/oracle/local/profiles; ls -a'
alias cdo='cd $ORACLE_HOME'



Oracle apps upgrade 11.5.10.2 to 12.2

Oracle® E-Business Suite Upgrade Guide Release 11i to 12.2 Part No. E48834-03

https://docs.oracle.com/cd/E51111_01/current/html/docset.html

Wednesday, May 9, 2018

Extensions - Log Warning(38,40): The 'requires-ui' attribute is deprecated. Use 'headless' instead Warning(39,40): The 'requires-ui' attribute is deprecated. Use 'headless' instead

Use "Headless" Instead (Doc ID 2030725.1)

OAF For R12.2.7

-rw-r-----.  1 oracle oinstall 960420040 May  9 13:59 p26550226_R12_GENERIC.zip

When you unzip you will see the below folder


drwxr-x---.  3 oracle oinstall      4096 Aug 31  2017 jdevhome
drwxr-x---. 48 oracle oinstall      4096 Aug 31  2017 jdevbin
drwxr-x---.  4 oracle oinstall      4096 Aug 31  2017 jdevdoc
-rw-rw-r--.  1 oracle oinstall      4825 Sep 14  2017 OAEXT_README.txt


cp  /apps2/oracle/product/fs1/inst/apps/DEV_suthakar/appl/fnd/12.0.0/secure/dev.dbc  /apps/oracle/product/oaf/jdevhome/jdev/dbc_files/secure/
cd /apps/oracle/product/oaf/jdevbin/jdev/bin/jdev

.profile
#!/bin/bash

export JAVA_HOME=/apps/oracle/product/JDK/jdk1.8.0_151

export JDEV_HOME=/apps/oracle/product/oaf/jdevbin/jdev/bin/

cd $JDEV_HOME
~
 

when I invoke jdev I was getting this error my jdk version is not set.

Error: JDeveloper can't recognize the JDK version
 


Fix
open the (take backup) jdev.conf file and comment out the line
SetJavaVM hotspot and save it.
 
 
Then invoke jdev. works fine.
 
  
 
 
  
 

ASM DISK setup

 [root@rac1 ~]# ls /dev/sd*
/dev/sda  /dev/sda1  /dev/sda2  /dev/sdb
[root@rac1 ~]# ls -l /dev/sd*          
brw-rw---- 1 root disk 8,  0 May  4 16:40 /dev/sda
brw-rw---- 1 root disk 8,  1 May  4 16:40 /dev/sda1
brw-rw---- 1 root disk 8,  2 May  4 16:40 /dev/sda2
brw-rw---- 1 root disk 8, 16 May  4 16:40 /dev/sdb
[root@rac1 ~]# 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 0x3ba15934.                    
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@rac1 ~]# ls -l /dev/sd*
brw-rw---- 1 root disk 8,  0 May  4 16:40 /dev/sda
brw-rw---- 1 root disk 8,  1 May  4 16:40 /dev/sda1
brw-rw---- 1 root disk 8,  2 May  4 16:40 /dev/sda2
brw-rw---- 1 root disk 8, 16 May  4 16:58 /dev/sdb
brw-rw---- 1 root disk 8, 17 May  4 16:58 /dev/sdb1

oracleasm createdisk DISK1 /dev/sdb1
Writing disk header: done
Instantiating disk: done

[root@rac1 ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@rac1 ~]#
 oracleasm listdisks
DISK1
[root@rac1 ~]#vi /etc/scsi_id.config
options=-g

[root@rac1 ~]# /sbin/scsi_id -g -u -d /dev/sdb
1ATA_VBOX_HARDDISK_VB9357ce3b-21d92e85

vi /etc/udev/rules.d/99-oracle-asmdevices.rules

KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB9357ce3b-21d92e85", NAME="asm_disk1", OWNER="oracle", GROUP="dba", MODE="0660"


installation Grid

installation db binary
dbca


. oraenv
ORACLE_SID = [oracle] ? racdb
The Oracle base has been set to /u01/app/oracle
[oracle@rac1 bin]$ srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/RACDB/PARAMETERFILE/spfile.270.975274745
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
OSDBA group:
OSOPER group:
Database instance: racdb
[oracle@rac1 bin]$ srvctl status database -d racdb
Database is running.
[oracle@rac1 bin]$
. oraenv
ORACLE_SID = [racdb] ? racdb
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1 bin]$ srvctl stop database -d racdb

$srvctl stop asm -force