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

0
votes
0answers
30 views

Issues with SQL Developer

SQL developer is giving me errors of Network adapter could not establish the connection error Telnet is working from the local machine to the target (scan is in dns) nslookup from local machine is ...
1
vote
1answer
18 views

Question on Oracle OEM version and plugin version upgrade

I have a OEM 12c (12.1.0.4) running in my setup in which I have registered over 70-80 databases. I see the plugin updates with versions of each target (Oracle database, MS-SQL, MySQL) and I have the ...
0
votes
0answers
9 views

Connection between SQL Server 2014 and Oracle 12c [duplicate]

I have to server: 1.Server_A with Oracle 12c 2.Server_B with SQL Server 2014 I want these servers see each other, though I can SELECT anything I want in Server_A from Server_B and vice versa. I ...
1
vote
0answers
14 views

Oracle 12c upgrade - from Oracle 11g [on hold]

One of my product database backend, we are using Oracle 11g. Now, we would like to give support Oracle 12c. But while installing our product Oracle 12C, I'm facing issue by executing command (Create ...
1
vote
0answers
24 views

Slow inserts in oracle 12c inmemory table

We are running some tests to check the in-memory performance on a 12c (12.1.0.2.4 EE) RAC. Servers have 56GB memory and 20core CPUs. Our plan is to have a few read-performance critical tables in ...
0
votes
1answer
11 views

Query on Container-Pluggable database

My Container database (CDBROOT) is showing as read-write mode and while my pluggable database is showing as mount-state. Does that mean the application is using the container database and not the ...
0
votes
1answer
43 views

BI-DIRECTIONAL Oracle Golden Gate for Oracle 12c and SQL Server 2014

I have two servers (both servers are on Windows OS): Server_A running Oracle 12c Server_B running SQL Server 2014 I want to implement data synchronization between them with Oracle Golden Gate ...
2
votes
0answers
33 views

How do I authenticate a Database User by a LDAP Server and then to login with the SQL Developer, without using the OID/Apex?

I want to create a global User, identified by a LDAP_DN. My Problem is: I can automatically create users, but when I try to log on to the database, I get the error message that the login data are ...
1
vote
0answers
57 views

Step by step establish a connection between SQL Server 2014 and Oracle 12c

I have two servers (both servers are on Windows OS): Server_A running Oracle 12c Server_B running SQL Server 2014 I want these servers to be able to see each other, so I can SELECT anything I want ...
0
votes
1answer
55 views

How to install GLOBAL schema on Oracle 12c?

GLOBAL schema need to be installed for Oracle OLAP 12c. This link gives steps for installing GLOBAL schema on Oracle 11g and there is no page for Oracle 12c. ...
1
vote
1answer
29 views

Sync data in SQL Server 2014 with Oracle database12c

I have installed Oracle database 12c enterprise on my laptop. How can I implement data synchronization between Oracle 12c and SQL Server 2014 that whenever an INSERT,UPDATE,DELETE or ... happend on ...
4
votes
1answer
59 views

How to install olaptrain sample schema on oracle 12c?

I need to install the sample schema available from the Oracle website: http://download.oracle.com/otndocs/products/warehouse/olap/olaptrain_install.zip I am trying to run the commands as given ...
0
votes
2answers
47 views

RMAN 11g/12c Client compatibility

I'm having a Recovery catalog database 12c version. While I'm trying to register the target database (11g) with the catalog I get the following error: Recovery Manager: Release 12.1.0.2.0 - ...
0
votes
1answer
24 views

How to get a list of stored procedure along with their execution count in oracle 12c?

Hi I am new to Oracle 12c, though I was working on SQL Server for a long time. Is there a way to get a list of stored procedures with their execution count in oracle 12c. We can get it using DMV in ...
0
votes
0answers
32 views

Materialized View does not reflect changes after fast refresh

I have a query with many aggregate functions working on almost a million records every time, it's taking up to (ten of) minutes to complete the query so I created a materialized view for it, and since ...
0
votes
1answer
37 views

What is the advantage of pluggable database over normal databases?

Why creating pluggable database over normal database is good for system performance.
0
votes
2answers
55 views

Unique constraint error Oracle

I have two databases - one is 11g and another 12c. 12c db has the exact data of 11g (expdp/impdp). Now I'm facing an error in one of the tables with unique constraint error. I have checked the ...
0
votes
1answer
38 views

Location of RMAN backup

I have two servers. One is DB server another is RMAN Catalog DB server. From my RMAN Catalog, I connect to my remote DB server and I run the backup. Where will the backup files be stored? Will it be ...
0
votes
0answers
23 views

How Do you add multilanguage support in oracle 12c post installation?

I have oracle 12.1.0 database But currently has only english language support . How can I get multi language support without re installation?
0
votes
1answer
38 views

Two Oracle clients on the same server

Is it okay to have two oracle clients (both 11g and 12c) in the same db server? What are the potential issues I could face? The reason im doing this is to connect the app server where I'm deploying ...
2
votes
1answer
107 views

Oracle instant client

What is the difference between instant client and the original Oracle client? The Oracle client is almost 800MB and the instant client is not so much. I need to install oracle client, ODBC drivers and ...
1
vote
0answers
17 views

Oracle in hyper-convergence system

How does Oracle perform in hyperconvergence systems such as nutanix, simplivity? Oracle doesn't certify the underlying storage which nutanix or simplivity offers (file level storage) but in reality ...
0
votes
1answer
28 views

RMAN catalog database

I'm about to create a RMAN catalog database for my setup, what are the general precautions or major pre-requisites as in DB parameters, compatibility,etc that I should take care while creating the ...
0
votes
1answer
37 views

ASM 12c compatibility

Can I use ASM 12c version with database 11g? The following link https://community.oracle.com/thread/3674266?start=0&tstart=0 and MOS Doc ID 337737.1 says I cannot use 12c version of ASM with a ...
1
vote
0answers
17 views

Oracle far sync in 12c [closed]

How efficient is far sync feature when it comes to dr? Does it really provide zero data loss with very less compute?
1
vote
1answer
106 views

Oracle 12c Client to 10g Server (OPENQUERY)

Scenario: We currently have a SQL 2008 R2 server (with Oracle 10g Client) using OPENQUERY to return data from an Oracle 10g database. Problem: We would like to upgrade to SQL Server 2014 SP1 (with ...
1
vote
0answers
22 views

Using Oracle 12c database (SCAN) with Oracle 8 client

I have successfully connected to my 12c database using Oracle 8 client. The connection is based on using the database-scan as host in tnsnames.ora. There are 3 IP addresses reserved in DNS for ...
3
votes
1answer
56 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
2answers
77 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
36 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
41 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
108 views

What is the privilege for account unlock in Oracle [closed]

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
98 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
1answer
54 views

“Credential retrieval failed” during recovery of an Oracle database

When starting up automatic instance INSTANCE: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== ...
0
votes
0answers
75 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 ...
1
vote
0answers
126 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
51 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
104 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
2answers
895 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 ...
1
vote
1answer
78 views

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

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
24 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
32 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
78 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
250 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
200 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
43 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 ...
-4
votes
1answer
144 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
69 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
84 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
39 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 ...