Feed aggregator

Self full outer join with additional predicateds

Tom Kyte - Mon, 2017-01-16 11:06
Hi Tom, I was asked to create a query, counting the number of the columns with different names in 2 tables. Say in "Employees" and "Departments" we have DEPARTMENT_ID and MANAGER_ID columns with equal names, and the rest of the columns differs in na...
Categories: DBA Blogs

rouning inconsistency in oracle db

Tom Kyte - Mon, 2017-01-16 11:06
Hi Tom, We use the below rounding logic in our applications but unfortunately the first query was rounding incorrectly. This we can see only when this code was executed from the application. But when I execute it in sql*plus it giving me correct o...
Categories: DBA Blogs

Panda Retail Company Deploys Oracle to Optimize Operations and Support Business Transformation

Oracle Press Releases - Mon, 2017-01-16 11:00
Press Release
Panda Retail Company Deploys Oracle to Optimize Operations and Support Business Transformation Saudi Arabian Hypermarket, Supermarket and Convenience Store Chain Leverages Oracle Retail Solutions to Drive Performance

Redwood Shores Calif—Jan 16, 2017

Today, Oracle announced that Saudi Arabia’s largest supermarket retailer, The Panda Retail Company, has deployed the suite of Oracle Retail Merchandising, Oracle Retail Planning, Oracle Retail Supply Chain, and Oracle Retail Store Inventory Management to optimize core retail operations and underpin additional business diversity in line with its planned growth and customer centric strategy. The Panda Retail Company employs 25,000 people and operates more than 475 hypermarket, supermarket and convenience stores throughout Saudi Arabia, United Arab Emirates and Egypt.
 
The Oracle solutions enable Panda to surface salient insights to critical performance indicators including sales, margin, inventory, and supplier activities, and equip the business to make decisions that increase profitability and enhance the customer experience. This empowered organization drives the business with one single version of the truth across all lines of business, to enable better decision making, including achieving the right balance between item availability and inventory position.
 
“To achieve our corporate goals, planned transformation initiatives and customer centric strategy, we needed the right systems, processes, and people in place. Oracle is uniquely qualified to support our current and future business strategy with retail rich end to end capabilities and best in class technology,” said Fawaz Kilfaden, Director of Information Technology at Panda Retail Company. “Ultimately, the goal of the program is to enrich the customer experience, improve performance and enhance our business governance across the enterprise.”
 
Panda adopted a flexible implementation strategy for its complete suite of solutions, including Oracle Retail Merchandise Operations Management, Oracle Retail Merchandise Financial Planning, Oracle Retail Demand Forecasting, Retail Merchandising Analytics and Oracle Retail Store Inventory Management.  The Oracle solutions replace legacy in-house and outdated vendor solutions that limited data access and lacked the roadmap to meet changing retail trends.  Panda wanted to put in place a system that would account for all of its retail and enterprise operations, and would afford greater flexibility for growth and innovation.
 
“We are pleased to continue to be part of Panda’s vibrant business and innovation, as the company expands its international presence. By leveraging the full suite of Oracle Retail, Panda is achieving the benefits of deep retail and global grocery expertise across their operations. We owe a debt of gratitude to our customers and partners who continue to inform our roadmap and vision,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail.
 
Oracle Retail at NRF 2017
 
Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 15-17, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #2521. For more information check out: www.oracle.com/nrf2017
 
Contact Info
Matt Torres
Oracle
4155951584
matt.torres@oracle.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Matt Torres

  • 4155951584

HR Reporting

Dylan's BI Notes - Mon, 2017-01-16 10:05
HR is an important business function in any company.  It supports business growth.  It also satisfies the compliance requirements.  Reports are required for supporting the HR functions. Typical HR Reporting Requirements HR reports are surrounding the HR function:  Human Resource Planning, Recruitment and Selection, Orientation and Training, Performance Appraisal, Compensation and Benefit. They serves many […]
Categories: BI & Warehousing

Help Me Help You!

VitalSoftTech - Mon, 2017-01-16 09:45
Hello everyone, I hope the holidays went well for you, best of wishes from my family to yours! It is a new year and we all have new year resolutions! After years of creating blogs for you all, I have decided to turn it up a notch! As many of you already know, I am […]
Categories: DBA Blogs

The 5 Best Use Cases for HelloSign for Oracle Documents Cloud

WebCenter Team - Mon, 2017-01-16 09:00

Authored by: Sarah Gabot, Demand Generation Manager, HelloSign  

When people think about eSignatures, it can be tricky to think of the different ways they can be used. The truth is, most departments can benefit from easier online signing.

Coupled with Oracle Documents Cloud, HelloSign can be used for an endless number of business cases. We’ve listed the 5 best use cases for this product pairing. 

#1 Onboarding Employees
It’s the norm for a new employee to receive a stack of papers on their first day of work. It can get really tedious to get through all the basic onboarding documents. If you upload all your documents to Oracle Documents Cloud and use HelloSign, you eliminate the papers, giving your new employee a better onboarding the experience. You in turn benefit from an organized way to track and securely store completed onboarding documents.

Some common onboarding documents to digitize are: 
  • I-9
  • W-4
  • Insurance forms
  • NDAs
  • Employee handbooks

#2 Procurement Processes
You need to manage lots of documents in the world of procurement and supply. When procurement departments work with paper contracts, they’re at risk for getting lost or damaged. Digitizing these documents can help streamline the vendor and contract processes. You’ll keep your documents safe and secure to boot.

When you use HelloSign for Oracle Documents Cloud, not only will your documents be safely stored in the cloud, they’ll also include a court permissible audit trail

Consider bringing the following procurement documents into the cloud: 
  • Form of Offer and Acceptance
  • Service Agreements
  • Terminations
  • Bidding Forms
#3 Sales Contracts
Slowing down your Sales team means slowing down revenue for your business. Can you imagine if you lost a deal to a competitor because they sent their contract digitally while you were still stuck printing and faxing it? 

HelloSign and Oracle Documents Cloud removes the friction in signing sales contracts, because it becomes fast and easy to sign and send back. That means sales teams spend less time sitting and waiting for their contracts to return. HelloSign for Oracle Documents Cloud also shows the status of the document, stating whether the document is signed or not, so your Sales team can follow up appropriately. 

Use Oracle Documents Cloud and HelloSign to manage: 
  • Statements of work
  • Sales proposals
  • Purchase and sales agreements
  • Demo NDAs
#4 Real Estate Agreements
When you’re closing a deal in the real estate industry – regardless of whether you’re in sales or rentals – paperwork is inevitable. Rather than having to print these documents or bring a folder full of copies with you, simply add these files to your Oracle Documents Cloud and use HelloSign to get them signed. 

You can use HelloSign and Oracle Documents Cloud for: 
  • Purchasing agreements
  • Mortgage forms
  • Deed forms
  • Lease agreements
  • Rental applications
#5 Back Office Paperwork
The back office is always managing a wide variety of documents that help a company run smoothly. Often times, they’re managing crucial documents that keep records of the company’s sales and purchases. 

With the HelloSign integration, you can cut out back office paperwork such as: 
  • NDAs 
  • Invoices
  • Purchase orders
Ready to get started? 
HelloSign with Oracle Documents Cloud can help nearly all industries or departments with their paper problem. Read more about how the integration works or email oracle-sales@hellosign.com for more information.

Belk, Hot Topic and Torrid Choose Oracle Retail Stores Solutions to Unify Brand Experiences

Oracle Press Releases - Mon, 2017-01-16 05:42
Press Release
Belk, Hot Topic and Torrid Choose Oracle Retail Stores Solutions to Unify Brand Experiences Department store retailers empower store associates with modern technology

Redwood Shores Calif—Jan 16, 2017

Oracle announced today that Belk, Hot Topic and Torrid have invested in Oracle Retail Xstore Point-of-Service to improve their in-store guest experiences. All three companies are owned by Sycamore Partners, a New York-based private equity firm whose portfolio generates more than $10 billion in annual sales.
 
Retailers compete on the basis of brand experience. The store is the nucleus of the human touch point. Consumers are embracing mobile devices and transformative in-store technologies that redefine their shopping experiences. Belk, Hot Topic and Torrid will leverage this same technology to empower associates and provide them with more information to better serve consumers.
 
With a modern and intuitive user interface, Oracle Retail easily delivers and demonstrates best practices in retailing as a platform for unified commerce and transparency.
 
“The success of all three companies is dependent on the commitment and dedication of our associates,” said Don Hendricks, executive vice president and chief operating officer, Belk. “The investment in Oracle Retail Xstore Point-of-Service empowers and inspires our associates to deliver a personalized shopping experience.”
 
“By using Oracle Retail solutions, these retailers empower associates to sell their products quickly, consistently and knowledgably from wherever they engage their customers,” said Mike Webster, senior vice president and general manager, Oracle Retail and Hospitality. “Oracle empowers commerce by investing in complimentary cloud services that provide retailers with a single view of customer and order starting at the point of sale.”
 
Oracle Retail at NRF 2017
 
Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 15-17, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #2521. For more information check out: www.oracle.com/nrf2017
 
Contact Info
Matt Torres
Oracle
4155951584
matt.torres@oracle.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Matt Torres

  • 4155951584

What’s The Difference Between Oracle ROWNUM vs Oracle ROW_NUMBER?

Complete IT Professional - Mon, 2017-01-16 05:00
Have you seen ROWNUM and ROW_NUMBER in Oracle and wondered what the difference is? Learn what they are and the differences between Oracle ROWNUM vs Oracle ROW_NUMBER in this article. What Is Oracle ROWNUM? You might think that ROWNUM is a function in Oracle. However, it’s not a function. It’s a “pseudocolumn”. It acts like […]
Categories: Development

Analyse Your Data on the Go with Oracle Synopsis App

Rittman Mead Consulting - Mon, 2017-01-16 02:42
Analyse Your Data on the Go with Oracle Synopsis App

How many times did you receive an email on your phone with an Excel or CSV attachment you wanted to analyse immediately in an app on your mobile, without having to wait until you reach the laptop? Not only viewing raw numbers but also creating graphs and summaries with the possibility to share the end result with your colleagues?

Analyse Your Data on the Go with Oracle Synopsis App

Your prayers have been answered with the recent release from Oracle of Oracle Synopsis. This is a new mobile app available for Android devices (an iOS version coming soon) that enables building data analyses on the go by interacting with data directly on the smartphone/tablet. It is a free application that doesn't require any OBIEE backend or additional licensing.


Happy to announce that we have launched Synopsis on Android. Now go analyze your data. https://t.co/tAxCrz4RAY pic.twitter.com/JT6dHMKgVu

— BI Mobile Labs (@bimobilelabs) December 21, 2016

Oracle's mobile ecosystem so far has been represented by Oracle BI Mobile HD: an app available since several years, requiring an additional license, which focused on the visualization of OBIEE's pre-built content like dashboard, analysis or alerts. The main limitation of BI Mobile HD is that all content must be created upfront in a computer browser in order to be accessed by the application, no "analysis" option was available other than predefined drilling or navigation capabilities.

Synopsis extends Oracle's mobile ecosystem by adding an app capable of analysing data on the go, interacting directly with files on the phone/tablet in a visual and intuitive way.

Let’s have a look at how Synopsis works. For my test I'll use the Federal U.S. Electric Utility Companies and Rates data coming from en.openei.org.
I first downloaded the CSV file in my phone, then opened the Oracle Synopsis App and selected the file from the "Downloads" folder.

Analyse Your Data on the Go with Oracle Synopsis App

By default, just by opening the file with Synopsis app, I get a project named as the source file (iouzipcodes2011) showing a bar chart of ZIP by UTILITY_NAME. I'm able to switch the coordinates of the graph by either changing the dimension of the X-axis or the measure on the Y-axis by selecting another option from the sections on top and bottom of the graph respectively.

Analyse Your Data on the Go with Oracle Synopsis App

The default graphs are provided just by opening the file, without having to define any measure or dimension.

The question now is: What am I looking at? How do I change the default behaviour?
I can get an idea about what Synopsis is doing by clicking on the project title itself. By default the application associates all text columns to dimensions and all numeric columns to measures, aggregating them with SUM. I can however change the default behaviour by:

  • Changing the aggregation method for the measures, possible alternatives are Average and Count
  • Changing the text and numbers (dimension and metrics) assignments by clicking on the cog icon and accessing the related screen
  • Hide a column by just tapping on the column name (in the grey box shown in the image below), a line will be shown on top the hidden column name.

Analyse Your Data on the Go with Oracle Synopsis App

Measures format can be changed just by sliding the related number tile and setting decimals, currency, percentage format among others.

Analyse Your Data on the Go with Oracle Synopsis App

When clicking on a measure (e.g. ind_rate), a list of graphs, one per dimension, is presented. The type of graphs depends by the attribute type (bar for a text, line trend for a date) and cardinality (a donut is presented when the number of distinct value for an attribute is shown).

Analyse Your Data on the Go with Oracle Synopsis App

I can however change the graph type by clicking on it. There are multiple options:

  • One or more metrics can be added and filters can be applied
  • Attributes can be added and filters can be applied
  • The graph type can be changed

Analyse Your Data on the Go with Oracle Synopsis App

An image of the resulting graph can then be easily sent via mail by clicking on Analyse Your Data on the Go with Oracle Synopsis App

When clicking on padlock icon projects are secured with the fingertip sensor. This option is enabled only in mobile devices supporting the fingertip recognition.

Analyse Your Data on the Go with Oracle Synopsis App

Projects can be exported: a .syn file will be created containing both data and metadata. The project file can then be shared and reopened with the Synopsis app in other mobiles. In this first release is not possible to share projects between Synopsis and other tools like Visual Analyzer or Data Visualization Desktop but it’s an obvious enhancement that one could imagine Oracle considering for the future.

A list of global settings is also available in order to change import settings like blank cells management and CSV delimiter.

Analyse Your Data on the Go with Oracle Synopsis App

Be aware that Synopsis requires the Excel (or CSV) file to be in a pure tabular form; extra heading rows or collapsed cells will prevent Synopsis from parsing it. On top of this, in order for it to work at least one numeric and one text column are needed.

Conclusion

Oracle Synopsis is a great addition to Oracle's mobile offering. It provides an app capable of analysing data on the go in a very visual and intuitive way. So far only CSV and Excel files are supported but my guess is that it will soon be possible to interface to a lot of other applications especially in the Cloud. And - it’s free!

Categories: BI & Warehousing

Which Oracle Web Tier Utilities Patchsets Can Be Used with EBS 12.2?

Steven Chan - Mon, 2017-01-16 02:05
The Oracle E-Business Suite Release 12.2's Rapid Install delivers three Fusion Middleware (FMW) components:
  1. Oracle WebLogic Server 10.3.6 (this is the "$FMW_HOME") 
  2. Oracle WebTier Utilities 11.1.1.6
  3. Oracle Common Home (Part of Oracle WebTier Utilities 11.1.1.6)
The fifth-level digit in the Oracle Web Tier Utilities version is not relevant to E-Business Suite certifications.  In other words, you can apply any Oracle Web Tier Utilities patchsets that have been certified at the fourth-level digit. 

For example, we have certified EBS 12.2 with Web Tier Utilities 11.1.1.9. All of the following Web Tier Utilities patchsets will work with EBS 12.2:

  • Oracle Web Tier Utilities 11.1.1.9.0 (documented certification)
  • Oracle Web Tier Utilities 11.1.1.9.161225 (Fictitious future Bundle Patch for example purposes only-- this has not been released

This is sometimes shown in our documentation in either of the following ways:

  • Oracle Web Tier Utilities 11.1.1.9
  • Oracle Web Tier Utilities 11.1.1.9.x

The absence of a fifth-digit or the presence of an 'X' in the fifth digit's place means any fifth-digit level updates may be applied to an EBS 12.2 environment without requiring a new certification.  This applies to all environments, including test and production environments.

What is NOT certified

The Oracle Web Tier Downloads page has several listings for other things, including:

  • Oracle Web Tier 12cR2
  • Oracle HTTP Server 12.2.1.2
  • Oracle HTTP Server 12.2.1.1
  • Oracle HTTP Server 12.2.1

These have not been certified with Oracle E-Business Suite 12.2.  You should not apply these to your EBS 12.2 environment.

Related Articles

Categories: APPS Blogs

Links for 2017-01-15 [del.icio.us]

Categories: DBA Blogs

APEX 5.1 New Features

Denes Kubicek - Mon, 2017-01-16 01:57
APEX 5.1 ist endlich da. Oracle Application Express wird mit jedem Release besser und zieht immer mehr Entwickler weltweit in seinen Bann. Es ist einfach, einfache wie auch komplexe Applikationen auf Basis des Oracle Stacks zu entwickeln. Es macht sogar richtig Spaß !

Mit APEX 5.1 sind als wichtiges neues Feature die Interactive Grids mit dazu gekommen. Wir haben sehr lange auf eine moderne Möglichkeit gewartet, Excel - ähnliche Funktionen auf einer Webseite mit APEX zu implementieren. Jetzt ist es endlich soweit :) . Sogar Master-Detail-Detail-Detail-... Beziehungen sind umsetzbar, unsere Anwender werden sich freuen.

Darüber hinaus gibt es auch in vielen anderen Bereichen wichtige Neuerungen, die uns das Leben erleichtern. Gleichzeitig sind aber auch einige wichtige Dinge zu beachten, damit wir ein reibungsloses Upgrade durchführen können.

In diesem Kurs lernen Sie die neuen Funktionalitäten von Oracle Application Express 5.1 kennen, insbesondere wie Sie diese erfolgreich in der Praxis einsetzen.

Lernen Sie von und diskutieren Sie mit den weltweit bekannten Oracle APEX Experten:

Denes Kubicek, langjährige Projekterfahrung in den Bereichen Oracle und APEX mit multisite Applikationen, Preisträger des "Oracle APEX Developer of the Year 2008" Awards des Oracle Magazines, ein Oracle ACE Director und sehr bekannt im Oracle APEX OTN Forum für seine Beispielapplikation und

Dietmar Aust, erfahrener Oracle Consultant mit Spezialisierung auf Oracle APEX, Oracle ACE und aktiv in den OTN Foren zu APEX und Oracle XE, mit regelmäßigen Präsentationen auf den einschlägigen Oracle Konferenzen (DOAG, ODTUG, Oracle Open World).



Categories: Development

Oracle Parallel Execution Deep Dive Session

Randolf Geist - Mon, 2017-01-16 01:00
Here is a recording of a session I did a while ago, covering how to understand the essentials of Oracle Parallel Execution and how to read the corresponding execution plans.


12cR1 RAC Posts -- 3 : Convert PolicyManaged DB back to AdminManaged

Hemant K Chitale - Sun, 2017-01-15 20:35
In the previous post on 12cR1 RAC, I had converted my AdminManaged Database to PolicyManaged.

Here, I convert it back to AdminManaged.

First, I verify that the database is shutdown (note that I have only 1 node of the cluster currently up and running, I don't need both nodes and instances up).

[oracle@collabn1 ~]$ srvctl status database -d RAC
Instance RAC_1 is running on node collabn1
[oracle@collabn1 ~]$ srvctl stop database -d RAC
[oracle@collabn1 ~]$ ps -fuoracle |grep smon
oracle 3422 1 0 09:49 ? 00:00:00 asm_smon_+ASM1
oracle 4882 1 0 09:50 ? 00:00:00 mdb_smon_-MGMTDB
oracle 16889 9821 0 10:08 pts/0 00:00:00 grep smon
[oracle@collabn1 ~]$


Next, I remove the database from the Cluster Registry.

[oracle@collabn1 ~]$ srvctl config database -d RAC
Database unique name: RAC
Database name:
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile:
Password file:
Domain: racattack
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: MyPool
Disk Groups: DATA,FRA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group:
Database instances:
Configured nodes:
Database is policy managed
[oracle@collabn1 ~]$ srvctl remove database -d RAC
Remove the database RAC? (y/[n]) y
[oracle@collabn1 ~]$ srvctl config database -d RAC
PRCD-1120 : The resource for database RAC could not be found.
PRCR-1001 : Resource ora.rac.db does not exist
[oracle@collabn1 ~]$


I then remove the defined Server Pool that I used for this database.

[oracle@collabn1 ~]$ srvctl config srvpool
Server pool name: Free
Importance: 0, Min: 0, Max: -1
Category:
Candidate server names:
Server pool name: Generic
Importance: 0, Min: 0, Max: -1
Category:
Candidate server names:
Server pool name: MyPool
Importance: 100, Min: 1, Max: 2
Category:
Candidate server names: collabn1,collabn2
[oracle@collabn1 ~]$ srvctl remove srvpool -serverpool MyPool
[oracle@collabn1 ~]$ srvctl config srvpool
Server pool name: Free
Importance: 0, Min: 0, Max: -1
Category:
Candidate server names:
Server pool name: Generic
Importance: 0, Min: 0, Max: -1
Category:
Candidate server names:
[oracle@collabn1 ~]$


I then add the database back into the Cluster Registry.

[oracle@collabn1 ~]$ srvctl add database -d RAC \
> -oraclehome /u01/app/oracle/product/12.1.0/dbhome_1 \
> -pwfile +DATA/RAC/PASSWORD/pwdrac.277.931824933
[oracle@collabn1 ~]$ srvctl config database -d RAC
Database unique name: RAC
Database name:
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile:
Password file: +DATA/RAC/PASSWORD/pwdrac.277.931824933
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups:
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group:
Database instances:
Configured nodes:
Database is administrator managed
[oracle@collabn1 ~]$


I start the second node of the cluster before I configure the instances (Note : I have the $ORACLE_HOME/dbs pfiles created in advance).

[oracle@collabn1 ~]$ srvctl add instance -d RAC -i RAC1 -n collabn1
[oracle@collabn1 ~]$ srvctl add instance -d RAC -i RAC2 -n collabn2
[oracle@collabn1 ~]$ srvctl config database -d RAC
Database unique name: RAC
Database name:
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile:
Password file: +DATA/RAC/PASSWORD/pwdrac.277.931824933
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups:
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group:
Database instances: RAC1,RAC2
Configured nodes: collabn1,collabn2
Database is administrator managed
[oracle@collabn1 ~]$


I am now ready to start the database (instances).

[oracle@collabn1 ~]$ srvctl start database -d RAC
[oracle@collabn1 ~]$ srvctl status database -d RAC
Instance RAC1 is running on node collabn1
Instance RAC2 is running on node collabn2
[oracle@collabn1 ~]$ ps -fuoracle |grep smon
oracle 3422 1 0 09:49 ? 00:00:00 asm_smon_+ASM1
oracle 4882 1 0 09:50 ? 00:00:00 mdb_smon_-MGMTDB
oracle 25431 1 0 10:30 ? 00:00:00 ora_smon_RAC1
oracle 27533 9821 0 10:33 pts/0 00:00:00 grep smon
[oracle@collabn1 ~]$
[root@collabn2 ~]# ps -fuoracle |grep smon
oracle 3460 1 0 10:19 ? 00:00:00 asm_smon_+ASM2
oracle 9561 1 0 10:30 ? 00:00:00 ora_smon_RAC2
[root@collabn2 ~]#
[oracle@collabn1 ~]$ env |grep SID
ORACLE_SID=RAC1
[oracle@collabn1 ~]$ sqlplus '/ as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jan 16 10:34:15 2017

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> select * from v$containers;

CON_ID DBID CON_UID GUID
---------- ---------- ---------- --------------------------------
NAME OPEN_MODE RES
------------------------------ ---------- ---
OPEN_TIME
---------------------------------------------------------------------------
CREATE_SCN TOTAL_SIZE BLOCK_SIZE RECOVERY SNAPSHOT_PARENT_CON_ID
---------- ---------- ---------- -------- ----------------------
1 2519807290 1 FD9AC20F64D344D7E043B6A9E80A2F2F
CDB$ROOT READ WRITE NO
16-JAN-17 10.31.34.014 AM +08:00
0 0 8192 ENABLED 0


CON_ID DBID CON_UID GUID
---------- ---------- ---------- --------------------------------
NAME OPEN_MODE RES
------------------------------ ---------- ---
OPEN_TIME
---------------------------------------------------------------------------
CREATE_SCN TOTAL_SIZE BLOCK_SIZE RECOVERY SNAPSHOT_PARENT_CON_ID
---------- ---------- ---------- -------- ----------------------
2 2061548092 2061548092 44BB5E17F41A2618E053334EA8C006B9
PDB$SEED READ ONLY NO
16-JAN-17 10.31.34.859 AM +08:00
1594413 859832320 8192 ENABLED 0


CON_ID DBID CON_UID GUID
---------- ---------- ---------- --------------------------------
NAME OPEN_MODE RES
------------------------------ ---------- ---
OPEN_TIME
---------------------------------------------------------------------------
CREATE_SCN TOTAL_SIZE BLOCK_SIZE RECOVERY SNAPSHOT_PARENT_CON_ID
---------- ---------- ---------- -------- ----------------------
3 1857084550 1857084550 44BBC69CE8F552AEE053334EA8C07365
PDB MOUNTED

1755977 0 8192 ENABLED 0


SQL> alter pluggable database PDB open;

Pluggable database altered.

SQL>
SQL> select con_id, name, open_mode from v$pdbs;

CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED READ ONLY
3 PDB READ WRITE

SQL>


Thus, I converted my PolicyManaged database to AdministratorManaged.
.
.
.

Categories: DBA Blogs

Procedure accepting more than 32K text as a parameter and inserting to CLOB coumn

Tom Kyte - Sun, 2017-01-15 16:46
Hi Team, We have one requirement where: 1) we have to write one proceudre which will insert into a clob column meant for email body. This procedure should accept text more than 32K. 2) the application or routine will execute this procedure by p...
Categories: DBA Blogs

Space required in UNDO tablespace for adding a new column with Default value not null.

Tom Kyte - Sun, 2017-01-15 16:46
Hi Tom, Recently we needed to add a new field in a table with a default value and a not null constraint, since the table was 45 million rows and 7GB, we ran out of space in UNDO tablespace. In order to avoid the issue in the future, we did some...
Categories: DBA Blogs

Hybridized Database after an upgrade of a retail Point of Sale application.

Tom Kyte - Sun, 2017-01-15 16:46
Background: Point of Sale product running on retail stores. Each store has a store primary database and there is a centralized database. The data from the stores get replicated real time to the central Database. The Front end application and the DB i...
Categories: DBA Blogs

Migrate a Oracle Database from a client server to an internal server through an intermediate server like EFT

Tom Kyte - Sun, 2017-01-15 16:46
Hello. I need to copy a customer database from their server to my server. I will get a copy using the Oracle Data Pump. But the client network is different that my network, so I need to use an intermediate server like an EFT. How can I do this? Thank...
Categories: DBA Blogs

Connnect by level

Tom Kyte - Sun, 2017-01-15 16:46
HI TOM, I need a small short and brief explanation of the below query. create table t as select dbms_random.string('a', 10) y from dual connect by level <= 10; ---Here can i know what does "connect by level" can you explain a bit ...
Categories: DBA Blogs

Oracle Index Internals

Tom Kyte - Sun, 2017-01-15 16:46
Team, Generally talking about the Indexes, it is considered as an object which assists in fetching the data faster or quickly. But i would like to know the internals of index, like how index is stored and index leaf node,branch node and index r...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator