Questions tagged [oracle-19c]
Oracle Database 19c. Please also tag oracle for search purposes
138
questions
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"...
- 103
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 ...
- 228
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 ...
- 9
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 ...
- 3
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?
- 1
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 (...) ...
- 29
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 ...
- 9
-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 ...
- 29
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 ...
- 21
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 ...
- 1
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:...
- 25
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 ...
- 123
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 ...
- 203
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 ...
- 423
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 ...
- 1
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 ...
- 123
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 ...
- 29
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