Last year Tim aka ‘ORACLE-BASE’ launched the the first OTN (Oracle Technology Network) Appreciation Day, after the success of last year this is being repeated again this year under the new moniker of ODC.
As today is Tuesday 10th October 2017 expect some great content from fellow Oracle ACE’s and Oracle community folk coming out throughout the day as the different timezones come online.
It’s my pleasure to contribute to this year’s ODC Appreciation Day (Oracle Developer Community) and my favourite reason feature is the Oracle 12c Online database move datafile feature.
This feature is great for fixing naming or directory structure errors, re-organising your database layout, adopting new standards or migrating between storage systems. It supports Oracle ASM and filesystems with the only restriction being you need to be on Oracle 12c, so upgrade it your still on Oracle 11gR2 and embrace online database move datafile.
The Open Group is pleased to announce the piloting of our Open Badge program for the professional certification programs. We are partnering with Acclaim, a division of Pearson VUE, an exam delivery company, to provide digital versions of our credentials. As a consequence, this means over the coming months, we will be issuing badges for all of The Open Group Certification Programs.
Earlier in the year at the excellent OUgf Finnish Oracle User Group Harmony 17 conference, I performed a Live demo where I refreshed an Oracle 12c database using an Ansible Playbook in just over a minute, 1min 16sec to be more precise.
Once I had completed my presentation Frits Hoogland mentioned that he had recently used and Blogged on Ansible-Sempahore , an Open Source alternative to Ansible Tower which provides a Web UI and API’s for launching Ansible Tasks.
In this Blog post I am going to share how I used Ansible-Semaphore to launch my Ansible playbook to perform an Oracle 12c database refresh with a single click.
Once I had Semaphore installed, I configure the Inventory, Environment, Key Store and Playbook Repositories and added my Task Templates all through the Semaphore UI, all pretty straight forward, so no need to screenshot it.
A powerful feature of Semaphore is it’s integration with GitHub, this ensures every time a Playbook is run the last version is used as the code is pulled back from the repository.
Running my ‘Oracle Database Clone’ Ansible playbook is as now as simple as clicking ‘run!’ (no Playbook or Environment Overrides are required for this playbook)
At the end of each run semaphore provides a Task Log which is retained and accessible from the dashboard for historic review.
There we have it a One-Click Oracle 12c Database refresh in just under 1 minute 15 seconds.
If you want to see more, check out my YouTube channel to watch a demo of the above.
TNSLSNR for Linux: Version 184.108.40.206.0 – Production
System parameter file is /u01/install/APPS/12.1.0/network/admin/EBSDB_apps/listener.ora
Log messages written to /u01/install/APPS/12.1.0/admin/EBSDB_apps/diag/tnslsnr/apps/ebsdb/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.example.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps.example.com)(PORT=1521)))
STATUS of the LISTENER
Version TNSLSNR for Linux: Version 220.127.116.11.0 – Production
Start Date 15-AUG-2017 07:42:19
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File /u01/install/APPS/12.1.0/network/admin/EBSDB_apps/listener.ora
Listener Log File /u01/install/APPS/12.1.0/admin/EBSDB_apps/diag/tnslsnr/apps/ebsdb/alert/log.xml
Listening Endpoints Summary…
Service “EBSDB” has 1 instance(s).
Instance “EBSDB”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/install/APPS/12.1.0/appsutil/log/EBSDB_apps/addlnctl.txt for more information …
You are running addbctl.sh version 120.1
Starting the database EBSDB …
SQL*Plus: Release 18.104.22.168.0 Production on Tue Aug 15 07:42:19 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1308625016 bytes
Database Buffers 822083584 bytes
Redo Buffers 13848576 bytes
Disconnected from Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
addbctl.sh: exiting with status 0
[oracle@apps scripts]$ ./startapps.sh
Starting the Oracle E-Business Suite Application Tier Services
You are running adstrtal.sh version 120.24.12020000.11
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_apps/logs/appl/admin/log/adstrtal.log for more information …
Before you can logon you will need to enable SYSADMIN and the Demo accounts, Oracle have provided scripts to do this e.g.
[oracle@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 : L7583909.log
Report filename : O7583909.out
[oracle@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 : L7583911.log
Oracle EBS R12 Dashboard
You should now be able to logon as ‘SYSADMIN’ or explore your Oracle EBS R12.2.6 VISION sandbox environment using the Demo users (see below) and the password defined above at: http://apps.example.com:8000/