Feed aggregator

Getting Started With Git On Oracle Cloud

OTN TechBlog - 8 hours 50 min ago

The new and improved Oracle Marketplace is now available from within the Oracle Cloud Infrastructure console.  The marketplace contains several applications that developers commonly use in their projects; things like source control, bug tracking and CI/CD applications - with more being added all the time.  The best part about the marketplace is that it gives you the ability to launch instances running these tools with one click.  Let's take a look at how to launch one of these instances using something that nearly every software project uses - source control.  More specifically, the current most popular source control system: Git.

To get started with git, head to your Oracle Cloud console and select Marketplace from the left sidebar menu:

From the Marketplace, select 'GitLab CE Certified by Bitnami':

On the following page, click 'Launch Instance':

Choose the image and compartment, review and accept the terms, then click 'Launch Instance':

The next page should look familiar to you if you have previously launched an instance on Oracle Cloud.  Enter your instance name, choose your options related to the instance shape and make necessary networking selections.  Be sure to upload an SSH key, we'll need it later on.  When you're satisfied, click 'Create':

You'll be taken next to the instance details page while the instance is provisioned.  

While the instance provisions, double check that the subnet you have chosen has the proper security and route table rules to allow the instance to be web accessible.  From the sidebar, select 'Networking' then 'Virtual Cloud Networks':

From the Virtual Cloud Networks landing page, select the VCN you chose when creating the network, then from the following page locate the subnet that you chose.  Here you'll be able to navigate directly to the proper rules that you will need to verify or create:

First verify (or create) a route table rule that targets your internet gateway for all incoming traffic:

Then make sure the security list allows ports 80 and 443 for all incoming traffic (please ensure that this subnet is not associated with any instances that you do not want to expose to the web):

By now your GitLab instance should be fully provisioned.  Head to the instance details page (Compute -> Instances in the left sidebar) and view the details for your GitLab instance.  Take note of the public IP address:

Click on 'Console Connections' in the left menu, then 'Create Console Connection' and populate the dialog with the SSH key you used when creating the instance and click 'Create Console Connection':

Now you should be able to hit your running GitLab administrator via your browser at http://<public ip>:

The default username is 'root'.  To find your initial password, SSH into the instance using the following command:

ssh bitnami@<public ip> -i /path/to/ssh_key

The initial password is stored in a file called 'bitnami_credentials'. To view it:

cat ./bitnami_credentials

Which will look similar to:

Log in and get started working with GitLab on Oracle Cloud!

ACE Program Members Deliver Sessions at Collaborate 2019 in San Antonio

OTN TechBlog - 8 hours 51 min ago

A small army of experts will present more than 1000 sessions at Collaborate 2019, April 7-11, 2019 in San Antonio, TX, (the home of the historic Alamo). As the list below shows, members of the Oracle ACE Program are well represented among those delivering sessions. Each of the listed session titles links to specific time, date, and location information. That should help as you're putting together your agenda for the event.

Collaborate 2019
April 7-11, 2019
Henry B. González Convention Center
San Antonio, TX USA
Information

Presenter Session Date

Oracle ACE Ahmed Aboulnaga
Ahmed Aboulnaga

Extract Partial Data from ASO Cube of Oracle Planning and Budgeting Cloud in a Readable Format 4/10/2019

Oracle ACE Ahmed Alomari
Ahmed Alomari

Taming the OACore JVM 4/10/2019 Applications Database Tuning Panel 4/8/2019

Oracle ACE Director Biju Thomas
Biju Thomas

Let's talk AI, ML, and DL 4/8/2019 Practical Usage of ORAchk and DBSAT for E-Business Suite Applications 4/9/2019 Eighteen (18) Database New Features you must See (c) 4/11/2019

Oracle ACE Bill Dunham
Bill Dunham

Workshop: EBS Upgrades StreetSmarts: A Guide to Executing Oracle EBS 12.2.x Upgrades 4/7/2019 To Cloud or Not to Cloud: That is the Question! 4/8/2019 OAUG Customizations & Alternatives Special Interest Group 4/9/2019 R12.2 Happy Hour - San Antonio Style! 4/9/2019 Flying Right Through the Clouds: Lifting and Shifting Oracle EBS On-Premise to MS Azure Cloud 4/10/2019 Let the Excitement Continue: Meet the New & Modern 12.2 EBS! 4/11/2019

Oracle ACE Chris Couture
Chris Couture

Developing a Cohesive User Experience 4/9/2019 What's Possible with PeopleSoft Chatbots 4/10/2019

Oracle ACE Director Dan Vlamis
Dan Vlamis

Getting from Answers/Dashboards to Data Visualization 4/9/2019 Smart Targeting Consumers: DX Marketing's Autonomous Data Warehousing Future 4/9/2019 Modern Machine Learning with Oracle Analytics Cloud and Autonomous Data Warehouse Cloud 4/10/2019

Oracle ACE Associate Dayalan Punniyamoorthy
Dayalan Punniyamoorthy

Extract “Partial Data” from ASO Cube of Oracle Planning and Budgeting Cloud in a Readable Format 4/7/2019

Oracle ACE Director Francis Mignault
Francis Mignault

What Every DBA Needs to Know About Oracle Application Express 4/8/2019 Oracle Forms and Oracle Application Express: The Odd Couple 4/10/2019 Worlds Collide! APEX and Digital Assistants Revolutionize Your ERP Applications 4/11/2019

Oracle ACE Associate Fred Denis
Fred Denis

Lessons Learned in Exadata Patching (Including 18c and in the Cloud) 4/8/2019 Must-Have Free Scripts When Working With Exadata / GI / ASM / opatch 4/9/2019

Oracle ACE Ilmar Kerm
Ilmar Kerm

Oracle Database Infrastructure as Code with Ansible 4/8/2019 Implementing Incremental Forever Strategy for Oracle Database Backups 4/9/2019

Oracle ACE Director Martin Klier
Martin Klier

YOUR Machine and MY Database - A Performing Relationship!? (2019 edition 4/10/2019 Oracle Core: Database I/O 4/10/2019

Oracle ACE Michael Barone
Michael Barone

OAUG: E-Business Suite Security SIG -- On-Premise and Cloud Security 4/11/2019

Oracle ACE Michael Messina
Michael Messina

MySQL 8 New Features, Updates and Changes 4/9/2019 MySQL Database Security 4/10/2019 The Oracle Database Security Assessment Tool: Know Your Security Risks 4/10/2019 Oracle Database Sharding - Architecture and Concepts 4/10/2019

Oracle ACE Director Osama Mustafa
Osama Mustafa

Best Practices for Virtualizing Oracle RAC with VMware Cloud on AWS 4/8/2019 Using Python With Oracle Database 4/9/2019

Oracle ACE Roger Cornejo
Roger Cornejo

Scale-Up Your Use of the Advisor Framework 4/8/2019 Using the Dynamic Oracle Performance Analytics Framework 4/10/2019

Oracle ACE Director Susan Behn
Susan Behn

Data Security-Wizarding with EBS Security Wizards 4/7/2019 OAF Personalization’s 2019 - Quick Innovation Wins 4/8/2019 Enforcing Business Rules With Approvals Management (AME) in OM, GL, PO, AP and User Management 4/9/2019 Role Based Access Controls – Side by Side Comparison of EBS and Cloud 4/9/2019 RBAC Training - Automated processes for new users and roles with approval processes in AME 4/10/2019

Oracle ACE Tim Warnet
Tim Warner

Closing the Workforce Management Circle – Using PaaS to Extend SaaS 4/10/2019   Other Events Featuring Oracle ACEs

 

About the Oracle ACE Program Recognized for their technical expertise, Oracle ACEs contribute knowledge with articles, technical advice, blog posts, presentations, and tweets. Join the community and learn from their insights and experience. Learn more.

Partitioning -- 14 : Converting a non-Partitioned Table to a Partitioned Table

Hemant K Chitale - 11 hours 38 min ago
Pre-12cRelease2, there were only three methods to convert a non-Partitioned Table to a Partitioned Table

(a) Create a new, empty, Partitioned Table and copy (using INSERT .... AS SELECT ... ) all the data from the non-Partitioned Table to the new, Partitioned Table (and subsequently rename the new Partitioned Table after renaming or dropping the old non-Partitioned Table)

(b) Create a new, empty, Partitioned Table and use EXCHANGE PARTITION to switch the non-Partitioned Table into the Partitioned Table (and then run subsequent SPLIT PARTITION or ADD PARTITION commands as needed to create the additional Partitions)

(c) Create an interim Partitioned Table and use DBMS_REDEFINITION to do an online copy of the data to the interim Partitioned Table and automatically switch the name at the end


12.2 introduced the ability to use ALTER TABLE  ... MODIFY PARTITION ... to convert a non-Partitioned Table to a Partitioned Table

I start with a non-Partitioned Table :

SQL> select table_name, partitioned
2 from user_tables
3 where table_name = 'SALES_DATA_NONPARTITIONED'
4 /

TABLE_NAME PAR
------------------------------ ---
SALES_DATA_NONPARTITIONED NO

SQL> select index_name, uniqueness, partitioned
2 from user_indexes
3 where table_name = 'SALES_DATA_NONPARTITIONED'
4 /

INDEX_NAME UNIQUENES PAR
------------------------------ --------- ---
SALES_DATA_UK UNIQUE NO

SQL>


I then convert it to a Range-Partitioned Table.

SQL> alter table sales_data_nonpartitioned
2 modify
3 partition by range (sale_date)
4 (
5 partition P_2015 values less than (to_date('01-JAN-2016','DD-MON-YYYY')),
6 partition P_2016 values less than (to_date('01-JAN-2017','DD-MON-YYYY')),
7 partition P_2017 values less than (to_date('01-JAN-2018','DD-MON-YYYY')),
8 partition P_2018 values less than (to_date('01-JAN-2019','DD-MON-YYYY')),
9 partition P_2019 values less than (to_date('01-JAN-2020','DD-MON-YYYY')),
10 partition p_MAXVALUE values less than (MAXVALUE)
11 )
12 online
13 update indexes
14 /

Table altered.

SQL>
SQL> alter table sales_data_nonpartitioned rename to sales_data;

Table altered.

SQL>
SQL> select partition_name, high_value
2 from user_tab_partitions
3 where table_name = 'SALES_DATA'
4 order by partition_position
5 /

PARTITION_NAME HIGH_VALUE
---------------- --------------------------
P_2015 TO_DATE(' 2016-01-01 00:00
P_2016 TO_DATE(' 2017-01-01 00:00
P_2017 TO_DATE(' 2018-01-01 00:00
P_2018 TO_DATE(' 2019-01-01 00:00
P_2019 TO_DATE(' 2020-01-01 00:00
P_MAXVALUE MAXVALUE

6 rows selected.

SQL>
SQL> select index_name, partitioned, uniqueness, status
2 from user_indexes
3 where table_name = 'SALES_DATA'
4 /

INDEX_NAME PAR UNIQUENES STATUS
------------------------------ --- --------- --------
SALES_DATA_UK NO UNIQUE VALID

SQL>


The SALES_DATA_NONPARTITIONED was converted to a Range Partitioned Table.  If I didn't have to rename the table (e.g. if the table name was actually, properly SALES_DATA only), then there would be no need to lock the table as the RENAME command does.



Categories: DBA Blogs

Independant Review of What is Oracle GoldenGate

VitalSoftTech - 12 hours 25 min ago
Golden Gate in Oracle provides continuous and reliable access to real time routing, capturing, transforming and delivering of transactional data.
Categories: DBA Blogs

Your Invitation to Meet the EBS Applications Technology Product Management Team at Collaborate 2019

Steven Chan - 13 hours 17 min ago

You are cordially invited to join the Oracle E-Business Suite Applications Technology Product Management Team for informal discussions (and refreshments) at Collaborate 2019. This special meet and greet is not part of the regular conference routine, and offers you a chance to have a short break from the schedule to talk to us on a one-to-one basis.

EBS Applications Technology Product Management Team at Collaborate 2019

This meet and greet offers a unique opportunity for you to sit down and chat with Oracle Product Management experts about the latest EBS technology and features that you may be using or intend to use. We would love the opportunity to discuss with you your upcoming projects, or answer your questions regarding such topics as integration, cloning, online patching, performance, security, advanced architectures, upgrades, and migrations to Oracle Cloud infrastructure.

About the Conference

Collaborate 2019 offers an excellent opportunity for you to attend sessions and talk with various members of the Oracle team to get latest information about new features with Oracle E-Business Suite technology. This year's conference will be held at the Henry B. González Convention Center in San Antonio, Texas April 7 to 11, 2019.  For a complete listing of all educational sessions and other activities, please visit the OAUG Collaborate website.

Related Conference Material Related Articles
Categories: APPS Blogs

Adding an item to the Ubuntu Unity Launcher

The Anti-Kyte - Sun, 2019-03-24 17:20

I would begin this post by saying something pithy about the latest Brexit crisis gripping the nation. However, watching any news or current affairs program at the moment leaves me feeling rather like this :

Fortunately, I had a new version of SQLDeveloper to install on my Ubuntu 16.04 laptop to take my mind off things.
After installing the software, I forgot – as I almost always do – how to add a new item to the Unity Launcher, so I thought I’d write down the steps this time.

Unity is similar to Gnome, KDE and – as it turns out – XFCE in that it seems to follow the freedesktop.org Desktop Entry Specification.
So, all I need to do is :

  • create a .desktop file in a suitable location to tell Unity how to run SQLDeveloper
  • add it to the Unity Launcher
Creating the desktop file

The desktop files in this Ubuntu version are in /usr/share/applications so…

sudo nano /usr/share/applications/sqldeveloper184.desktop

The file itself, looks like this

[Desktop Entry]
Name=SQLDeveloper 18.4
Exec=/opt/sqldeveloper184/sqldeveloper/sqldeveloper.sh
Icon=/opt/sqldeveloper184/sqldeveloper/icon.png
Type=Application
Categories=Utility;Development;IDE;

It’s probably worth briefly covering some of the entries in the file…

In Unity, the Name is the string which appears in the tooltip on the Launcher.
Exec is the fully qualified path of the command to run for this menu item.
Type is mandatory and must be one of Application, Link, or Directory.
Categories are optional but may be relevant if you are using a desktop which offers access to applications via a menu.

Now we’ve created the file, we need to add it to the Launcher.

In Unity, the Name is the string which appears in the tooltip on the Launcher.
Exec is the fully qualified path of the command to run for this menu item.
Type is mandatory and must be one of Application, Link, or Directory.
Categories are optional but may be relevant if you are using a desktop which offers access to applications via a menu.

Now we’ve created the file, we need to add it to the Launcher.

Adding the application to the launcher

The easiest way to do this, is to simply open the directory where the file is located in the File Manager…

nautilus /usr/share/applications

Sorting the files by Modified date (latest first), I can easily find my new file :

Then, I just need to drag it over to the Launcher…

Useful Links

As is so often the case, this sort of thing is easy when you know how…or when someone is kind enough to tell you. So…

Playing with ACFS

Michael Dinh - Sun, 2019-03-24 11:50

Kernel version is 4.1.12-94.3.9.el7uek.x86_64 vs ACFS-9325: Driver OS kernel version = 4.1.12-32.el7uek.x86_64 because kernel was upgraded and ACFS has not been reconfigured after kernel upgrade.

[root@racnode-dc1-1 ~]# uname -r
4.1.12-94.3.9.el7uek.x86_64

[root@racnode-dc1-1 ~]# lsmod | grep oracle
oracleacfs           3719168  2
oracleadvm            606208  7
oracleoks             516096  2 oracleacfs,oracleadvm
oracleasm              57344  1

[root@racnode-dc1-1 ~]# modinfo oracleoks
filename:       /lib/modules/4.1.12-94.3.9.el7uek.x86_64/weak-updates/usm/oracleoks.ko
author:         Oracle Corporation
license:        Proprietary
srcversion:     3B8116031A3907D0FFFC8E1
depends:
vermagic:       4.1.12-32.el7uek.x86_64 SMP mod_unload modversions
signer:         Oracle Linux Kernel Module Signing Key
sig_key:        2B:B3:52:41:29:69:A3:65:3F:0E:B6:02:17:63:40:8E:BB:9B:B5:AB
sig_hashalgo:   sha512

[root@racnode-dc1-1 ~]# acfsdriverstate version
ACFS-9325:     Driver OS kernel version = 4.1.12-32.el7uek.x86_64(x86_64).
ACFS-9326:     Driver Oracle version = 181010.

[root@racnode-dc1-1 ~]# acfsdriverstate installed
ACFS-9203: true

[root@racnode-dc1-1 ~]# acfsdriverstate supported
ACFS-9200: Supported

[root@racnode-dc1-1 ~]# acfsroot version_check
ACFS-9316: Valid ADVM/ACFS distribution media detected at: '/u01/app/12.1.0.1/grid/usm/install/Oracle/EL7UEK/x86_64/4.1.12/4.1.12-x86_64/bin'

[root@racnode-dc1-1 ~]# crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.1.0.2.0]

[root@racnode-dc1-1 ~]# acfsutil registry
Mount Object:
  Device: /dev/asm/acfs_vol-256
  Mount Point: /ggdata02
  Disk Group: DATA
  Volume: ACFS_VOL
  Options: none
  Nodes: all
[root@racnode-dc1-1 ~]#
Gather ACFS Volume Info:

[oracle@racnode-dc1-1 ~]$ asmcmd volinfo –all

Diskgroup Name: DATA

         Volume Name: ACFS_VOL
         Volume Device: /dev/asm/acfs_vol-256
         State: ENABLED
         Size (MB): 10240
         Resize Unit (MB): 512
         Redundancy: UNPROT
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /ggdata02
Gather ACFS info using resource name:

[oracle@racnode-dc1-1 ~]$ crsctl stat res ora.drivers.acfs -init

NAME=ora.drivers.acfs
TYPE=ora.drivers.acfs.type
TARGET=ONLINE
STATE=ONLINE on racnode-dc1-1

From (asmcmd volinfo –all): Diskgroup Name: DATA 

[oracle@racnode-dc1-1 ~]$ crsctl stat res ora.DATA.dg -t

--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       racnode-dc1-1            STABLE
               ONLINE  ONLINE       racnode-dc1-2            STABLE
--------------------------------------------------------------------------------

From (asmcmd volinfo –all): Diskgroup Name: DATA and Volume Name: ACFS_VOL

[oracle@racnode-dc1-1 ~]$ crsctl stat res ora.DATA.ACFS_VOL.advm -t

--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.ACFS_VOL.advm
               ONLINE  ONLINE       racnode-dc1-1            Volume device /dev/asm/acfs_vol-256 
                                                             is online,STABLE
               ONLINE  ONLINE       racnode-dc1-2            Volume device /dev/asm/acfs_vol-256 
                                                             is online,STABLE
--------------------------------------------------------------------------------

[oracle@racnode-dc1-1 ~]$ crsctl stat res ora.DATA.ACFS_VOL.acfs -t

--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.data.acfs_vol.acfs
               ONLINE  ONLINE       racnode-dc1-1            mounted on /ggdata02,STABLE
               ONLINE  ONLINE       racnode-dc1-2            mounted on /ggdata02,STABLE
--------------------------------------------------------------------------------
Gather ACFS info using resource type:

[oracle@racnode-dc1-1 ~]$ crsctl stat res -t -w ‘TYPE = ora.volume.type’

--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.ACFS_VOL.advm
               ONLINE  ONLINE       racnode-dc1-1            Volume device /dev/asm/acfs_vol-256 
			                                                 is online,STABLE
               ONLINE  ONLINE       racnode-dc1-2            Volume device /dev/asm/acfs_vol-256 
			                                                 is online,STABLE
--------------------------------------------------------------------------------

[oracle@racnode-dc1-1 ~]$ crsctl stat res -t -w ‘TYPE = ora.acfs.type’

--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.data.acfs_vol.acfs
               ONLINE  ONLINE       racnode-dc1-1            mounted on /ggdata02,STABLE
               ONLINE  ONLINE       racnode-dc1-2            mounted on /ggdata02,STABLE
--------------------------------------------------------------------------------

[oracle@racnode-dc1-1 ~]$ crsctl stat res -t -w ‘TYPE = ora.diskgroup.type’

--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE racnode-dc1-1 STABLE
ONLINE ONLINE racnode-dc1-2 STABLE
ora.DATA.dg
ONLINE ONLINE racnode-dc1-1 STABLE
ONLINE ONLINE racnode-dc1-2 STABLE
ora.FRA.dg
ONLINE ONLINE racnode-dc1-1 STABLE
ONLINE ONLINE racnode-dc1-2 STABLE
--------------------------------------------------------------------------------

Python Practice Produced Pretty Pictures

Bobby Durrett's DBA Blog - Sat, 2019-03-23 18:57

I wrote a Python program that made some fun pictures so I thought I would share them even though this is not really a database post.

I practice Python programming by doing Rosetta Code programming tasks that no one has implemented in Python. This is a fun way of keeping up my Python skills. My most recent contribution made pretty pictures so I thought I would show them here. The code takes a cube and breaks up the faces into smaller and smaller pieces that change the cube into a rounder shape.

Here is the input:

Input to the program, a cube

Here is the output after one subdivision:

After one subdivision. Chunky.

Here is the output after two subdivisions:

Two subdivisions. Pretty round.

Note that it is getting rounder. Lastly, after four subdivisions it is remarkably round considering that it started as a cube:

Four subdivisions. Quite round.

The main point of this post was to show the pretty pictures. But, to be more serious, if someone is reading this blog and looking for a programming task to do for practice you can do what I do and find a Rosetta Code task for the language you are learning and you can get some good practice.

Bobby

Categories: DBA Blogs

Microsoft Azure: Adding user requires more work as expected

Dietrich Schroff - Sat, 2019-03-23 02:49
Just to try some things in Microsoft Azure i wanted to add an additional user to my test account. But this was not so easy:

Go to "Azure Active Directory" and "Users":

 

 But then:

I thought this is not really a problem, because openesb.eu is my domain, so let's try to verify this one:


The problem is, that i am not able to change this settings. So i tried, if i am lucky, but:
So only way to add users in such a minimal setup, is to add accounts from live.com etc..

Migration of a very large warehouse database

Tom Kyte - Fri, 2019-03-22 13:46
This question is more of a solicitation for advice than an actual question. I've been tasked with migrating a large warehouse database from one set of hardware in one datacenter to a new set of hardware in a different datacenter. Excluding temp, ...
Categories: DBA Blogs

How to show special/unseen characters from a column in a plsql ?

Tom Kyte - Fri, 2019-03-22 13:46
Hi Tom, I have a table with special characters in a column. The column values are like this with the plsql below. <code>set serveroutput on; declare c varchar2 (100); a number; begin for i in ( select ekd0756_cur...
Categories: DBA Blogs

how to copy chrome bookmarks from one computer to another

Matt Penny - Fri, 2019-03-22 12:20

copy "C:\Users\matty\AppData\Local\Google\Chrome\User Data\Default\Bookmarks"
"\sh00001\c$\Users\matty\AppData\Local\Google\Chrome\User Data\Default" -verbose

Categories: DBA Blogs

Stats advisor

Jonathan Lewis - Fri, 2019-03-22 08:10

This is just a little shout-out about the Stats Advisor – if you decide to give it a go, what sort of things is it likely to tell you. The answer is in a dynamic performance view called v$stats_advisor_rules – which I’ve list below from an instance running 18.3.0.0.


SQL> set linesize 180
SQL> set trimspool on
SQL> set pagesize 40
SQL> column description format a75
SQL> column name format a32
SQL> break on rule_type duplicate skip 1
SQL> select * from v$stats_advisor_rules;

  RULE_ID NAME                             RULE_TYPE DESCRIPTION                                                                     CON_ID
---------- -------------------------------- --------- --------------------------------------------------------------------------- ----------
         0                                  SYSTEM                                                                                         0
         1 UseAutoJob                       SYSTEM    Use Auto Job for Statistics Collection                                               0
         2 CompleteAutoJob                  SYSTEM    Auto Statistics Gather Job should complete successfully                              0
         3 MaintainStatsHistory             SYSTEM    Maintain Statistics History                                                          0
         4 UseConcurrent                    SYSTEM    Use Concurrent preference for Statistics Collection                                  0
         5 UseDefaultPreference             SYSTEM    Use Default Preference for Stats Collection                                          0
         6 TurnOnSQLPlanDirective           SYSTEM    SQL Plan Directives should not be disabled                                           0

         7 AvoidSetProcedures               OPERATION Avoid Set Statistics Procedures                                                      0
         8 UseDefaultParams                 OPERATION Use Default Parameters in Statistics Collection Procedures                           0
         9 UseGatherSchemaStats             OPERATION Use gather_schema_stats procedure                                                    0
        10 AvoidInefficientStatsOprSeq      OPERATION Avoid inefficient statistics operation sequences                                     0

        11 AvoidUnnecessaryStatsCollection  OBJECT    Avoid unnecessary statistics collection                                              0
        12 AvoidStaleStats                  OBJECT    Avoid objects with stale or no statistics                                            0
        13 GatherStatsAfterBulkDML          OBJECT    Do not gather statistics right before bulk DML                                       0
        14 LockVolatileTable                OBJECT    Statistics for objects with volatile data should be locked                           0
        15 UnlockNonVolatileTable           OBJECT    Statistics for objects with non-volatile should not be locked                        0
        16 MaintainStatsConsistency         OBJECT    Statistics of dependent objects should be consistent                                 0
        17 AvoidDropRecreate                OBJECT    Avoid drop and recreate object seqauences                                            0
        18 UseIncremental                   OBJECT    Statistics should be maintained incrementally when it is beneficial                  0
        19 NotUseIncremental                OBJECT    Statistics should not be maintained incrementally when it is not beneficial          0
        20 AvoidOutOfRange                  OBJECT    Avoid Out of Range Histogram endpoints                                               0
        21 UseAutoDegree                    OBJECT    Use Auto Degree for statistics collection                                            0
        22 UseDefaultObjectPreference       OBJECT    Use Default Object Preference for statistics collection                              0
        23 AvoidAnalyzeTable                OBJECT    Avoid using analyze table commands for statistics collection                         0

24 rows selected.

As you can see the rules fall into three groups: system, operation, and object – and you can’t help noticing at all three levels how commonly the theme is: “just stick with the defaults!”.

As so often happens when I start writing a catch-up or “remind myself” not I found that Tim Hall has already written all about it.

When AWS SCT Unable to Connect to MySQL in RDS or EC2

Pakistan's First Oracle Blog - Fri, 2019-03-22 05:27
AWS Schema Conversion Tool (SCT) is one of the must tool for a successful migration of databases to AWS RDS.

If you are trying to connect to MySQL hosted on EC2 instance or RDS and unable to make the connection despite of setting the security groups correctly and making sure that port, hostname, username and password are right, then first check the log of SCT.




2019-03-22 19:40:16.866 [   1]     GENERAL INFO    global_settings:
    app_folder=AWS Schema Conversion Tool
    bucket-name=sct-cloud9-test
    console_log_folder=C:\Users\mirza\AWS Schema Conversion Tool\Log
    convert_without_statistic_reminder=false
    data_migration_settings=
    db2luw_driver_file=
    debug_mode=false
    ext_pack_version_alert=true
    facade_log_folder=C:\Users\mirza\AWS Schema Conversion Tool\Log
    file-system-thread-count=1
    forget-state=false
    greenplum_driver_file=
    install_dir=C:\Users\mirza
    log.max_file_size_mb=100
    log.max_files_count=20
    log_folder=C:\Users\mirza\AWS Schema Conversion Tool\Log
    log_folder_extractors=C:\Users\mirza\AWS Schema Conversion Tool\Extractor Log
    log_folder_extractors_ask_before_load=false
    log_folder_extractors_cassandra=C:\Users\mirza\AWS Schema Conversion Tool\Extractor Log\Cassandra
    maria_driver_file=
    message_level.CLONE_DATACENTER=INFO
    message_level.COMPARE_SCHEMA=INFO
    message_level.CONTROLLER=INFO
    message_level.GENERAL=INFO
    message_level.LOADER=INFO
    message_level.PARSER=INFO
    message_level.PRINTER=INFO
    message_level.RESOLVER=INFO
    message_level.TELEMETRY=INFO
    message_level.TRANSFORMER=INFO
    message_level.TYPEMAPPING=INFO
Caused by: com.amazon.sct.dbloader.DbLoaderHandledException: Connection wasn't established. Check connection properties.
at com.amazon.sct.dbloader.DbLoader.checkConnection(DbLoader.java:512)
at com.amazon.sct.dbloader.DbLoader.connect(DbLoader.java:349)
at com.amazon.sct.dbloader.DbLoaderContainer.checkAccessibility(DbLoaderContainer.java:25)
at com.amazon.sct.task.TestConnectionTask.call(TestConnectionTask.java:26)
at com.amazon.sct.task.TestConnectionTask.call(TestConnectionTask.java:12)
at javafx.concurrent.Task$TaskCallable.call(Task.java:1423)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
... 1 more

In this case, there are no errors about time out which commonly refers to security group configuration or any about the credential issue. Here the issue is not with SCT or any of AWS component, rather its about the user which you are using to connect to MySQL.

Create user MySQL as follows and try and it should work:

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';

GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';

Then first test connection using MySQL workbench and then try with SCT.

Hope it helps.

Categories: DBA Blogs

Intro: Initial Thoughts On Oracle Autonomous Database Cloud Services (Automatic For The People)

Richard Foote - Thu, 2019-03-21 22:37
I’m currently writing up a few blog pieces on indexing in the Oracle Autonomous Database environments, but I thought I’ll begin by introducing what exactly are Oracle Autonomous Database Cloud Services and some of my initial thoughts, as there’s still some confusion on all this. Introduced by Uncle Larry at Oracle OpenWorld 2017, Oracle Autonomous […]
Categories: DBA Blogs

ORA-02396: exceeded maximum idle time, please connect again

Tom Kyte - Thu, 2019-03-21 19:26
Dear Mr. Tom, i have an issue according the IDLE_TIME parameter.. I used to open more than one session to the database (different scheam's on same Database)... and our dba set IDLE_TIME as 15 minutes, and even if the session is not idle (i'm ...
Categories: DBA Blogs

truncating empty table generate ORA-02266:

Tom Kyte - Thu, 2019-03-21 19:26
Tom , why truncating empty table generates the error ORA-02266 ? SQL> select count(*) from t_data; COUNT(*) ---------- 0 SQL> truncate table t_data * ERROR at line 1: ORA-02266: unique/primary keys in t...
Categories: DBA Blogs

SQL query to find FK IDs with a series of values

Tom Kyte - Thu, 2019-03-21 19:26
we have below tables <code>create table bca(id number(2)); insert into bca(10); insert into bca(11); insert into bca(7); create TABLE abc( di NUMBER(2), fk_id NUMBER(3), yek VARCHAR2(20), elv VARCHAR(15...
Categories: DBA Blogs

JD Edwards EnterpriseOne 9.2—Why You Should Upgrade Now

Chris Warticki - Thu, 2019-03-21 12:29
Make This Your Last JD Edwards EnterpriseOne Upgrade 

If you’ve been considering an upgrade to JDE EnterpriseOne 9.2, but haven’t done so yet, you should plan to upgrade now.  There are a lot of exciting changes and new features that you can take advantage of once you upgrade.

  • Full Premier Support through at least 2030—rest assured that Oracle will protect your investment well into the next decade, and beyond.
  • Continuous AdoptionJDE EnterpriseOne 9.2 will be your last upgrade—but you will continue to receive new features and functionality that don't require more budgeting for expensive and time-consuming upgrades.
  • Continuous Delivery—choose only the features you want, when you want them.
  • JDE EnterpriseOne 9.2 is Cloud-ready—Optimize EnterpriseOne with Oracle’s IaaS, extend your solution via PaaS, or complement your solution with a SaaS offering.
  • Dynamic new product features—such as UX One, Personalization, Orchestrator, Citizen Developer Frameworks, and Mobility.

In June 2018, Oracle announced that Premier Support for EnterpriseOne 9.2 will be provided through at least 2030.  EnterpriseOne 9.2 will be the go-forward solution as Premier Support for World A9.4 ends in April 2022.  In preparation for this, Oracle has provided a direct migration path from JD Edwards World to JD Edwards EnterpriseOne.

For Oracle Support customers, Premier Support provides you with ongoing benefits:
  • Software updates
  • Security alerts and updates
  • Critical Patch Updates
  • Tax, Legal, and Regulatory Updates
  • Access to the My Oracle Support Knowledge Base
  • 24x7 assistance with service requests, and much more
Committed Through at Least 2030

Listen Lyle Ekdahl, SVP for JD Edwards, on JD Edwards’ Continuous Delivery Model.


Committed to Customers | Committed to Innovation | Committed to Products

 

Learn More

Hands-On Lab at Collaborate 2019

Steven Chan - Thu, 2019-03-21 11:15

If you are attending Collaborate 2019, don’t miss the opportunity to attend the latest of our popular hands-on lab sessions. This year's hands-on lab is titled Oracle E-Business Suite Cloud Manager: Deployment, Configuration and Review of EBS Lifecycle Management Capabilities and its key points are outlined in this article.

The hands-on lab serves as a practical introduction to Oracle E-Business Suite Cloud Manager. You will use a trial account to deploy Cloud Manager from an Oracle Cloud Infrastructure (OCI) Marketplace image; configure Cloud Manager; and use the One-Click Provisioning and Cloning features to create new environments.

In addition, the instructors will demonstrate the steps involved in performing a lift and shift of an on-premises EBS environment to OCI.

The hands-on lab will be held in the CC RIVER FL 007D room, and is scheduled to run for approximately two hours on the following dates and times:

Sunday, April 7, 1:45 PM – 4:00 PM

  • To register: 11382 (https://app.attendcollaborate.com/event/member/554040)

Monday, April 8, 3:15 PM – 5:30 PM

  • To register: 11383 (https://app.attendcollaborate.com/event/member/554041)

Note: As places at each session are strictly limited, we highly recommend that you register ahead of time at the indicated links to reserve your spot, and arrive at least 10 minutes early to claim your seat  - any unclaimed places will be released when the session begins.

Prerequisites and Skills

You will need:

  • Your own Windows laptop or Mac, with:
    • A modern browser such as Firefox, Google Chrome, or Safari
    • PuTTY (or equivalent)
  • Knowledge of:
    • Standard UNIX commands
    • PuTTY (or equivalent) usage

We look forward to seeing you at Collaborate 2019!

Related Articles References
Categories: APPS Blogs

Pages

Subscribe to Oracle FAQ aggregator