Questions tagged [oracle-12c]

Oracle Database 12c. Please also tag oracle for search purposes.

226 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
301 views

RMAN-06169, but only when backing up via OEM 13c

When running a Level 1 or Level 0 backup via OEM 13c, the following RMAN error causes the run to fail. (The RMAN script is being ran with proper sysdba credentials from OEM 13c.) RMAN-06169: could ...
3
votes
0answers
420 views

Import Oracle unicode data with OLE DB Source and destination in SSIS 2015

My issue is identical to this post on mssqltips.com, however my issue is importing from Oracle, not Excel. I get all the way to the bottom where I need to map the output columns from my data ...
3
votes
1answer
2k views

Oracle Warning in Alert Log Regarding PGA_AGGREGATE_LIMIT

Introduction During the startup process of our Oracle instances, we are encountering the following error message in the alert log: WARNING: pga_aggregate_limit value is too high for the amount of ...
3
votes
0answers
1k views

Getting email notification when jobs are created under user_schema rather than sys?

I log in as sys and set the smtp for scheduler: BEGIN DBMS_SCHEDULER.set_scheduler_attribute('email_server', '10.1.1.15'); DBMS_SCHEDULER.set_scheduler_attribute('email_sender', 'user@compny.com')...
3
votes
2answers
1k views

Case insensitive search of CLOBs in Oracle 12

Question: What is the most performant way to do a case-insensitive search in a CLOB column? I've simplified the query to easily reproduce the problem. The filedata table can have millions of rows. ...
2
votes
1answer
2k views

Migrated DB from 12c to 19c with IMPDP failed

I have migrated a DB from 12c to 19c with IMPDP and EXPDP. While importing I have seen some errors. Below is an extract of the errors. Errors During Import Processing object type SCHEMA_EXPORT/TABLE/...
2
votes
0answers
190 views

Incremental Schema Stats (With partitioned/Subpartition table) gathering is taking too much time in oracle version 12.2.0.1

When I am gathering schema stats with below options, it is taking too much time: EXEC dbms_stats.gather_schema_stats ( ownname => 'SCHEMA', granularity => 'AUTO', CASCADE=> true, ...
2
votes
1answer
80 views

How to point tablespace in Oracle's pre-built Developer Day VM to another mount point

I have downloaded and started up Oracle's pre-built OTN Developer Day VM. The VM is running on an SSD. I want to load some data for development purposes. I am planning to create a new user and load ...
2
votes
1answer
262 views

Non-CDB database vs Single tenant CDB

I am looking at the prospect of upgrading from oracle 11G to 12C, and I am looking at the cdb vs non-cdb models, and I am having a hard time seeing the benefit of using CDB, without multitenant ...
2
votes
0answers
135 views

Upgrading Oracle ODBC driver from 11 to 12 causing code to fail

In the process of replacing our servers which involves updating the Oracle ODBC drivers from 11 to 12. We have a process that executes on these servers that calls a stored procedure. The procedure ...
2
votes
0answers
941 views

Unable to start Oracle Listener - “The user name or password is incorrect”

I am trying to install Oracle Database 12c on a Windows Server 2012 machine. The installation goes well for the most part, except that I get the error "Oracle Net Services configuration failed" (that ...
2
votes
1answer
418 views

How do I run a database heavy query over jdbc without timing out (Oracle)?

For one of our applications (Pentaho Data Integration), we need to run queries through the oracle jdbc. Some of these queries are computation expensive and can take an hour or more to return any rows ...
2
votes
0answers
4k views

Oracle Database Client 12c Product Components

When installing the Oracle Database Client 12c Release 2 software on a Windows client the user has the option to select an installation type. These are: Administrator RunTime InstantClient Custom ...
2
votes
2answers
1k views

Empty v$asm_diskgroup with sqlplus

I have an Oracle Database instance installed under an OL7. It is a 12c2. Oracle GI also installed and my database has some files stored in ASM. I am using sqlplus to connect to the database instance ...
2
votes
0answers
3k views

“Acknowledge over PGA limit” wait event

Is it possible for this wait event to activate/showup even when the PGA has not crossed over PGA_AGGREGATE_LIMIT? I am continuously seeing this wait event in the ASH, but the PGA allocated stays ...
2
votes
1answer
448 views

Oracle using sub-optimal index on bind variables

Let's say you have a table, called ORDERS, which contains ORDER_NUMBER, CUSTOMER_ID, and ORDER_DATE (among other fields). And you have one index on ORDER_NUMBER, another on CUSTOMER_ID, and third ...
2
votes
1answer
903 views

ORA-00205 error during the startup of physical standby database

Steps I have followed:- Created a physical standby database by using DUPLICATE TARGET DATABASE. Then checked the log gap between these two databases which was fine and in sync. After that standby ...
2
votes
0answers
273 views

Oracle 12c: sql query return less result when it's used in a subquery

I recently encountered a weird situation where i get different result from the same query by only changing its scope. What i mean by changing the scope , is putting the query inside a subquery: I ...
2
votes
0answers
549 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 ...
2
votes
0answers
339 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 ...
2
votes
0answers
1k views

ORA-28545 (Net8) error when connecting Oracle 12c on Centos 7 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 the following: FreeTds. unixODBC. Next, I configured ODBC on the Linux server so that, ...
2
votes
0answers
3k views

Oracle 12c Enterprise Manager Database Express Subsequent Installation on Windows Server 2012

I have an Oracle 12c database instance which was installed without the option for configuring the "Enterprise Manager (EM) Database Express" How can i install it subsequent for a running instance? ...
2
votes
1answer
2k views

Environmental Variables for OracleDB 12 in Oracle Linux are Overriding Each Other with SQLPlus Variables

I want to set the environmental variables for OracleDB and SqlPlus properly. However, they are overriding each other. I'm doing something wrong, and I would like to get a hand finding where I went ...
1
vote
1answer
35 views

Selecting a record based off conditions CLOB

I have a table with a column storing JSON data as a CLOB. The JSON has a 'miscData' field that is made up of an array of JSON objects. Each object has 2 keys which are always the same, but the values ...
1
vote
1answer
30 views

Oracle multiple databases only able to access one database

I am new to oracle. I've installed oracle 12c(required to be this specific version) in my windows pc with no problem. I created one database named LOCAL using Database Configuration Assistant. Then i ...
1
vote
0answers
43 views

Oracle - Monitoring tablespace warnings and critical events via Microsoft Windows Event log

I would like to monitor tablespace warning and critical events of my Oracle database (12c Standard Release 12.2.0.1.0) via Microsoft Windows Event Viewer and attach tasks to it. Right now only a few ...
1
vote
1answer
359 views

Oracle goldengate service is not starting: Failed to retrieve the name of a missing Oracle redo log

I am trying to start GG service, when try 'start my_service' then starting but it didn't start, status is changed always starting to stopped. I need to start goldengate service.. I don't know what ...
1
vote
0answers
47 views

Why my Oracle 12C is allowing me to a connection creation without passing network security and integrity parameters

My Integrity settings Oracle Net Manager are: -- Integrity for - Server Checksum level - REQUIRED Selected Method : SHA1 -- Integrity for- CLIENT Checksum level - REQUIRED Selected Method : SHA1 ...
1
vote
0answers
85 views

Oracle Context Index - finding unsynchronised records

Context indexes can be update with the procedure: Ctx_Ddl.Sync_Index (index_name); But what exactly is synchronised by this function? How does Oracle know what is unsynchronised (i.e. how does it ...
1
vote
0answers
90 views

Database - limit of reading a table with a lot of concurrent batch read and writes

We have this table. It contains data which will be picked up by an hourly batch job for processing. Five times a day, there are also multiple batch ETL jobs which get data from other source table and ...
1
vote
0answers
349 views

Oracle 12c Datapatch Error

We have an old Oracle 12c database server that is not up to date (version 12.1.0.1.0). Unforunately a full version upgrade is out of scope right now, but I was hoping to at least apply the latest ...
1
vote
0answers
31 views

Oracle 12C silent installation - response file

I am installing Oracle 12c using a response file. The installer exits after a while, with the following error message: ERROR: Cannot add user to application access ACL. No mapping between account ...
1
vote
0answers
115 views

Why did my index become unusable after setting MAX_STRING_SIZE to EXTENDED?

I run Oracle Database 12c Standard Edition Release 12.2.0.1.0, and followed the official documentation to set MAX_STRING_SIZE to EXTENDED, to be allowed to use more than 4000 bytes in a VARCHAR2 ...
1
vote
1answer
49 views

Oracle Materialized View - Is it Safe to Use Only ROWID as Record Identifier?

this is a question related to Oracle 12c. I'm currently trying to create MVs as data sources for Golden Gate replication. We need fast refresh because We have to replicate 60,000 rows + at one time ...
1
vote
0answers
82 views

Oracle procedure takes forever to compile if I use public synonym

I have a procedure that queries a table through a DB link. If my procedure uses a public synonym through the DB link, it takes forever to compile. I'm creating the procedure in Oracle 12c. The DB ...
1
vote
0answers
53 views

Unable to add columns in a particular table

I am trying to add 4 columns on a table using the below command alter table table_name add (column_1 number(4), column_2 varchar2(10), column_4 number(4), column_5 varchar2(10)); The table ...
1
vote
0answers
70 views

Operation CTL_BOOTSTRAP canceled during phase 0, error = ORA-408

I am currently testing a data guard environment. In the alert.log of the broker I always see the following message after a switchover: 2019-05-23 08:08:54.716 7fffffff 0 Operation ...
1
vote
1answer
222 views

Which Oracle datafiles grow in size?

I have downloaded and started up Oracle's pre-built OTN Developer Day VM. The VM is running on an SSD. I want to move datafiles that can grow to a separate mount point (setup as a vmdk on a HDD. more ...
1
vote
0answers
44 views

Oracle Secure Backup (OSB) issue - “failed to read configuration data - Network is unreachable”

I am using Oracle 12.2.0.1 on Linux 6.8. I am using OSB to take a backup to tape. After an unknown host name error in the backup log, I edited the /etc/hosts file and restarted the server. After ...
1
vote
0answers
675 views

Cannot access remote table after parallel/insert direct load txn

This is the Oracle error message I'm getting ORA - 12840. We just upgraded from 10i to 12c version and some of the processes aren't working as they did before. I get this error when I execute a CREATE ...
1
vote
0answers
107 views

oracle shard availability pending

Trying to adjust Oracle DB 12.2 sharding configuration. Have one DB as the shard catalog and other two DBs as shards. Just want to test this functionality so run the tree DBs on the same machine in ...
1
vote
1answer
135 views

Oracle impdb on windows generates a subdirectory

I am importing to a windows oracle, a dump file produced on Linux. But oracle generates a subfolder in the dpdump directory /76E0F91BE49D480CB2633847BD640FC5\ and causes an "ORA-31640: unable to open ...
1
vote
0answers
47 views

What is the cardinality in this situation?

I need to find the cardinality for a few tables in an Oracle database. I have been given a word document that has a list of tables described with details as shown in the image: I have been reading ...
1
vote
1answer
85 views

Different execution plans and joins using synonym or table

Edit: We found the leading cause. If you join tables with the same name but in different schemas you can get this result. Same with joining two tables using the same alias (whyever this works at all)....
1
vote
0answers
25 views

A way to check Oracle finished sql

I've got Docker Compose cluster and one of the containers is Oracle 12c. There is schema.sql file to initialize the db. I would like my application to wait until the db executes all the sql. How can I ...
1
vote
2answers
198 views

Oracle 12c backup question with FRA

If I wanted to backup to the FRA and another location, how would I configure the channels? Also, would I need to set parallelism? Thanks
1
vote
1answer
494 views

How can I be specific about which CDB I want to connect to wrapping a PDB?

I'm quite new to Oracle. I created a CDB like cdb1 and then a PDB within like pdb1. Now I can connect to my PDB using something like: sqlplus user/password@server:port/pdb1 But can't I have two PDBs ...
1
vote
1answer
1k views

Is DBSNMP used only by Oracle EM by default?

I have Oracle database and I need to install agent for Oracle EM. It requires credentials for DBSNMP user, but it was lost. Is it safe to change password via SYS user to provide it to agent? Is there ...
1
vote
1answer
337 views

Cloning a PDB from one CDB into another CDB with TDE enabled at source and target

What are the possible ways to Clone a PDB from one CDB into another CDB (in a different host) with TDE enabled at both source and target. At present i am able to think of the following two a) Data ...
1
vote
1answer
40 views

Oracle Upgrade - Attach External Tables

We have just completed an 11g to 12c migration to a new server. There is a schema that didn't seem to come over that consists fully of external .dat files. I can't seem to find a way to simple '...

1
2 3 4 5