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




SSO setup for OBIEE12c



1. Install Database.
2. Run RCU for oid, OAM,OBIEE
3. Install OID, OAM, OBIEE12c,OHS12(webgates comes alongwith).
4. Configuration. I will write the steps.



-rwxr-x---. 1 oracle oinstall 3032 Aug 17  2017 deployWebGateInstance.sh
oracle@suthakar$./deployWebGateInstance.sh -w $OHS_MASTER_CONFIG -oh $ORACLE_HOME
Copying files from WebGate Oracle Home to WebGate Instancedir
oracle@suthakar$export LD_LIBRARY_PATH=$ORACLE_HOME/lib
oracle@suthakar$pwd
/apps6/oracle/product/obi12c/ohs/webgate/ohs/tools/deployWebGate
oracle@suthakar$cd ..
oracle@suthakar$ls
deployWebGate  openssl  setup  t2p
oracle@suthakar$pwd
/apps6/oracle/product/obi12c/ohs/webgate/ohs/tools
oracle@suthakar$cd setup
oracle@suthakar$ls
InstallTools
oracle@suthakar$cd *
oracle@suthakar$ls
apache_webgate.template  EditHttpConf
oracle@suthakar$ls ltr
ls: cannot access ltr: No such file or directory
oracle@suthakar$ls -lttr
total 2452
-rwxr-x---. 1 oracle oinstall 2502685 Aug 17  2017 EditHttpConf
-rw-r-----. 1 oracle oinstall    2053 Aug 17  2017 apache_webgate.template
oracle@suthakar$export LD_LIBRARY_PATH=$ORACLE_HOME/lib
oracle@suthakar$./EditHttpConf -w $OHS_MASTER_CONFIG -oh $ORACLE_HOME -o Edithttpconf.log
The web server configuration file was successfully updated
/apps6/oracle/product/obi12c/ohs/user_projects/domains/ohs_domain/config/fmwconfig/components/OHS/instances/ohs1/httpd.conf has been backed up as /apps6/oracle/product/obi12c/ohs/user_projects/domains/ohs_domain/config/fmwconfig/components/OHS/instances/ohs1/httpd.conf.ORIG

Friday, May 4, 2018

Virtual Guest Additions on linux 6.9


I had a problem with virtual Guest Addition on oracle linux 6.9 . After I followed the steps it works fine to me.

# yum update
# yum install gcc
# yum install kernel-uek-devel

Thursday, May 3, 2018

ORA-65096

SQL> create user test identified by oracle;
create user test identified by oracle
            *
ERROR at line 1:
ORA-65096: invalid common user or role name

SQL> alter session set "_ORACLE_SCRIPT"=true;
Session altered.
SQL> create user test identified by test;
User created.
SQL> drop user test;
User dropped.