Questions tagged [oracle-19c]
Oracle Database 19c. Please also tag oracle for search purposes
78
questions
-1
votes
1answer
17 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
2answers
16 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
0answers
16 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
0answers
26 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
0answers
29 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
0answers
26 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
|
|--...
0
votes
1answer
26 views
Get sequence value date?
I have an OOB system that has hundreds of tables. Each table has a ROWSTAMP column (integer) that gets populated by a trigger each time a record is created/updated.
All the tables & triggers in ...
0
votes
2answers
22 views
Matching strings from two columns in one column
I have two columns in an Oracle 19c db
C1
a,b,c,d
x,y,z
C2
1,2,3,4
1,2,3
I want to make a select query which will return one column like this:
C12
a1,
b2,
c3,
d4,
x1,
y2,
z3
I`m not able to use any ...
0
votes
1answer
45 views
Oracle 19c cannot shrink blob column
I deleted a bunch of old data from a schema, including BLOB data, and afterwards I tried to shrink and compact everything. I managed to shrink all tables (enable row movement, shrink space compact, ...
0
votes
1answer
67 views
Unable to create pluggable database on 19c using response file
I am trying to create a pluggable database using a response file, but it is giving me the error below, indicating that one of the mandatory parameters is missing. Although I have checked it multiple ...
0
votes
0answers
43 views
Oracle 19c Deinstall : Permission denied
I have an RHEL 7.7 box on which Oracle 12c is running. I have installed 19c on the same machine for the purpose of upgrading from 12c to 19c but need to uninstall it for some reason.
I get the below ...
0
votes
1answer
26 views
ORA-12631 using Database Links with Oracle DBMS 19c on Windows Server 2019
We had a set of long-time Oracle 12c Database installations (multiple instances on separate VMs) on Windows Server. Over the past year we transitioned to Oracle 19c on Windows Server 2019. We found ...
0
votes
1answer
14 views
remote oracle connection from AIX to Linux Redhat
I want to connect oracle database from AIX to Linux using user id and password only. For that I have changed
tnsnames.ora
RATARA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT ...
0
votes
2answers
75 views
Can I change the profile of oracle sys user?
Are there side effects of changing the profile of sys to any other than default?
Our monitoring keeps telling us the password of sys has expired. The "Default“ profile has a standard limit of 180 ...
0
votes
1answer
446 views
Oracle 19c installation stuck at creating and starting oracle instance
I'm trying to install oracle 19c but it's stuck at 52% for over 7 hours. So cancelled it and uninstalled it. I have started installing again but still stuck at 52% that is in creating and starting ...
0
votes
0answers
62 views
Oracle 19 ORA-01450: maximum key length (6398) exceeded
I am using Oracle 19 and recently changed the collation to XGERMAN_AI. This required to change the MAX_STRING_SIZE to be EXTENDED as in the following link
https://docs.oracle.com/database/121/REFRN/...
3
votes
1answer
482 views
ORA-39014 import in Oracle 19c from DMP file of Oracle12c
I have been testing out expdp/impdp of databases from 12c to 19c( newly created database) but one db have game me this error:
nohup impdp system/****@CKLPROD CONTENT=METADATA_ONLY PARALLEL=4 DIRECTORY=...
0
votes
1answer
159 views
Connection to Oracle DB 19c fails when listener is set to the host IP address
I am new to Oracle DB and need help in solving the following issue.
I am using sqlplus (SQL*Plus: Version 21.1.0.0.0) to connect to the Oracle DB 19c.
Statement: I am able to connect to the Oracle DB ...
0
votes
0answers
27 views
In what sort of way “v$transaction” view will help DBA's to improve the performance of the query?
I've just started learning some DBA tips and techniques in Oracle and I came across v$transaction view. I've read some articles regarding this view but some things are still ambiguous ! I want to know:...
0
votes
1answer
128 views
Linked Server to Oracle error ORA-01804
Migrating SQL Server to a new machine. Migration involves setting up a number of linked servers, some SQL Server, Oracle and Teradata. No issues with SQL Server or Teradata servers, but every Oracle ...
2
votes
1answer
38 views
Oracle: Decreasing PCTFREE on large table
Question about Oracle Database Enterprise Edition version 19.10.0.0.0 running as a standalone instance.
I have a table with billions of rows. The table has always had PCTFREE set to 10.
It turns out ...
0
votes
0answers
183 views
Oracle 19c with SAP System - ORA-12154: TNS:could not resolve the connect identifier specified For Physical Standby
Oracle 19c + SAP system. On primary side I have a problem when transporting logs to Data Guard side.
Outputs from primary side:
SQL> select status, error from v$archive_dest where dest_id=2; ...
0
votes
1answer
359 views
Does Oracle 19c support Ubuntu?
I am trying to install Oracle 19c, and It needs X-display so I typed xhost +, but it doesn't work. Any ideas to solve this problem? Also, I want to know that Ubuntu literally support Oracle 19c.
1
vote
0answers
52 views
How to improve Oracle Standard Edition's performance for testing? [closed]
There's a great post on StackOverflow about improving Postgres performance for testing.
https://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing/9407940#9407940
However, ...
0
votes
1answer
27 views
Oracle database 19C moving back and forth with time without resetlogs [closed]
my client have a oracle database 19C on windows server 2016
for a business reason he need to be able to move back in time to specific date/time and modify some data and then move forth to the current ...
0
votes
0answers
21 views
Is it possible to select from procedure\function when the PDB is an argument without connect?
I have the following function in oracle 11g.
Create or Replace function get_col_value(
schema# in varchar2,
table# in varchar2,
column# in varchar2,
rowid# in varchar2)
Return varchar2
Is
v_cmd ...
0
votes
1answer
55 views
Is it possible to give PDB name to a procedure and select from it?
The following example is not working, I just trying to show what I'm trying to do.
Given table:
-- this table is located at the CDB
create table t1 (tab_name varchar2(35))
/
-- this proc is located at ...
0
votes
1answer
36 views
How to select from pdbs with a cdb user?
I have several store procedures, which analyze oracle logs using log miner. These procedures run on CDB user C##ADMIN which created for this manner.
Now I want to compare the logged values to the live ...
0
votes
0answers
38 views
Oracle 19c standby - redo transport errors
I have a 19c RAC Standby database on RHEL6 using dataguard, however, I’m currently getting a “ORA-16737 redo transport device dir standby has an error” msg. I’ve tried recreating the password file and ...
0
votes
0answers
29 views
SQL developer cannot connect to external databases. Only local ones
IO error: The Network Adapter could not establish the connection.
Local databases work fine, but external one are returning me this error. I reinstalled once Oracle DV, and in the first time I ...
1
vote
2answers
62 views
Select failed from V$LOGMNR_CONTENTS when called from a procedure
Assuming the following user with these privileges granted:
-- create admin user on CDB
CREATE USER c##myadmin IDENTIFIED BY myadmin DEFAULT TABLESPACE system QUOTA UNLIMITED ON system ACCOUNT UNLOCK
/
...
0
votes
1answer
41 views
How to quota a CDB only tablespace to a CDB user?
I can create a CDB tablespace like this: (all using: sqlplus / as sysdba)
-- create unique table space for admin
CREATE TABLESPACE admints DATAFILE '/path/to/admints.dbf' SIZE 20M AUTOEXTEND ON;
I ...
0
votes
2answers
116 views
“user does not exist ” when calling DBMS_LOGMNR.START_LOGMNR
I have a CDB user called "MYADMIN" and I'm trying to make it connect to log miner.
-- enable calling admin username on CDB
ALTER SESSION set "_ORACLE_SCRIPT"=true
/
-- create ...
0
votes
0answers
36 views
Why does json_equal use so much PGA memory and how to avoid it?
I have an Oracle 19c database and a schema with two tables (let's call them L and R). They have the same structure: Two VARCHAR2 columns I'll call T and J. The second one has an IS JSON STRICT ...
0
votes
0answers
13 views
What does a NULL last_executed column mean in the Oracle data dictionary table sql_plan_baselines?
Using Oracle DBMS 19c on Windows server. The static data dictionary view DBA_SQL_PLAN_BASELINES has a lot of rows (over 160k) and I'm trying to figure out why. The vast majority have a LAST_EXECUTED ...
3
votes
1answer
55 views
Ordering CONNECT BY siblings
I have an hierarchical query that uses CONNECT BY:
select
wonum,
parent,
classification,
classstructureid,
division,
worktype,
status,
glaccount,
fircode,
...
0
votes
1answer
969 views
ora-03114 not connected to oracle
Since the upgrade to the 19C Oracle DB (before 12C) I receive randomly those ORA-03114 error message's.
Before the upgrade I never received it. Any idea's what exactly why those error messages pops up ...
0
votes
0answers
70 views
Oracle writes to SSD drive are really slow
My customer recently ported their database to a new server that has an SSD drive.
This new server uses Windows 2016 Server OS, and the SSD drive model is a DELL PERC H740P Mini
The good news is the ...
0
votes
1answer
54 views
IMPDP Job Failing with ORA-54002
I am trying to import a dump file from an 11g database into a 19c database instance. I am running the job as SYSTEM as recommended by Oracle. The job starts but quickly devolves into failing SQL ...
0
votes
1answer
185 views
logon denied for oracle wallet user
Following a video tutorial on oracle wallets: https://youtu.be/LLZzUNb9ALU
The db server is run from oracle's official docker container.
The steps I have done are as follows:
On server shell, ran sql ...
0
votes
2answers
82 views
Report based on MV: Deliberately make the report fail if MV is out of date?
I have a query that is used in a BIRT report (in IBM's Maximo Asset Management platform).
I'm considering storing the query in a materialized view in order to improve performance and reduce the load ...
0
votes
1answer
68 views
Migrating data from 11G Linux to 19C on Windows
I'm using datapump to move data from 11.2.0.4 on Linux to 19C on Windows. It seems to be working except for some objects in the system schemas. Is there any reason to bring these schemas across or can ...
0
votes
1answer
65 views
Oracle Database Vault: Changing DV Owner and DV Account-Manager passwords hangs PX Deq: Execute Reply/row cache lock
When changing the password of the users mentioned above the sessions hangs. And it seems to be a deadlock. When changing the password it seems that two sessions are spawned:
Blocking session
C##...
0
votes
1answer
62 views
Oracle 19c Standard Edition RPM installation
I'm wondering if it's possible to install Oracle Standard Edition from RPM, not Enterprise Edition. It's possible to choose edition when you do 'runInstaller', is it possible to set some parameter ...
0
votes
0answers
109 views
Oracle 19c express manager not loading, listener will not register https port after exec dbms_xdb_config.gethttpsport()
We just set up a new oracle 19c install on a VM Windows Server 2020. I have been struggling trying to get the Express Manager working. At the end of the installation Oracle notified me that I can ...
1
vote
1answer
67 views
Why am I able to create MV logs using PK — even though there is no PK?
I have a table that does not have a primary key:
I'm able to create MV logs on the table — without specifying whether to use the primary key or the rowid:
create materialized view log on maximo....
0
votes
1answer
50 views
Materialized view logs — with condition?
I've created materialized view logs on a WORKORDER table in an Oracle 19c database.
create materialized view log on my_workorder_system.workorder with rowid;
The plan is to integrate the WORKORDER ...
0
votes
1answer
383 views
ORA-12705: Cannot access NLS data files or invalid environment specified with jmeter test
I have trying to execute a simple test with jmeter in Oracle 19.7 database. This is my lang configuration in database
SQL> select * from nls_database_parameters;
...
NLS_NCHAR_CHARACTERSET ...
0
votes
1answer
226 views
Materialized view not purging (over dblink via view)
I've created a materialized view between a primary system (Oracle 18c) and an external system (Oracle 19c):
create materialized view primary_system.workorder_mv
build immediate
refresh force
on ...
0
votes
0answers
607 views
Oracle - Set Object to NonEditionable
I am having an issue with Editioning in an Oracle 19c database. I have never heard of this feature before today, but I have found that somehow a number of objects in the database have had their ...
