Questions tagged [oracle-19c]
Oracle Database 19c. Please also tag oracle for search purposes
64
questions
0
votes
0answers
18 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/...
2
votes
1answer
107 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
59 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
24 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
55 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
36 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
72 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
82 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
49 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
22 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
20 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
35 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
30 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
12 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
22 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
43 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
27 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
52 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
23 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
11 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
51 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
266 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
38 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
42 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
44 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
42 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
37 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
44 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
67 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
51 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
43 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
210 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
138 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
331 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 ...
2
votes
3answers
159 views
Oracle allows inserting into table even after revoking quota
I am studying creating users and granting roles and I have come across this scenario where I grant unlimited quota to a user, insert into the table and then revoke the quota. I expected that after ...
1
vote
1answer
1k views
Error “RMAN-04006: error from auxiliary database” in the middle of duplicate executiion
I'm trying to create a standby database with duplicate command.
Primary : tntdb19
Standby : mntdb19
The duplicate command begins but fails after some time
[oracle@monta191 admin]$ rman target sys/...
0
votes
0answers
43 views
Why Oracle 19c generating error while installation?
I am trying to install Oracle 19c Enterprise Edition.I am using Windows 10 Home.For any additional required information please tell me in comments.
1
vote
0answers
65 views
Reduce file header block
I'm in the middle of my first Statspack analysis, and one of the most time consuming events is Buffer Busy Waits (around 30% time). I checked out the Buffer Wait statistics, and it seems like the most ...
0
votes
1answer
604 views
Why Oracle 19c Database EM Express Webpage is not opening in Microsoft Edge?
I have recently installed Oracle Database 19c on my Laptop which has Windows 10 OS. Now, I want to open the localhost:5500/em page in Microsoft Edge browser, but when I try to do so, the webpage does ...
0
votes
4answers
582 views
What privileges do I need to change the password of sys in an Oracle Database?
Our identity management tool wants to change the sys password regularly. It fails with the ORA-01031. What privileges or roles do I need to grant the identity management tool user to be able to change ...
0
votes
2answers
390 views
Error 0xc000007b with Oracle 19c
As our (32-bit) application uses the Oracle client for communication with the Oracle server I have set up a test environment on a Microsoft Windows Server 2019 Datacenter. I have installed the Oracle ...
1
vote
1answer
135 views
Oracle: Inserting into table error - either duplicate column name or invalid datatype
I'm trying to insert data from an external table.
INSERT /*+ ignore_row_on_dupkey_index ( consruct ( construct_id ) ) */
INTO construct
(construct_id,
n_term ,
enz_name,
...
1
vote
2answers
1k views
Can an Oracle 19c database dblink to an Oracle 10.2.3 database?
I have an Oracle 12.1.0.2 database that dblinks to an Oracle 10.2.0.3.0 database.
I am upgrading the Oracle 12.1.0.2 database to 19c (12.2.0.3).
Will my dblinks to the Oracle 10.2.0.3.0 database ...
1
vote
1answer
34 views
ORACLE DB Connects only when I do not specify SID
I have an Oracle 19c database in a Unix server.
SQLPLUS command connects only when I do not specify the SID.
sqlplus system/manager
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 20 12:37:30 ...
2
votes
1answer
4k views
UTL_FILE directory name changes oracle 19c
I've scripts where UTL_FILE.FOPEN is used and the parameter passing for directory is an absolute path i.e., /asr/file/path and the corresponding oracle directory name as ASR_ABC but after up-gradation ...
1
vote
2answers
57 views
Column name on NOT NULL constaint violation not shown
I'm using an Oracle 19 DB that is structured into multiple layers by using DB users. Here is a simplified overview of the structure:
User DATA: Has the table XTEST and the view TEST. The view is ...
2
votes
1answer
4k views
Oracle 19c database instance doesn't register with listener
I have just installed an oracle 19c (19.3.0.0.0 to be exact) database on a centOS 8 virtual machine. The databases instances can all be started with sqlplus on the host machine. I have set up listener....
0
votes
0answers
25 views
autonomous database in two regions
Backgroup on the autonomous database
For the last couple of years Oracle have offered a "autonomous" or "self driving" database in their cloud which is only available on the Oracle cloud. If you ...
0
votes
1answer
299 views
What permissions are required for complex cross-schema materialized view in Oracle?
I have a complex cross-schema query that I'd like to create as a materialized view in Oracle 19c (although the database has been ported forward from numerous historical versions of Oracle). This ...
