Questions tagged [oracle-19c]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
18 views

How can I audit actions done by my schema within my schema using Oracle Unified Auditing?

I want to be able to audit specific actions within my own schema (such as DDL, inserts, updates, anything I feel like). I am on Oracle 19C with mixed mode for auditing. I have a user "SPLUNK"...
0 votes
1 answer
19 views

How to grant rights to a common user in specific pdb in a container

0 I have made 4 pdbs in a container. I have one common user, and i want to give that user rights (create session etc) for a specific pdb.Any help!
0 votes
0 answers
143 views

Oracle DB 19c installation stuck at the very beginning (Info: Checking whether the IP address of the localhost could be determined)

I have opened a CMD with Administrator credentials and opened "setup.bat" from there. But the installation gets stuck at the step "Launching installer". PFB Screenshot. As per the ...
0 votes
0 answers
54 views

how to efficiently move and compress LOBs in ORACLE?

community! I have a table with three SecureFile LOBs in it (lets name them A, B, C) and I want to compress them. At first I wanted to do it in three parts, every time moving and compressing one ...
  • 151
0 votes
1 answer
39 views

Migration MySQL to Oracle 19C error ORA-00942

I'm trying to migrate a simple MySQL test database to Oracle 19c using the migration wizard available in Oracle SQL Developer, the result is that the procedure create the user and the tables but the ...
  • 1
0 votes
0 answers
86 views

Upgrade Oracle DB from 12C to 19C with minimum downtime

We are planning to apply the below steps --> Export Live DB setup on the Oracle version 12C Import on the new DB setup on version 19C At this point, V12, and V19 schema structures will be exactly ...
0 votes
0 answers
51 views

How to change password expire duration in the alter user statement in Oracle?

I'm working with a 19c Oracle database. We usually reset passwords for users and set temporary ones by using the password expire option with the alter user statement. The issue I'm going through is ...
0 votes
1 answer
31 views

Oracle 19c create table result_cache clause syntax

I could not find the exact syntax for the "Result_Cache" clause in the Oracle 19c documentation for the CREATE TABLE statement. It mentions the values of DEFAULT or FORCE, but not the ...
  • 1,103
0 votes
0 answers
781 views

ORA-28759: failure to open file

I have implemented oracle wallet using orapki utility following this guide : https://stackoverflow.com/questions/63834638/how-to-change-protocol-for-oracle-database-connection-in-asp-net-core However, ...
  • 195
0 votes
0 answers
26 views

Extract data from BKP file or verify if the backup is encrypted

A specific system, previously using a non encrypted Oracle 19 database, has been updated in such a way that now the database is encrypted (same Oracle version). I have successfully verified that the ...
  • 101
0 votes
1 answer
304 views

Oracle Patch 19.17 fails with: patch 34086870: Archive::Zip->writeToFileNamed returned 4

The current oracle patch 19.17 and OJVM was applied with opatch apply successfully with no errors. Patch 34468114: WINDOWS DATABASE BUNDLE PATCH 19.17.0.0.221018 Patch 34411846: OJVM RELEASE UPDATE ...
  • 928
0 votes
0 answers
67 views

Low-level trace of calls to DBMS_CRYPTO.ENCRYPT: how?

In 19c we have a table with a BLOB column supposed to store scrambled XML data; the Java app calls a PL/SQL procedure that does an insert in this table, with a CLOB containing the full XML string to ...
  • 31
0 votes
0 answers
84 views

Oracle 19c installer froze/hangs

I've been trying to install Oracle 19c on windows 10. Whenever I attempt to run the setup.exe file, after having extracted the original zip folder download, the setup.exe file does not finish ...
  • 1
0 votes
1 answer
107 views

Recover deleted redo log files

I have the following problem: all redo log files from an Oracle 19C database have been deleted while the database was running. The database is running on a Linux server. When I try to connecting to ...
0 votes
0 answers
17 views

P&T: which approach to take with app constantly creating new tables

A customer is complaining about low performance. No cpu or memory bottlenecks observed on the system. The problem is that their app is constantly creating new tables that are used for a while, then ...
1 vote
1 answer
99 views

ORA-00957 View of JOINed tables with same column names

Is there a way to create a view of two joined tables so that all columns of both tables are in the view and there is a column of the same name in both joined tables and the columns are not explicitly ...
  • 493
0 votes
0 answers
18 views

Create oracle scheduler fails

I want to create a scheduler that runs everyday at certain time, but it is never created. Is this correct : DBMS_SCHEDULER.CREATE_JOB( job_name => 'LOG_MEMORY_USAGE', job_type => '...
  • 137
0 votes
0 answers
93 views

Oracle Reference Partition migration to Postgresql

We are in process of migrating from Oracle 19c to Postgresql v13. We have a table in Oracle which has numerical primary key and is range partitioned based on a date column. This table has 3 child ...
  • 101
0 votes
1 answer
52 views

applications connect to oracle scan ip

I have an Oracle 19c RAC cluster that contains two nodes (say, Node A and Node B). My applications are connected to the SCAN IP along with the service handled by Node A. Is this a good practice, or ...
0 votes
1 answer
341 views

Upgrade 12c client to 19c client

Does Oracle 19c client upgrade 12c client if installed or does 12c client have to be uninstalled prior to 19c installation?
0 votes
0 answers
86 views

Oracle 19c - Multiple If Conditions

create or replace TRIGGER trigger_name ... ... BEGIN IF SYS_CONTEXT (...) IN (...) THEN IF SYS_CONTEXT (...) NOT IN (...) THEN IF SYS_CONTEXT (...) NOT IN (...) THEN INSERT INTO owner.table_name (...) ...
0 votes
0 answers
643 views

Unified Audit record write to audit trail table failed with Unified audit disabled!

on a production database I keep on observing the following error: 2022-08-15T16:58:36.196692+02:00 Unified Audit record write to audit trail table failed due to ORA-4031. Writing the record to OS ...
-2 votes
1 answer
39 views

RMAN ORACLE issue

I have the issue when I run the command RMAN as mentioned below : Please any help
  • 1
0 votes
0 answers
301 views

Oracle 19c / Rman-10038: Database Session For Channel channel_name Terminated Unexpectedly

I am getting this error while database restore. This is the first time such an error has been getting from a process that has had no problems for a long time. Backup files are on NFS mount. Total ...
0 votes
0 answers
204 views

PL/SQL get the session ID (SPID) during a stored procedure on Oracle 19c

I'm trying to get the session ID (SPID) during a stored procedure on Oracle 19c. In Oracle 12c the following query was enough: select s.sid, p.spid, substr(s.username,1,20) MY_SCHEMA, s.terminal, p....
  • 1
0 votes
0 answers
45 views

Can I run scheduled job as sysdba?

I have user c##admin in my core DB (Oracle 19c), with "sysdba" privileges. I want it to select from a pdb using a database link without giving a password. assuming the following: PDB Name: ...
  • 812
0 votes
0 answers
34 views

Best approach to calculate PCTFREE for tables with high chained_row_ratio after ANALYZE TABLE xxx LIST CHAINED ROWS

On two different databases (Oracle 12.1, 19.11) I've seen in V$SESSTAT a high ratio of "table fetch continued row" of at least more than 10% and I'm searching a good approach to calculate a ...
0 votes
0 answers
59 views

Error ORA-00600 on startup

My oracle instance crashed and now when I try to start it I get this error: startup mount ORACLE instance started. Total System Global Area 3690986544 bytes Fixed Size 9141296 bytes Variable ...
1 vote
1 answer
106 views

Oracle 19 - RMAN can't connect to database

I have troubles with starting RMAN and connecting to target database. I start RMAN ($ORACLE_HOME & $ORACLE_SID env variables are set) [oracle@MY_MACHINE /]$ /u01/app/oracle/product/19.0.0/dbhome_1/...
  • 13
-1 votes
1 answer
395 views

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1600M ORA-01078: failure in processing system parameters

I'm getting the following error: ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1600M ORA-01078: failure in processing system parameters How do I fix this error?
0 votes
0 answers
25 views

Are there a logs to harvest on Oracle Active Data Guard instance?

We are trying to see if there is a way for cloud/SaaS-based( like AirByte or Fivetran) CDC/replicate provider to harvest logs on Oracle active data guard instance. Any ideas?
  • 1
1 vote
0 answers
607 views

impdp: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

I'm trying to import a large database, and after a while I get: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1' I know this has been asked before, but I can't find a clear ...
  • 111
0 votes
1 answer
62 views

In Oracle SQL 19c, how can I INSERT a new record into a supertype and its related subtypes in one statement?

I'm designing a property management database that will hold - OWNER, CUSTOMER, and STAFF information. As these use many of the same attributes, I intend to create tables for PERSON, ADDRESS and ...
2 votes
1 answer
175 views

Rotate passwords with zero down time

Big question: How to rotate passwords in an Oracle database in a zero downtime (ZDT) way? My current thought is to rotate the users. Originally, I had MY_USER that had all the tables and such. Now, ...
  • 123
0 votes
0 answers
36 views

Oracle 19c automatic indexing

It seems Oracle automatic indexing feature that was introduced in Oracle 19c works only on Oracle Cloud and not AWS RDS. Is my understanding correct (that AWS RDS doesn't support it)? Reference: https:...
0 votes
0 answers
51 views

Migrate Oracle database to new server

I am looking to migrate an Oracle database with 2 instances to a new server. Here is some quick info Old server: SLES 12.4 with Oracle 12.1.0.2.0 Standard Edition New Server: SLES 15.3 with Oracle 19....
  • 1
0 votes
0 answers
300 views

Noaudit and Drop Audit Don't Work for Oracle 19c

I've enabled unified auditing at our production database (ver. 19.14). Created policies for auditing all dml's and select queries. After seeing that it's filling up SYSAUX table, i decided to disable ...
0 votes
0 answers
121 views

Oracle 19c-ee CTX_REPORT.INDEX_SIZE and CTX_REPORT.INDEX_STATS cannot be executed

We created a simple search index, based on a 19c-ee instance of the official Oracle Docker images, with the following script: CREATE TABLE EVT ( ID VARCHAR2(36) NOT NULL, EVENT BLOB NOT ...
  • 11
0 votes
1 answer
45 views

How to get DML SQL of uncommited statements in Oracle 19c?

I'd like to know if there is a way to get the DML (insert, delete) SQL of uncommitted statements in Oracle 19c in my own session? For example, if I have typed some statements and I haven't committed ...
0 votes
1 answer
326 views

ODA X8-2M crossrestore with TDE wallet fails with: DCS-10001:Internal error encountered: failed to open the tde password based wallet

We are trying to crossrestore a TDE encrypted Oracle Database 19.12 on a new ODA X8-2M. TDE wallet has been successfully backedup (odacli create-backup -in CDBET015 -c TDEWallet) and transferred to ...
  • 928
0 votes
0 answers
599 views

When cloning a PDB over dblink in Oracle 19c, is it possible to use file_name_convert without specifying entire paths?

Context Oracle version: 19.13 On server 1 I have a production database, with a CDB named (for the purpose of this question) CDBPROD and a PDB named PDBPROD. The datafiles are distributed in multiple ...
0 votes
1 answer
379 views

What could be the reason for this invalid objects after trying to upgrade?

We recently wanted to upgrade our Database but didnt get to do it as we got a lot of Audit specific invalid objects, after looking online for ressources we couldnt find anything specific reason for ...
0 votes
0 answers
60 views

How to trickle down order by and limit in oracle views

I have oracle standard edition 2 v19 and we imitating partitions on huge tables using view with union all. all in all it is working well. until we need to sort. I would like to know if there is an ...
  • 467
1 vote
0 answers
102 views

How to check compatibility of PL/SQL written for Oracle 9i but now to be migrated to Oracle 19c

I have lots of PL/SQL scripts which were developed years ago for an Oracle 9i application which should be migrated to Oracle 19c. I have read that normally there shouldn't be major changes in the PL/...
  • 11
0 votes
0 answers
1k views

Set 'WE8ISO8859P15' character set for existing Oracle 19c DB while migrating 12c DB

I have a database in 12c (12.2.0.1) which I need to migrate to an existing live oracle 19c DB.(This DB already hosts a couple of live DBs’s) Character set of DB’s are as below: 12c -> ...
  • 1
0 votes
1 answer
119 views

Can I convert a local user to a common user in Oracle?

I have a local user in a pluggable database and it has data, objects etc. under its schema. Can I easily convert this user to a common user without losing its objects etc.? (Oracle Database 19c)
  • 103
0 votes
1 answer
397 views

How to create a custom database with 32k block size via DBCA silent mode?

I am trying to create an Oracle 19c single instance (warehouse) with dbca silent mode. The problem is, when I try the command below, it gets a warning: "Ora-0058: DB_BLOCK_SIZE must be 8192 to ...
0 votes
0 answers
195 views

Oracle 11g to 19c - Upgrade Error

We upgraded our test database from 11gR2 to 19c (19.12) (OS OL 7.9). After the upgrade, all the components in the dba_registry seem to be in the UPGRADED state, not VALID. At the same time, we ...
0 votes
0 answers
2k views

How to solve Error ORA-16810: multiple errors or warnings detected for the member?

Oracle Enterprise Manager 13.5 constantly reports Error ORA-16810: multiple errors or warnings detected for the member. ... Target type=Database Instance Target name=xxxx Categories=Availability ...
  • 928
0 votes
2 answers
774 views

How to connect to Oracle RAC from HOST

For a college project, I have to set up a RAC Instance and an application, I already managed to configure my RAC lab by using virtual machines by using this video guide, now I just need to program an ...
  • 103