Questions tagged [oracle-19c]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
7 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:...
user avatar
0 votes
0 answers
8 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....
user avatar
  • 1
0 votes
0 answers
29 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 ...
user avatar
0 votes
0 answers
29 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 ...
user avatar
  • 11
0 votes
1 answer
23 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 ...
user avatar
0 votes
1 answer
52 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 ...
user avatar
  • 868
0 votes
0 answers
21 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 ...
user avatar
0 votes
1 answer
60 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 ...
user avatar
0 votes
0 answers
27 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 ...
user avatar
  • 373
1 vote
0 answers
48 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/...
user avatar
  • 11
0 votes
0 answers
44 views

Oracle RDS Logminer ORA-01291 Missing Log File?

I have an Oracle RDS database I manage, and I need to be able to pull changes from the database for replication to another system. Once connect to the database, below is the commands I run. EXEC ...
user avatar
  • 101
0 votes
0 answers
103 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 -> ...
user avatar
  • 1
0 votes
1 answer
32 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)
user avatar
  • 103
0 votes
1 answer
110 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 ...
user avatar
0 votes
0 answers
72 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 ...
user avatar
0 votes
0 answers
364 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 ...
user avatar
  • 868
0 votes
2 answers
124 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 ...
user avatar
  • 103
0 votes
0 answers
42 views

See Max Simultaneous Sessions Per User

In an effort to set a reasonable sessions_per_user profile setting for shared database accounts or other non-unique account (ie. an account an application uses to log into the database for all app ...
user avatar
0 votes
1 answer
259 views

How do I SHOW TABLES in Oracle Database?

I'm trying to do a SHOW TABLES command in my Oracle Database 19c as documented here. But when I run that command all I see in the output of SQL Developer is this: Show tables handled. How can I get ...
user avatar
  • 115
0 votes
1 answer
41 views

Does trailing wildcard use index? (where column like 'value%')

I have a query on a Varchar2 field in an Oracle table: select column from tbl where column like 'value%' That query uses a trailing wildcard. Question: Is Oracle capable of using an index on that ...
user avatar
  • 1,373
1 vote
0 answers
33 views

Extremely slow updates to small Oracle table from rails app (oracle r12 and r19)

I'm not sure if this is a rails issue, or a database issue, but as this seems to be a schema specific issue, I'm looking at it from the database side first. (Other customers with the same setup on ...
user avatar
0 votes
0 answers
1k views

OS Authentication might be disabled for this database

LINUX X64 193000 software installed on "Red Hat Enterprise Linux Server 7.9 (Maipo)" DBCA: GUI or silent install always fails with: [FATAL] [DBT-05509] Failed to connect to the specified ...
user avatar
  • 187
0 votes
0 answers
78 views

Oracle session and process reaching max utilization issue with Oracle 18c+Tomcat9

Currently we migrated to Oracle 18c+ Tomcat 9 after which we are experiencing high utilization issue with both processes and sessions. INST_ID RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION ...
user avatar
0 votes
0 answers
9 views

How to check if a new Oracle PDB has been replicated successfully to the standby side?

How can I check if a newly plugged in 19c PDB on the primary has been replicated successfully (automatically) to the DataGuarded standby side?
user avatar
  • 29
0 votes
0 answers
18 views

Query xml multinode syntax

I have a table containing an XMLTYPE column that I have to parse and display contained values one per line: Example 1 : <c2>VLAN1</c2><c2 m="2">VLAN2</c2><c2 m=&...
user avatar
  • 1
0 votes
2 answers
420 views

Rebuilding an Oracle 19c Standby Database after plugging in a new PDB

I have an Oracle 19c Dataguarded physical standby DB setup running on Linux 7. The container DB had one PDB but I've now just plugged a new PDB into the primary. What do I need to do to get this new ...
user avatar
  • 29
0 votes
0 answers
82 views

Problems using catcon.pl

We are investigating the use of catcon.pl to launch scripts on multitenant Oracle DBs. In this case, with APEX upgrade scripts. For example, the apexins.sql script, is made to give it the arguments at ...
user avatar
0 votes
1 answer
361 views

ORA-12560: TNS:protocol adapter error logging into Oracle as Sysdba

I have Oracle 19c installed on my windows 10 machine. When I try to log in as sysdba I am getting an ORA-12560: TNS:protocol adapter error error: sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - ...
user avatar
0 votes
1 answer
205 views

Automatically materialize CTE? (instead of temporary table CREATE and INSERT)

I’m a novice trying to learn about query optimization and temporary tables in Oracle. The examples I’ve seen for Oracle temporary tables involve CREATE TABLE and INSERT INTO statements. CREATE ...
user avatar
  • 1,373
0 votes
0 answers
72 views

JSON Search index usable with 'LIKE' but not with '='

We are seeing an issue with Oracle 19c and a JSON search index. Given: A table GEO containing a column JSON_DATA with JSON data and an IS_JSON constraint An index created like this: create search ...
user avatar
0 votes
0 answers
22 views

Oracle Text truncate words to 64 CHARS but token limit is 64 BYTES

I'm using Oracle 19c. I have a table with a VARCHAR2(4000) column for which I'm creating a full-text index using Oracle Text. The SQL creating the index is as follow: begin ctx_ddl.create_index_set('...
user avatar
1 vote
1 answer
80 views

Expdp partitioned table, Impdp Into non-partitioned table same structure

I have a partitioned table X in my production database. I want to expdp it from production & impdp the same table X with data to my test database. As I have a standard license in the test database,...
user avatar
  • 135
1 vote
0 answers
16 views

all_views is not showing a view even I have access to the view

I'm having the following issue: This select does not retreive anything: select 1 as exist from all_views where view_name='FND_USER_RESP_GROUPS' and owner='APPS' and rownum=1; But If I execute this ...
user avatar
1 vote
1 answer
195 views

Updating a Json column that contains a JsonArray using Json_transform() function in Oracle Database 19c Enterprise Edition

I have a table that keeps USER data. Here is my table structure: CREATE TABLE "USERS" ( "ID" NUMBER(16,0) PRIMARY KEY, "USER_NAME" VARCHAR2(85) UNIQUE NOT NULL, ...
user avatar
  • 111
0 votes
1 answer
30 views

Can analytic functions add or remove rows from a resultset?

I'm a novice who is starting to learn about Oracle analytic functions (window functions). I know from experience that it's important to fully understand how SQL mechanisms work when using them in ...
user avatar
  • 1,373
0 votes
0 answers
32 views

ETL with Oracle: how to do an isolated run without overwriting previous results

Objective I'm refactoring ETL. ETL is imlemented as a chain of queries submitted to Oracle one-by-one. While executing, ETL creates/overwrites about 20 output tables. For sake of testing (including ...
user avatar
  • 387
2 votes
2 answers
233 views

Zero/NULL Case Trick

In the book Getting Started with SQL, Thomas Nield talks about a technique he calls the zero/null case trick: There is a simple but powerful tool that can apply different filtering conditions to ...
user avatar
  • 1,373
0 votes
1 answer
103 views

oracle goldengate replication

Please I need help. Actually i am working on oracle 19c to perform a data base replication using the goldengate. I created two data bases (source and destination) the 3 processes (extract, pump and ...
user avatar
0 votes
0 answers
64 views

Oracle 19c Select Query with Database Link

How can I use the following query with database link: set pages 999 col "Size MB" format 999,999,999 col "Objects" format 999,999,999 col OWNER for a25 select obj.owner "Owner&...
user avatar
0 votes
0 answers
353 views

Oracle mview refresh taking long time

the customer I work for is used to launch a script to refresh mviews on its db. Refresh command for all mviews is issued in the following way: DBMS_MVIEW.refresh('"OWNER"."MVIEW"','...
user avatar
0 votes
2 answers
200 views

Oracle 19c - find primary DB information from a mounted standby

I have a (probably simple) query about how to find an Oracle 19c primary database's host by querying a mounted standby using sqlplus. I can get the primary name as follows: select ...
user avatar
  • 29
0 votes
0 answers
168 views

Oracle 19c new Installation Hostname and IP Address Issue

I have installed Oracle 19c DB in my windows VM and it gave me below error, I used the oramtsctl.exe command to attach the Hostname and IP address, but hostname addition failed. Now I am only able to ...
user avatar
0 votes
0 answers
193 views

Reinstalling Oracle 19c on Windows 10. Fatal Error in Oracle Database Configuration Assistant

I have tried many times to reinstall Oracle 19c. Every time, when I run setup.exe I get an error on the installation step that says [INS-20802] Oracle Database Configuration Assistant Failed. In error,...
user avatar
0 votes
1 answer
193 views

How to include the oracle database name to os audit trail?

My DB settings: Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.12.0.0.0 SYS@CDBXXX1> unified_audit_common_systemlog string ...
user avatar
  • 868
-1 votes
1 answer
63 views

ORA 600 and 7445 after upgrade from 18 to 19C

I'm getting errors ORA 600 and 7445 in alert log after upgrading Oracle from 18 to 19C, the error mostly occurs on merge statements, below is the error message: Errors in file /db1/oracle/diag/rdbms/...
user avatar
  • 379
0 votes
2 answers
34 views

How to check the source of analysis task in Oracle Performance Analyzer?

We have provided sql tuning set as input to the analysis task of performance analyzer variable l_task_id VARCHAR2(64); exec :l_task_id:=dbms_sqlpa.create_analysis_task( sqlset_name => '<...
user avatar
0 votes
1 answer
95 views

Oracle TDE - opening/closing an encryption wallet

I have a quick question relating to Oracle TDE. Could somebody please explain why both of the following pairs of commands appear to work when opening/closing an ecryption wallet? Is the wallet ...
user avatar
  • 29
0 votes
0 answers
376 views

UTL_HTTP.get_response is not able to read special character in Supplier name

I'm making a call to JSON based REST API from PL/SQL. Whenever there is special character in Supplier name, UTL_HTTP.get_response gives this error: ORA-29268: HTTP client error 400 - Bad Request For ...
user avatar
0 votes
0 answers
69 views

Best RMAN Strategy for Oracle VLDB 30TB in NOARCHIVELOG mode

I would like to have your ideas regarding how to optimize backup/restore in a VLDB Oracle Database Environment: RAC 19c 4 Nodes Version 19c Size: 32TB Mode: NOARCHIVELOG Let me explain some ...
user avatar
0 votes
0 answers
93 views

Oracle Materialized Views best practice for refresh

I have the following nested MVs order: tab1 tab2 tab3 |----> MV join the 3 tables | |-----> MV aggregate | |------> MV aggregate | |--...
user avatar
  • 373