Questions tagged [oracle-19c]
Oracle Database 19c. Please also tag oracle for search purposes
116
questions
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:...
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....
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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/...
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 ...
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 -> ...
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)
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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=&...
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 ...
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 ...
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 - ...
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 ...
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 ...
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('...
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,...
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 ...
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,
...
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 ...
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 ...
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 ...
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 ...
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&...
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"','...
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 ...
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 ...
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,...
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
...
-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/...
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 => '<...
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 ...
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 ...
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 ...
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
|
|--...