Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g, Oracle 11g and Oracle 12c. Generally there are two releases within each major version. Questions tagged **oracle12c** are assumed to be specific to this version or features introduced in this version.

learn more… | top users | synonyms

2
votes
0answers
10 views

Oracle error ORA-65052: statement involves operations with different container scope

I'm a relative newb to Oracle. I have set up an instance of Oracle 12c running on a RHEL 7 VM. I am connecting to the database created during installation through and running some installation ...
1
vote
1answer
33 views

How to set Persian calendar,currency,numbers,date and time and text in oracle database?

I have installed oracle database 12c on my laptop. I want to be able to store text,numbers,calendar,currency,... in my local language (Persian) in database tables and also show contents in Persian ...
0
votes
1answer
23 views

Oracle selective redo log shipping

We are planing to setup an Oracle 12c RAC with a Logical standby in the DR site. Since data consistency is extremely important, we our planning to setup redo log shipping to be in SYNC mode. Our ...
2
votes
2answers
27 views

How do I limit Oracle's memory use?

I would like to use Oracle's automatic memory management, with a limit of around 4GB. (Past experience has shown this to be plenty for my dev PC and that it is easier to get an idea about any ...
0
votes
2answers
43 views

What is the privilege for account unlock in Oracle [on hold]

I want to understand the privileges better, but I'm not able to find some useful info using Google. I thought that I needed ALTER USER privilege to be able to unlock user and change password. But ...
2
votes
0answers
29 views

Oracle 12c connection to SQL Server 2014

I have installed Oracle 12c on Centos 7 and I wanted to connect SQL Server 2014 using freeTDS so I installed: FreeTds. unixODBC. then configured odbc on the linux so when I run isql dsn username ...
0
votes
0answers
16 views

oracle database 12c

When starting up automatic instance INSTANCE: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== ...
0
votes
0answers
18 views

“Unable to display page” with Oracle 12c Enterprise Manager Database Express

i'm using redhat 6, installed 12.1.0.2 of oracle and created a database. database (dev12ee1) is a non-container database, there is also an 11g database on the server (dev11ee1) lsnrctl status shows ...
0
votes
0answers
30 views

Unable to open/connect to Oracle 12c Enterprise Manager Express

I have a just installed a new single instance installation of Oracle 12c (12.1.0.2.0 on Windows x64) with ASM. The database itself is working OK (can be accessed locally and remotely via port 1521), ...
0
votes
1answer
47 views

Logging into Oracle

I am new to Oracle (coming from a SQL Server world). This is going to probably be some simple newbie question. I just did a fresh install of Oracle 12c Express. The install was successful, but now I ...
0
votes
0answers
28 views

Failure to start instance resource on1 node of a 3 node of an Oracle 12c RAC

After adding a 3rd node to our 2 node 12c RAC, one of the existing node is now unable to start the database resource. Extract from crsctl stat res -t: ora.datacdb.db 1 ONLINE ONLINE ...
1
vote
1answer
270 views

Oracle 12c client installer error

I'm trying to install Oracle client 12.1.0.2.0 (32-bit) on a completely clean copy of windows Server 2012, and I'm hitting a problem. The installer runs fine until it gets to the final part - the net ...
0
votes
1answer
49 views

Startup oracle database 12c manually with SQL*Plus command not when OS loads (solved)

I changed oracle instance to manually start from services.msc (service name is "OracleServiceORCL"), Because I want to start it up manually with SQL*Plus commands whenever I want, not with OS load. ...
0
votes
0answers
14 views

Creating objects containing collections of themselves

I'm creating a simple data structure using PL/SQL to help me work with some rows in tables which have dependencies upon each other. In short, I'd like to be able to create a graph using any ...
0
votes
1answer
28 views

A question about oracle upgrade from 12.0.0.1 to 12.0.0.2 using dbua

I found this guide for upgrade. After the upgrade, can I delete safely the old DB product dir /var/oracle/app/oracle/product/12.1.0 ?
1
vote
0answers
38 views

Oracle 12c database cannot log in as a local user

I met a problem from Oracle 12C Database, when I try to login to the user account with commandconn test/test, I got prompt of "invalid username/password, logon denied". when I use conn ...
1
vote
1answer
85 views

2 Different Oracle DB Version on same server

Is it possible to install and run 2 different oracle version(11g and 12c)software and db on same server? is it possible then how we can? and if not then why? Thanks Rahul Joshi
0
votes
0answers
81 views

Oracle RAC takes forever dropping tables

We are seeing table drops consistently take tens of seconds on our Oracle 12c RAC. It appears to be spending on its time on reliable message waits. Which I think means that it asks the other node to ...
0
votes
1answer
40 views

How to create oracle user for more than one version

I have server under RHEL 6.3 installed on that server Oracle 11gr2 and 12c, I want to create user lets say Ahmad but I want this user to be sysdba on both servers, for single server I edit ...
-3
votes
1answer
81 views

How to install Oracle DB 12c on Solaris 11.2? [closed]

I downloaded file 1 and file 2 and extracted it in one folder called ORCLDB. When I run ./runInstall as root from terminal it says The user is root. Oracle universal installer cannot continue if the ...
0
votes
0answers
60 views

sql taking < 1 sec to run in sql developer, 37 on the application side

As the title says, we have a big discrepency between a sql query we're running from our java application (jdbc thin client) and the same query run in sql developer. I clear the cache of the query ...
0
votes
2answers
70 views

Duplicate data in a table given table name

For a performance testing application we need to have lot more data in our tables than what we have now. How do I duplicate the data in a table. In the process of duplicating I also need to set new ...
0
votes
0answers
29 views

Oracle In-Memory POPULATE_STATUS does not change to completed

I'm experimenting with the Oracle In-memory options for BI purposes, when I'm trying to populate one table to in-memory in the v$im_segments the POPULATE_STATUS does not change to completed, for other ...
0
votes
0answers
109 views

Connecting to Oracle database installed in one machine using Toad from another machine

I've an Oracle 12c installed in one machine in the LAN, and am able to access this database from the other machines in the LAN by the java applications using the jdbc thin driver connection ...
0
votes
1answer
199 views

dbca cant remove database cleanly

when I ran dbca as administrator under windows server 2008R2 is used to delete the database completely ( database folder, control files, datafies, redo logs, then remove all related windows services ...
1
vote
2answers
173 views

Specify NLS-Settings during Oracle installation under Windows

Is there an easy way to specify NLS parameters for the database during the installation? We want to install a new database (environment: Windows). For testing purpose we need NLS settings for ...
0
votes
0answers
48 views

Email Column Constraint to Contain '@' character

How do you create an inline constraint for a Email Address Field that requires there be an "@" character? Pretty much I want there to be a restriction to the field so that the data entered must have ...
0
votes
2answers
934 views

Oracle 12c Express Enterprise Manager on Centos 6.5 is not reachable

I have Centos 6.5, and installed Oracle 12c. As dbca utility says after configuring new db, EM Express should be available on https://hostname:5500/em In fact, it is not. Neither on localhost nor by ...
6
votes
1answer
343 views

What are the Oracle Dataguard Implications of Migrating to a PDB?

If I have an OLTP database with two physical standby instances (one remote) what are the implications of migrating the primary DB to being an Oracle 12c PDB? i.e. Does the process of migrating to ...
0
votes
3answers
497 views

How to tell from the OS whether Oracle instance is a standby, assuming no DB access?

One can easily check via SELECT database_role FROM v$database; whether your Oracle database is a primary or standby database. Is it possible to make the same determination without database access, ...
0
votes
1answer
590 views

Oracle 12c, can not chose standard edition when install!

i'm trying to install Oracle 12c on Windows 2012 R2 ... I get Enterprise Edition option only! I need to install Standard Edition!
0
votes
0answers
56 views

flashback recovery in RAC enviorment using Data Guard Broker (oracle 12c)

I am trying to flashback recover using DGMGRL from the current primary node. I am running the following command at current primary: dgmgrl> reinstate database pri but I am getting the error ...
0
votes
1answer
153 views

XMLTABLE solution without getting right parenthesis missing error

I am trying to select from an XML type and produce multiple rows. Have searched for my specific scenario/issue with not much success. Environment: Oracle 12c. I have commented out the offending code. ...
0
votes
0answers
111 views

Cant create a normal non-common user name for oracle 12c getting ORA-65096: invalid common user or role name error

I am trying to create a normal user for my oracle 12c database, but it wont let me create one that is not a common username. I have tried executing : CREATE USER TESTUSER IDENTIFIED BY "blah blah ...
0
votes
0answers
40 views

Cant login to DataBase migration assistant in oracle 12c while i can easily connect in sqlplus

I need to change the character set of my database( I have no idea how it got created with that character set in first place! would be nice to know as well). I searched and found out that i need to use ...
0
votes
2answers
168 views

How to detect in which schema a procedure is called?

I'm struggling with a problem in Oracle 12.1 regarding to procedures. We are using a data isolation approach based on schemas. We use one schema as PUBLIC and each project has exactly the same ...
0
votes
1answer
530 views

Toad for Oracle 64-bit : 1603 - Fatal error during installation

I'm trying to install Toad for oracle client, my Toad version is 12.1 for 64 bit system, i have succeeded to install oracle client 12c for 64 bit system, but i have stumbled by a problem when ...
0
votes
0answers
197 views

ORA 7445: Query causes Oracle 12 to crash

I'm currently testing my application on Oracle 12 after all tests passed OK on Oracle 11. During testing the application kept losing the connection to Oracle when running a certain query. Here is a ...
0
votes
0answers
542 views

ora-12705 cannot access NLS data files or invalid environment specified

I have i'm installing oracle in machine 12c, while installing everything goes smoothly but when it reach to database creation it passes two step. cleaning up failed stat copying database file ...
1
vote
1answer
106 views

Password of the oracle user in oracle linux?

I am trying to install oracle 12c on my virtualbox oracle linux 6.5. I ran the command oracle-rdbms-server-12cR1-preinstall , which created a user oracle . But I can't seem to login to the user cause ...
2
votes
0answers
167 views

'ORA-00059: maximum number of files exceeded' on Oracle 12c

I have a test database. Every night a script drops and recreates a number of pluggable databases that are used for our automated test runs. Recently, I have started getting 'ORA-00059: maximum ...
2
votes
0answers
47 views

Importing data into Oracle 12

I got a set of files from a client which are, as far as I can tell, copies of a database in Oracle 11. Each folder has the following structure: - init<DB>.ora - orapw<DB> - arch - dbf ...
0
votes
0answers
94 views

Are there any incompatibilities between Oracle 11 and 12?

I have an application which has been validated on an Oracle 11.2 database. A client has asked me whether they can use Oracle 12c instead as that is what their IT department would prefer. Is there an ...
0
votes
0answers
94 views

How to login as common user in Oracle using Toad?

I have created a common user in Oracle and the pluggable database name is pdborcl. I am able to login as sysdba with the common userid and password but not able to login as a normal user. Can anyone ...
0
votes
1answer
2k views

Oracle 12c SYSTEM user locked out

We have a development Oracle 12c database and the SYSTEM user account is locked out for one of the SID's (works fine with another SID). When I try to do a conn SID / as sysdba it keeps connecting me ...
0
votes
0answers
305 views

Oracle 12c, exclude rows wher two columns are both null

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit I am trying to select rows with a non-null value in one of two columns. Data is being selected from a view (MY_VIEW) with both ...
1
vote
1answer
3k views

Using Oracle12C Client with Oracle11.g database

I have been using Oracle12c client to connect to an Oracle11g database in a remote server for about one month, it wasn't giving me any problems until this week, when I started getting the error: ...
0
votes
1answer
719 views

Login / Password for Oracle Enterprise Manager in VM template?

I want to setup Oracle Enterprise Manager to access our development Oracle databases. I downloaded the following VM template from https://edelivery.oracle.com/EPD/Search/handle_go Oracle VM ...
3
votes
1answer
835 views

Oracle TimesTen vs Oracle database in-memory

Oracle has recently announced its latest Oracle database in-memory feature in 12c. Oracle already had an in-memory database TimesTen and now I was wondering as to what the the differences between ...
1
vote
0answers
59 views

What is a failsafe way to embed Oracle12c database with a product?

We are planning to embed Oracle12c as the default data source for our application. That means, Oracle12c and our application are going to reside on the same server. Our application runs on 64-bit ...