Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Wednesday, November 22, 2017

ORA-19913: unable to decrypt backup

In Oracle Cloud or in 12c using secure backup you will encounter the below error while restore/recovery process..

ORA-19913: unable to decrypt backup

channel ORA_AUX_SBT_TAPE_1: restoring SPFILE
output file name=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/spfileERPPRDSTBY.ora
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2017 19:35:48
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-19849: error while reading backup piece from service erpprd
ORA-19913: unable to decrypt backup
ORA-19660: some files in the backup set could not be verified
ORA-19685: SPFILE could not be verified
ORA-19849: error while reading backup piece from service erpprd
ORA-19913: unable to decrypt backup



RMAN> show ENCRYPTION FOR DATABASE;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ERPPRD are:
CONFIGURE ENCRYPTION FOR DATABASE ON;

RMAN>


RMAN> show ENCRYPTION ALGORITHM;

RMAN configuration parameters for database with db_unique_name ERPPRD are:
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default


Fix:
Either  disable the encryption or set a password or use a wallet

Below I will set a password  for backup and use the same password for decryption.

RMAN>set encryption on identified by 'welcome1';
RMAN> backup database plus archivelog all;


During restore/recovery:

RMAN>set decryption password 'welcome1';
RMAN>restore database ...




Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE has been deprecated

In 12c using cuurent logfile is deprecated and if you issue the below command:

ALTER DATABASE RECOVER  managed standby database using current logfile disconnect

You will notice the below warning in the alert log file.

Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE has been deprecated




Instead of using the current log file, use below command.

SQL> alter database recover managed standby database disconnect nodelay;

Friday, November 3, 2017

Using dbaascli in - Oracle Cloud



[root@ERPDEV dbaascli]# ./dbaascli list
DBAAS CLI version 1.0.0


DBAAS>


Very Long Text, press q to quit
Available commands:
 cloud sync
 database bounce
 database changepassword
 database start
 database status
 database stop
 dataguard failover
 dataguard reinstate
 dataguard status
 dataguard switchover
 dbpatchm
 dv off
 dv off cdb
 dv off pdb
 dv on
 dv on cdb
 dv on pdb
 elogger list
 gg setup
 gg status
 glassfish start
 glassfish status
 glassfish stop
 listener bounce
 listener start
 listener status
 listener stop
 mrec
 netsec config
 netsec config encryption
 netsec config integrity
 netsec deconfig
 netsec deconfig encryption
 netsec deconfig integrity
 netsec status
 netsec status encryption
 netsec status integrity
 ore setup
 ore status
 orec
 sampleschema create
 sampleschema drop
 tde config
 tde deconfig
 tde rotate
 tde rotate masterkey
 tde status
 tfa install
 tfa uninstall





[root@ERPDEV dbaascli]# ./dbaascli list
DBAAS CLI version 1.0.0


DBAAS>
[root@ERPDEV dbaascli]# ./dbaascli database status
DBAAS CLI version 1.0.0
Executing command database status
Database Status:
Database is open
Database name: ERPDEV

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE    12.1.0.2.0      Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production


[root@ERPDEV dbaascli]# ./dbaascli database stop
DBAAS CLI version 1.0.0
Executing command database stop
Database stopped in immediate


[root@ERPDEV dbaascli]# ps -ef| grep smon
root     21779 19335  0 09:47 pts/0    00:00:00 grep smon



[root@ERPDEV dbaascli]# ./dbaascli database start
DBAAS CLI version 1.0.0
Executing command database start
Database started


[root@ERPDEV dbaascli]# ps -ef| grep smon
oracle   22231     1  0 09:48 ?        00:00:00 ora_smon_ERPDEV
oracle   22346     1  0 09:48 ?        00:00:00 /usr/bin/perl /var/opt/oracle/misc/dbcsmonitor.pl /var/opt/oracle/tfa/erpdev/tfa_home /var/opt/oracle/tfa/repository/suptools/erpdev/dbcsmon /var/opt/oracle/tfa/repository/suptools/erpdev/dbcsmon/oracle
root     22948 19335  0 09:49 pts/0    00:00:00 grep smon


[root@ERPDEV dbaascli]# ./dbaascli database status
DBAAS CLI version 1.0.0
Executing command database status
Database Status:
Database is open
Database name: ERPDEV

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE    12.1.0.2.0      Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production



[root@ERPDEV dbaascli]# ./dbaascli database bounce
DBAAS CLI version 1.0.0
Executing command database bounce
Database stopped in immediate
Database started


[root@ERPDEV dbaascli]# ./dbaascli database status
DBAAS CLI version 1.0.0
Executing command database status
Database Status:
Database is open
Database name: ERPDEV

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE    12.1.0.2.0      Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production



[root@ERPDEV dbaascli]# ./dbaascli listener status
DBAAS CLI version 1.0.0
Executing command listener status
Starting listener

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 02-NOV-2017 09:55:26

Copyright (c) 1991, 2017, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ERPDEV.compute-586447955.oraclecloud.internal)(PORT=1623)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                01-NOV-2017 11:26:55
Uptime                    0 days 22 hr. 28 min. 30 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ERPDEV/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ERPDEV.compute-586447955.oraclecloud.internal)(PORT=1623)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1623)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ERPDEV.compute-586447955.oraclecloud.internal)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/ERPDEV/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "ERPDEV.586447955.oraclecloud.internal" has 1 instance(s).
  Instance "ERPDEV", status READY, has 1 handler(s) for this service...
Service "ERPDEV.586447955.oraclecloud.internalXDB" has 1 instance(s).
  Instance "ERPDEV", status READY, has 1 handler(s) for this service...
Service "demos.586447955.oraclecloud.internal" has 1 instance(s).
  Instance "ERPDEV", status READY, has 1 handler(s) for this service...
Service "erpdevpdb1.586447955.oraclecloud.internal" has 1 instance(s).
  Instance "ERPDEV", status READY, has 1 handler(s) for this service...
The command completed successfully

[root@ERPDEV dbaascli]#


[root@ERPDEV dbaascli]# ./dbaascli netsec status
DBAAS CLI version 1.0.0
Executing command netsec status

Displaying configuration for network encryption:

server encryption status: [enabled]
type    = required
methods = AES256,AES192,AES128

client encryption status: [disabled]

Displaying configuration for network integrity:

server integrity status: [enabled]
checksum_level = required
methods        = SHA1

client integrity status: [disabled]





[root@ERPDEV dbaascli]# ./dbaascli  sampleschema create
DBAAS CLI version 1.0.0
Executing command sampleschema create
Enter SYSTEM password
Enter SYS password
Enter HR password
Enter OE password
Enter PM password
Enter IX password
Enter SH password
Enter BI password
Enter default tablespace users
Enter temporary tablespace temp
Log location /var/opt/oracle/log/sampleschema/



Tuesday, October 31, 2017

Oracle Cloud: Disk /dev/sdb doesn't contain a valid partition table

While adding the block volume in Oracle Cloud Compute Instance I was getting the below error.
Disk /dev/sdb doesn't contain a valid partition table

Fix:
I created the partition table as shown below and rebooted the Instance.


Create the block volume and attach it to the Compute Instance.











Run the iscsi commands to attach the volume.


shaikprod@shaikprod ~/.ssh
$ ssh -i id_rsa ubuntu@129.213.47.80
Welcome to Ubuntu 14.04.5 LTS (GNU/Linux 3.13.0-123-generic x86_64)


ubuntu@ebsprdapp01:~$
ubuntu@ebsprdapp01:~$ id
uid=1000(ubuntu) gid=1000(ubuntu) groups=1000(ubuntu),4(adm),20(dialout),24(cdrom),25(floppy),27(sudo),29(audio),30(dip),44(video),46(plugde

ubuntu@ebsprdapp01:~$ df -h
Filesystem      Size  Used Avail Use% Mounted on
udev            126G   12K  126G   1% /dev
tmpfs            26G  1.2M   26G   1% /run
/dev/sda1        46G  1.1G   43G   3% /
none            4.0K     0  4.0K   0% /sys/fs/cgroup
none            5.0M     0  5.0M   0% /run/lock
none            126G     0  126G   0% /run/shm
none            100M     0  100M   0% /run/user
/dev/sda15      105M  4.7M  100M   5% /boot/efi


ubuntu@ebsprdapp01:~$ sudo iscsiadm -m node -o new -T iqn.2015-12.com.oracleiaas:5b592336-8f01-4176-aea9-f9d9c6190ede -p 169.254.2.2:3260
sudo iscsiadm -m node -o update -T iqn.2015-12.com.oracleiaas:5b592336-8f01-4176-aea9-f9d9c6190ede -n node.startup -v automatic
sudo iscsiadm -m node -T iqn.2015-12.com.oracleiaas:5b592336-8f01-4176-aea9-f9d9c6190ede -p 169.254.2.2:3260 -l
New iSCSI node [tcp:[hw=,ip=,net_if=,iscsi_if=default] 169.254.2.2,3260,-1 iqn.2015-12.com.oracleiaas:5b592336-8f01-4176-aea9-f9d9c6190ede]

ubuntu@ebsprdapp01:~$ sudo iscsiadm -m node -o update -T iqn.2015-12.com.oracleiaas:5b592336-8f01-4176-aea9-f9d9c6190ede -n node.startup -v

ubuntu@ebsprdapp01:~$ sudo iscsiadm -m node -T iqn.2015-12.com.oracleiaas:5b592336-8f01-4176-aea9-f9d9c6190ede -p 169.254.2.2:3260 -l
Logging in to [iface: default, target: iqn.2015-12.com.oracleiaas:5b592336-8f01-4176-aea9-f9d9c6190ede, portal: 169.254.2.2,3260] (multiple)
Login to [iface: default, target: iqn.2015-12.com.oracleiaas:5b592336-8f01-4176-aea9-f9d9c6190ede, portal: 169.254.2.2,3260] successful.

ubuntu@ebsprdapp01:~$ df -h
Filesystem      Size  Used Avail Use% Mounted on
udev            126G   12K  126G   1% /dev
tmpfs            26G  1.2M   26G   1% /run
/dev/sda1        46G  1.1G   43G   3% /
none            4.0K     0  4.0K   0% /sys/fs/cgroup
none            5.0M     0  5.0M   0% /run/lock
none            126G     0  126G   0% /run/shm
none            100M     0  100M   0% /run/user
/dev/sda15      105M  4.7M  100M   5% /boot/efi

fdsik shows that the partition table is not created for the new disk
ubuntu@ebsprdapp01:~$ sudo fdisk -l

WARNING: GPT (GUID Partition Table) detected on '/dev/sda'! The util fdisk doesn't support GPT. Use GNU Parted.


Disk /dev/sda: 50.0 GB, 50010783744 bytes
256 heads, 63 sectors/track, 6056 cylinders, total 97677312 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 4096 bytes
I/O size (minimum/optimal): 4096 bytes / 4096 bytes
Disk identifier: 0x00000000

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1               1    97677311    48838655+  ee  GPT
Partition 1 does not start on physical sector boundary.

Disk /dev/sdb: 107.4 GB, 107374182400 bytes
255 heads, 63 sectors/track, 13054 cylinders, total 209715200 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 4096 bytes
I/O size (minimum/optimal): 4096 bytes / 4096 bytes
Disk identifier: 0x00000000

Disk /dev/sdb doesn't contain a valid partition table


Follow the below commands to create the partition table for the new block volume/disk

ubuntu@ebsprdapp01:~$ sudo 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 0xe8bf5c2e.
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)

The device presents a logical sector size that is smaller than
the physical sector size. Aligning to a physical sector (or optimal
I/O) size boundary is recommended, or performance may be impacted.

Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-209715199, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-209715199, default 209715199):
Using default value 209715199

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

Calling ioctl() to re-read partition table.
Syncing disks.

ubuntu@ebsprdapp01:~$ sudo mkfs.ext4 /dev/sdb1
mke2fs 1.42.9 (4-Feb-2014)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
6553600 inodes, 26214144 blocks
1310707 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
800 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
        32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
        4096000, 7962624, 11239424, 20480000, 23887872

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

ubuntu@ebsprdapp01:~$ sudo echo "/dev/sdb1 /data ext4  defaults,noatime,_netdev      0 0" >>  /etc/fstab

ubuntu@ebsprdapp01:~$ cat /etc/fstab| grep data

/dev/sdb1 /data ext4  defaults,noatime,_netdev      0 0


ubuntu@ebsprdapp01:~$ sudo reboot

Broadcast message from ubuntu@ebsprdapp01
        (/dev/pts/0) at 0:08 ...

The system is going down for reboot NOW!
ubuntu@ebsprdapp01:~$ Connection to 129.213.47.80 closed by remote host.
Connection to 129.213.47.80 closed.




shaikprod@shaikprod ~/.ssh

$ ssh -i id_rsa ubuntu@129.213.47.80
Welcome to Ubuntu 14.04.5 LTS (GNU/Linux 3.13.0-123-generic x86_64)


Last login: Tue Oct 31 23:57:21 2017 from ool-44c4f7aa.dyn.optonline.net
ubuntu@ebsprdapp01:~$ df -k
Filesystem     1K-blocks    Used Available Use% Mounted on
udev           131994172       4 131994168   1% /dev
tmpfs           26401656    1196  26400460   1% /run
/dev/sda1       47927164 1130876  44731784   3% /
none                   4       0         4   0% /sys/fs/cgroup
none                5120       0      5120   0% /run/lock
none           132008272       0 132008272   0% /run/shm
none              102400       0    102400   0% /run/user
/dev/sda15        106858    4737    102122   5% /boot/efi
/dev/sdb1      103080224   61044  97759968   1% /data


ubuntu@ebsprdapp01:/data$ sudo chown ubuntu:ubuntu /data
ubuntu@ebsprdapp01:/data$
ubuntu@ebsprdapp01:/data$
ubuntu@ebsprdapp01:/data$ touch abc
ubuntu@ebsprdapp01:/data$ ls -lrt
total 16
drwx------ 2 root   root   16384 Nov  1 00:06 lost+found
-rw-rw-r-- 1 ubuntu ubuntu     0 Nov  1 00:43 abc


ubuntu@ebsprdapp01:/data$ pwd
/data



Saturday, October 21, 2017

Create/ Provision Oracle E-Business Suite 12.2.6 on Oracle Cloud.



Below we will create and deploy Oracle  E-Business Suite 12.2.6 on Oracle Cloud in less than a hour.
1) Go to Compute Classic --> Instances --> Create Instance.



































It will take around 2-3hrs depending on the configuration/resources you picked during the provisioning.

Once the instance is created, it will show the status as "Running", note down the public IP address,














Create security lists and assign them to the instance for SSH, weblogic, Apps login, FORMS so on..

Below is a sample for SSH & console logins:




















Test the connectivity via SSH and configure the new EBS system:

Now login into the Ebusiness suite cloud instance as opc user:

Make sure serveraliveinterval is set to 100 or above:

shaikprod@shaikprod ~/.ssh
$ cat config
ServerAliveInterval 100



shaikprod@shaikprod ~/.ssh
$ ssh -i ~/.ssh/id_rsa opc@129.158.66.82

Oracle Linux Server release 6.7
Kernel \r on an \m

Authorized uses only. All activity may be monitored and reported.


set the PS1 as appropriate:
-bash-4.1$ vi .profile
-bash-4.1$ . ./.profile
ebs-dev-app01@opc:/home/opc>
ebs-dev-app01@opc:/home/opc>
ebs-dev-app01@opc:/home/opc>


set up the user equivalency between the app server and db server if needed.

users created on the system:
-bash-4.1$ cat /etc/passwd |egrep "oracle|root|applmgr"
root:x:0:0:root:/root:/bin/bash
operator:x:11:0:operator:/root:/sbin/nologin
oracle:x:54321:54321::/home/oracle:/bin/bash
applmgr:x:54322:54321::/home/applmgr:/bin/bash


None of the services have been started:

[oracle@c6c28e ~]$ ps -ef|grep oracle
root      3109  3082  0 23:28 pts/0    00:00:00 sudo su - oracle
root      3110  3109  0 23:28 pts/0    00:00:00 su - oracle
oracle    3111  3110  0 23:28 pts/0    00:00:00 -bash
oracle    3136  3111  0 23:29 pts/0    00:00:00 ps -ef
oracle    3137  3111  0 23:29 pts/0    00:00:00 grep oracle
[oracle@c6c28e ~]$ ps -ef|grep applmgr
oracle    3139  3111  0 23:29 pts/0    00:00:00 grep applmgr

root user:
-bash-4.1# id
uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)

filesystem details:


-bash-4.1# df -k
Filesystem     1K-blocks      Used Available Use% Mounted on
/dev/xvdb2      16247680   2569476  12833424  17% /
tmpfs            3830068         0   3830068   0% /dev/shm
/dev/xvdb1        194241    154048     25857  86% /boot
/dev/xvdb4     340468036 233032616  90117616  73% /u01

template log file:

-bash-4.1# cat /var/log/oraclevm-template.log
[INFO] Oct 21 22:28:10 updatehosts.sh: Updating hosts file with the current IP
[INFO] Oct 21 22:28:10 updatehosts.sh: Hosts  file update completed
[INFO] Oct 21 22:28:10 updatehosts.sh: /etc/sysconfig/network  file update completed
[LOG]  Oct 21 22:28:10 oraclevm-template: ==> 2017-10-21 22:28:10: oraclevm-template --config <==
[LOG]  Oct 21 22:28:10 oraclevm-template: Running oraclevm-template --config
[LOG]  Oct 21 22:28:10 oraclevm-template: Loading parameters from config file: /etc/sysconfig/oraclevm-template
[LOG]  Oct 21 22:28:10 oraclevm-template: Reconfiguring OS
[INFO] Oct 21 22:28:11 oraclevm-template: Regenerating SSH host keys.
[LOG]  Oct 21 22:28:11 oraclevm-template: calling /u01/install/scripts/configdhcp.sh
[INFO] Oct 21 22:28:12 configdhcp.sh: Configure the Machine with the Dynamic IP Address
[INFO] Oct 21 22:28:12 configdhcp.sh: Configuring network interface.
[INFO] Oct 21 22:28:12 configdhcp.sh:   Network device: eth0
[INFO] Oct 21 22:28:12 configdhcp.sh:   Hardware address: C6:B0:AE:95:57:8C
[LOG]  Oct 21 22:28:12 configdhcp.sh: Stopping network...
[INFO] Oct 21 22:28:12 configdhcp.sh: Configuring network settings.
[INFO] Oct 21 22:28:12 configdhcp.sh:   IP configuration: DHCP
[LOG]  Oct 21 22:28:12 configdhcp.sh: Starting network...
[INFO] Oct 21 22:28:44 configdhcp.sh: Network configuration changed successfully.

[LOG]  Oct 21 22:28:44 configdhcp.sh: Disabling firewall
[INFO] Oct 21 22:28:44 configdhcp.sh: Updating hosts file with the current IP
[INFO] Oct 21 22:28:44 configdhcp.sh: Hosts  file update completed
[INFO] Oct 21 22:28:44 configdhcp.sh: /etc/sysconfig/network  file update completed
[LOG]  Oct 21 22:28:54 oraclevm-template: ==> 2017-10-21 22:28:54: oraclevm-template --disable <==
[LOG]  Oct 21 22:28:54 oraclevm-template: Running oraclevm-template --disable
[LOG]  Oct 21 22:28:54 oraclevm-template: Changed RUN_TEMPLATE_CONF=NO in /etc/sysconfig/oraclevm-template
[INFO] Oct 21 22:28:54 oraclevm-template: Template configuration disabled.

Filesystem details:

[oracle@erp APPS]$ ls -lrt
total 44
drwxr-xr-x  4 oracle oinstall  4096 Sep 18 21:13 fs_ne
drwxr-xr-x  3 oracle oinstall 12288 Oct 22 03:06 data
drwxr-xr-x 78 oracle oinstall  4096 Oct 22 03:10 12.1.0
drwxr-xr-x  2 oracle oinstall  4096 Oct 22 03:12 scripts
drwxr-xr-x  5 oracle oinstall  4096 Oct 22 03:12 fs1
drwxr-xr-x  5 oracle oinstall  4096 Oct 22 03:45 fs2
-rw-r--r--  1 oracle oinstall  6469 Oct 22 04:06 EBSapps.env
drwxrwx---  7 oracle oinstall  4096 Oct 22 04:24 oraInventory


[oracle@erp APPS]$ hostname
erp


Set the run environment:

[oracle@erp APPS]$ source EBSapps.env run

  E-Business Suite Environment Information
  ----------------------------------------
  RUN File System           : /u01/install/APPS/fs1/EBSapps/appl
  PATCH File System         : /u01/install/APPS/fs2/EBSapps/appl
  Non-Editioned File System : /u01/install/APPS/fs_ne


  DB Host: erp.compute-586447955.oraclecloud.internal  Service/SID: EBSDB


  Sourcing the RUN File System ...

Change the E-Business suite account passwords:
============================================


[oracle@erp scripts]$ ./adstpall.sh -skipNM -skipAdmin

You are running adstpall.sh version 120.22.12020000.7


Enter the APPS username: apps

Enter the APPS password:
Enter the WebLogic Server password:

The logfile for this session is located at /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adstpall.log
Skipping Admin Server shutdown as option -skipAdmin is passed

Skipping Node Manager shutdown as option -skipNM is passed


Executing service control script:
/u01/install/APPS/fs1/inst/apps/EBSDB_erp/admin/scripts/adcmctl.sh stop
Timeout specified in context file: 1000 second(s)

script returned:
****************************************************

You are running adcmctl.sh version 120.19.12020000.7

Shutting down concurrent managers for EBSDB ...

****************************************************



Executing service control script:
/u01/install/APPS/fs1/inst/apps/EBSDB_erp/admin/scripts/adopmnctl.sh stop
Timeout specified in context file: 100 second(s)

script returned:
****************************************************

You are running adopmnctl.sh version 120.0.12020000.2

Stopping Oracle Process Manager (OPMN)  and the managed processes ...
opmnctl stopall: opmn is not running.

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adopmnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


adalnctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adalnctl.txt for more information ...


.end std out.

.end err out.

****************************************************



All enabled services on this node are stopped.

adstpall.sh:Exiting with status 0

adstpall.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adstpall.log for more information ...

[oracle@erp scripts]$

Connecting to t3://erp.compute-586447955.oraclecloud.internal:7001 with userid weblogic ...
Successfully connected to Admin Server 'AdminServer' that belongs to domain 'EBS_domain_EBSDB'



[oracle@erp scripts]$ perl /u01/install/APPS/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword

Program: txkUpdateEBSDomain.pl started at Sun Oct 22 10:17:54 2017

AdminServer will be re started after changing WebLogic Admin Password
All Mid Tier services should be SHUTDOWN before changing WebLogic Admin Password
Confirm if all Mid Tier services are in SHUTDOWN state. Enter "Yes" to proceed or anything else to exit: yes

Enter the full path of Applications Context File [DEFAULT - /u01/install/APPS/fs1/inst/apps/EBSDB_erp/appl/admin/EBSDB_erp.xml]:
Enter the WLS Admin Password:
Enter the new WLS Admin Password:
Enter the APPS user password:

Executing: /u01/install/APPS/fs1/FMW_Home/webtier/perl/bin/perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl  ebs-get-serverstatus -contextfile=/u01/install/APPS/fs1/inst/apps/EBSDB_erp/appl/admin/EBSDB_erp.xml -servername=AdminServer -promptmsg=hide -logfile=/u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/rgf/TXK/txkUpdateEBSDomain_Sun_Oct_22_10_17_54_2017/EBSProvisioner.log

Updating Weblogic Domain in online mode
---------------------------------------
Backup Location : /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/rgf/TXK/txkUpdateEBSDomain_Sun_Oct_22_10_17_54_2017
Logfile Location: /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/rgf/TXK/txkUpdateEBSDomain_Sun_Oct_22_10_17_54_2017/updateAdminPassword.log

Executing: /u01/install/APPS/fs1/EBSapps/comn/util/jdk32/jre/bin/java -classpath :/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/install/APPS/fs1/FMW_Home/Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/APPS/fs1/EBSapps/comn/java/classes:/u01/install/APPS/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/install/APPS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar oracle.apps.ad.util.UpdateEBSDomain updateAdminPassword  -contextfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/appl/admin/EBSDB_erp.xml -promptmsg hide -logdir /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/rgf/TXK/txkUpdateEBSDomain_Sun_Oct_22_10_17_54_2017 -logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/rgf/TXK/txkUpdateEBSDomain_Sun_Oct_22_10_17_54_2017/updateAdminPassword.log


Domain updated successfully
Restarting AdminServer with new Admin Password.

You are running adadminsrvctl.sh version 120.10.12020000.10

Stopping WLS Admin Server...
Refer /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/install/APPS/fs1/FMW_Home/user_projects/domains/EBS_domain_EBSDB/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adadminsrvctl.txt for more information ...


You are running adnodemgrctl.sh version 120.11.12020000.12


NodeManager log is located at /u01/install/APPS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1

adnodemgrctl.sh: exiting with status 0

adnodemgrctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adnodemgrctl.txt for more information ...


You are running adadminsrvctl.sh version 120.10.12020000.10

Starting WLS Admin Server...
Refer /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/install/APPS/fs1/FMW_Home/user_projects/domains/EBS_domain_EBSDB/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adadminsrvctl.txt for more information ...


*************** IMPORTANT ****************
WebLogic Admin Password is changed.
Restart all application tier services using control scripts.
********************************************


Program: txkUpdateEBSDomain.pl completed at Sun Oct 22 10:21:32 2017
[oracle@erp scripts]$


Change E-Business Suite Passwords:

[oracle@erp scripts]$ sqlplus /nolog

SQL*Plus: Release 10.1.0.5.0 - Production on Sun Oct 22 10:32:09 2017

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn apps@ebsdb
Enter password:
Connected.
SQL> set linesize 1000
SQL> col comp_name for a40
SQL> select comp_name,version from dba_registry;

COMP_NAME                                VERSION
---------------------------------------- ------------------------------
Oracle Database Catalog Views            12.1.0.2.0
Oracle Database Packages and Types       12.1.0.2.0
Oracle Real Application Clusters         12.1.0.2.0
JServer JAVA Virtual Machine             12.1.0.2.0
Oracle XDK                               12.1.0.2.0
Oracle Database Java Packages            12.1.0.2.0
Oracle Machine Generated Data            12.1.0.2.0
Oracle XML Database                      12.1.0.2.0
Oracle Multimedia                        12.1.0.2.0
Spatial                                  12.1.0.2.0
OLAP Analytic Workspace                  12.1.0.2.0

COMP_NAME                                VERSION
---------------------------------------- ------------------------------
Oracle OLAP API                          12.1.0.2.0
OLAP Catalog                             11.2.0.4.0
Oracle Text                              12.1.0.2.0

14 rows selected.




SQL> select user_name,encrypted_user_password from fnd_user where encrypted_user_password !='INVALID';

USER_NAME
--------------------------------------------------------------------------------
ENCRYPTED_USER_PASSWORD
--------------------------------------------------------------------------------
GUEST
VGyiDXXXXXXXqzA2mfI=



Enable SYSADMIN Access:

[oracle@erp logs]$ /u01/install/APPS/scripts/enableSYSADMIN.sh

This script will let you set a new password for the SYSADMIN EBS Applications User,
the default password most likely was "sysadmin", so pick a different one now.

Enter new password for SYSADMIN:
 Re-enter password for SYSADMIN:
Changing password for SYSADMIN
Log filename : L7660120.log


Report filename : O7660120.out



[oracle@erp logs]$ /u01/install/APPS/scripts/enableDEMOusers.sh

Enter a new password for the EBS Applications Users, the default password
most likely was "welcome", so pick a different one now...

Enter new password for DEMO users:
 Re-enter password for DEMO users:
Setting password for DEMO users...
Log filename : L7660122.log


Report filename : O7660122.out
Log filename : L7660124.log


Report filename : O7660124.out
Log filename : L7660126.log


Verify that you can access the weblogic console/EBS Home Page:








Create public key for Oracle Cloud API access.



shaikprod@shaikprod ~
$ mkdir .oci

shaikprod@shaikprod ~

generate the private key

$ openssl genrsa -out ~/.oci/oci_api_key.pem 2048
Generating RSA private key, 2048 bit long modulus
..................+++
....................................+++
e is 65537 (0x10001)


generate public key:

shaikprod@shaikprod ~
$ openssl rsa -pubout -in ~/.oci/oci_api_key.pem -out ~/.oci/oci_api_key_public.pem
writing RSA key

add the keys into the user's profile.



Thursday, October 19, 2017

Create Oracle DB with High Availability on AWS RDS

We will create a Oracle DB in AWS RDS with Multiple Availability Zone feature for High Availability
















create Oracle DB on AWS RDS

Below we will create Oracle EE database on Amazon Cloud RDS Service.












Wednesday, October 18, 2017

Create DB Instance in Oracle Cloud


Go to the database options and follow the below instructions.








Create storage containers in Oracle cloud



Go to storage and click containers and follow the instructions.




Create compartments in Oracle cloud

To create compartments in Oracle Cloud, go to identity and create compartments.








Thursday, October 12, 2017

Create a Database on Oracle Cloud


Below I have chosen Enterprise Edition for the database.