Questions tagged [oracle-12c]
Oracle Database 12c. Please also tag oracle for search purposes.
868
questions
0
votes
1answer
14 views
Oracle 12cR2 RMAN - ORA-01547, ORA-01194, RMAN-06054
Oracle 12cR2.
Error:
channel default: deleting archived log(s)
archived log file name=+RECO/.../thread_1_seq_166200.26582.1054942673
RECID=62 STAMP=1054943183
archived log file name=+RECO/.../...
0
votes
1answer
20 views
Read explain results from oracle database
hi currently i have query like this on oracle database 12
Query Detail because script is too long if input here
the query is too long execute time
from explain results i got this
PLAN_TABLE_OUTPUT
...
0
votes
1answer
15 views
Enabling TLS and TLS-MA simultaneously for different clients of a Oracle DB
We have a requirement where we want to enable TLS-MA for some of the clients connecting to a specific Oracle database while the other clients can continue to use TLS with server certificate.
We are ...
0
votes
1answer
19 views
Can't create view using a role
I am learning Oracle and have to do roles. I created an c##admin from a sys, granted him all grants. Then I created a c##manager_role and c##manager. I granted this role to c##manager. After that I ...
0
votes
0answers
38 views
How can I call a SQL Server stored procedure from Oracle and retrieve a scalar return value?
I'm developing a PL/SQL solution in Oracle Database Enterprise Edition 12.1.0.2. I'm calling stored procedures in Microsoft SQL Server 2014.
I am using DG4ODBC with the DBMS_HS_PASSTHROUGH package to ...
1
vote
0answers
32 views
Anomalous performance of mass INSERT in Oracle
Can you please help me diagnose, explain, and possibly solve the
problem of unstable peformance of mass insertions in Oracle?
I need periodically to load large amounts of data into an Oracle
database. ...
0
votes
1answer
18 views
When I set Datestyle to 'SQL, YMD' all queries still return as 'SQL, MDY'
I am working on a database migration from Oracle 12c to Postgresql 12.
We must keep the same date format as the program interacting with this database is written in COBOL and should not be changed.
...
0
votes
1answer
34 views
ORA-01017: invalid username/password; cannot login with other users except sys user, Oracle Database 12c?
I have setup Oracle Database 12c on my local machine. It was working fine initially but now I cannot login to users' account except the sys user. I have altered users' passwords and tried logging in ...
0
votes
0answers
15 views
Impossible to create an SQL Server function that calls an Oracle function?
I have been trying too many hours to create an SQL Server Scalar Function that calls an Oracle function.
Imagine you have a function in oracle named "Stock_Orcl" that returns the stock for a ...
0
votes
1answer
28 views
Understanding Logging Priority & Options in Oracle DB
From my understanding once we switch on database logging, the entire DB goes into logging mode and generates redo logs.
I want to categorically exclude/include some tables/tablespaces from this ...
0
votes
1answer
29 views
How do I exclude unchanged fields in Flashback query resultset?
Is it possible to exclude unchanged fields in Flashback query resultset?
Consider I have following table
create table first_table
(
id int generated as identity,
name NVARCHAR2(1024),
age ...
0
votes
0answers
27 views
Changes in OraOleDB v18
I use OraOleDB (Oracle's OleDB implementation) in a C++ application on Windows to create tables and insert rows. In the application it is also possible to connect with Oracle using ODBC through OleDB.
...
0
votes
1answer
79 views
ORA-00932: inconsistent datatypes: expected CHAR got NUMBER
I am trying to SUBSTR the first 3 character in use this query -> CASE WHEN (RMSTMP_PNG.ota_activity_lotinfo.KEY = 'TestProgram') THEN TO_CHAR(SUBSTR(RMSTMP_PNG.ota_activity_lotinfo.VALUE,1,3)) ELSE ...
1
vote
1answer
35 views
Selecting a record based off conditions CLOB
I have a table with a column storing JSON data as a CLOB. The JSON has a 'miscData' field that is made up of an array of JSON objects. Each object has 2 keys which are always the same, but the values ...
0
votes
2answers
23 views
Recursive multiplication
How can I get ASSY_EXT_QTY to be the quantity of all the path?
IE:
LVL QTY ASSY_EXT_QTY
1 1 1
2 3 3 1*3
3 2 6 1*3*2
...
I thought making a path but for the quantities and ...
0
votes
1answer
20 views
How to enable “only” drop partition DDL for Oracle Golden Gate?
I'm struggling with how to do this, and hoping somebody could assist with some ideas.
Oracle Golden Gate - general question. Version shouldn't be specific, however, I am currently running on:
Golden ...
0
votes
1answer
87 views
CREATE VIEW WITH LEFT JOIN - FILTER RIGHT DEPENDING ON LEFT
I am using Oracle 12.1.
I have the following tables, simplified for the question :
(Note that the XXX for entity ID does represent the same ID being repeated)
Events
date_event | entity_id | used
-----...
0
votes
0answers
60 views
Dbca hangs at 59%
Im creating database in oracle 12.2.0.1 on windows 2012 r2 64 bit and Dbca hangs at 59% of completion in db clone step.
I've checked the dbca logs and it's stuck in datapatch.bat step.
When I googled ...
0
votes
0answers
35 views
Number of Field in CSV File does not match with number of field in External Table
Hi is there a way to reject a record with excess csv field.
For example:
CREATE TABLE Table1 (
Field1 VARCHAR(255),
Field2 VARCHAR(255)
)
ORGANIZATION EXTERNAL (
TYPE ...
0
votes
0answers
4 views
How to appy database security patches in an oracle failsafe environment
We have 4 databases in oracle failsafe cluster.
2 are dc(primary dbs) in failsafe cluster and 2 are dr(standby dbs) in failsafe cluster.
Can anyone provide steps to apply patches to these databases.
0
votes
0answers
11 views
Oracle failsafe
Can anyone guide me on how to integrate an existing database to oracle failsafe cluster?
Any links or websites where steps are given.
Thank you
0
votes
3answers
64 views
Oracle PL/SQL does not work — bind variable not allowed
Oracle 12.2 PL/SQL
When running:
declare
s_sql varchar2(200);
begin
s_sql := 'dbms_hs_passthrough.execute_immediate@mylink' || '(''exec sp_get_names'')';
execute immediate 'begin :x; end;' ...
0
votes
0answers
21 views
Oracle 12cR2 - ORA-00905 When Creating View
I want to create a view as below:
CREATE OR REPLACE VIEW "USERNAME"."VIEWNAME" ("columnName", "columnName", "columnName", ...) AS
SELECT DISTINCT ...
0
votes
1answer
36 views
Oracle 12cR2 - How To Create DDL Script Of A View With All Dependencies and Permissions
I have a view in my production database and I want to create same view in my test database.
I tried this commmand:
select dbms_metadata.get_ddl('VIEW','VIEW_NAME','VIEW_OWNER') from dual;
It ...
1
vote
1answer
67 views
How to access oracle PDB remotely?
I have create oracle 12c instance with 2 PDBs, I am able to connect to CDB from python using cx_Oracle module but not sure how to connect to PDB.
-1
votes
1answer
48 views
Oracle index analyze stats - managed by whom?
Some questions about managing indexes.
We saw in some cases where indexes weren't analyzed in weeks, even though data was inserted and queried from them - using conditions that use these indexes. The ...
1
vote
1answer
31 views
Oracle multiple databases only able to access one database
I am new to oracle. I've installed oracle 12c(required to be this specific version) in my windows pc with no problem. I created one database named LOCAL using Database Configuration Assistant. Then i ...
0
votes
2answers
770 views
How to solve Vendor Code 17002 when connecting to a remote Oracle database?
I have an Oracle database 12c standard edition release 12.2.0.1.0 running on a Linux instance of AWS ec2. When I try to connect to it remotely from my machine (macOS) using SQL Developer I get an IO ...
0
votes
2answers
49 views
Oracle 12c - Insufficient Privileges When Trying To Create A Trigger With SYS User
I want to create a trigger for CRE schema. I'm trying to create this trigger with SYS user but I have insufficient privileges error.
My trigger:
CREATE OR REPLACE TRIGGER CRE.TRIGGER_NAME
AFTER LOGON ...
0
votes
1answer
66 views
What does Oracle impdp do when a name clashes with a materialized view or synonym?
I have a production Oracle database, and I want to export tables, data, views, materialized views, synonyms, etc, to import into a development Oracle database. Actually, this is part of my job, and we ...
1
vote
1answer
58 views
Oracle 12c recovery without system file
Scenario:
Deleted system files (dbf files); and trying to recover database back to normal using available control files, and some redo logs.
Backup is not available, nor are archived redo log files
...
0
votes
2answers
46 views
Oracle 12c - Logically There Is A Redo Group But Not Physically - Database Can't Open
I have an Oracle 12c Database for my enterprise manager.
I could not connect to enterprise manager because the database was closed.
I opened listener. However, the database remained mounted mode. When ...
0
votes
0answers
37 views
Pass Variables to SQLDeveloper Report in anonymous block
I can pass variables to anonymous block of this form
SQL> set serveroutput on;
SQL> DECLARE
a number := &i_nr;
BEGIN
.....
But it doesn't works into SQLDeveloper PL/SQL DBMS Output (...
1
vote
1answer
33 views
normal Linux user for oracle database dumps
is it possible to allow normal linux user " neither root nor oracle " to be able to execute expdp and impdp and to have access to dpdump directory with rw access on oracle database 12c ?
i ...
0
votes
0answers
8 views
Oracle Audit Vault Create Custom Interactive Report
I have installed and configure Oracle Audit Vault server and i deploy my production database environment to Audit Vault which is sys.aud$ table.
I can get predefined reports which is like entitlement ...
0
votes
0answers
19 views
Import with Network link fails with ORA-01400
Oracle 12.1.0.2.0
Setup a simple Import using Network Link, into same database
Using REMAP_TABLE and REMAP_SCHEMA options.
Full import.prm file is:
NETWORK_LINK=mylink
NOLOGFILE=YES
CONTENT=...
0
votes
2answers
21 views
Creating roles and granting rights to the role
I wanted to create a role called "user_updates" and this role should have the rights "table_note_updates".
The rights called "table_note_updates" is already available in ...
1
vote
0answers
43 views
Oracle - Monitoring tablespace warnings and critical events via Microsoft Windows Event log
I would like to monitor tablespace warning and critical events of my Oracle database (12c Standard Release 12.2.0.1.0) via Microsoft Windows Event Viewer and attach tasks to it.
Right now only a few ...
0
votes
1answer
115 views
Direct, simple SQL query results in “ORA-01406: fetched column value was truncated”
All the information I've seen on this issue is always in regards to running a query via some other utility (e.g. TOAD); however, I am seeing this issue when I simply try to select * from v$asm_disk; ...
0
votes
0answers
34 views
How to remove linked servers provider?
I installed an Oracle OraOLEDB.Oracle provider. Now I want to remove that provider from the list. How can I do that?
0
votes
0answers
38 views
OPENQUERY giving wrong result on linked server
I have setup linked servers on my SQL Server and choose Oracle as a linked server.
SOMETIMES, When I run the query below under the SA username, I get different result. However when I run under my own ...
0
votes
2answers
538 views
how to resolve ORA-04042: procedure, function, package, or package body does not exist and ORA-00942: table or view does not exist
I am trying to grant EXECUTE and READ privilege on two tables to a user ktest1.
grant EXECUTE on SYS.KIR_DOKUMENT to ktest2;
grant READ on SYS.KIR_DOKUMENT to ktest2;
when i give grant execute i get ...
-1
votes
1answer
46 views
how to resolve the error “ADMIN option not granted for role 'my_role_1'” [closed]
I am trying to grant a role to user.
grant my_role_1 to ktest1 with admin option;
But i am getting the below error
Error report - ORA-01932: ADMIN option not granted for role 'my_role_1'
01932. 00000 ...
0
votes
1answer
44 views
How to copy user rights and roles from one user to another
I require a PL/SQL script that copies all of a user's rights, roles and mandates from one user to another.
I am using Oracle 12c.
0
votes
3answers
220 views
Audit all insert, delete, update and select statements on a schema in Oracle 12.2
I cannot understand how to create a Unified Audit policy in order to audit all INSERT, UPDATE, DELETE and SELECT statements performed on all the objects within a specific schema.
The goal is to track ...
0
votes
1answer
39 views
Update a Column with sequential number based on the order by of a column in Oracle Sql
I have table with below create scripts
create table training(
action_id NUMBER not null,
training_id NUMBER,
course_name VARCHAR2(100),
display_order NUMBER default 0
)...
0
votes
1answer
29 views
Migrate Oracle 12c to 18c in AWS RDS
Currently we have an Amazon RDS Oracle 12c instance and we need to upgrade it to Oracle 18c in a new RDS instance.
What is the correct approach to do this?
Can we set up an 18c instance staright ...
0
votes
2answers
38 views
How to connect to specific session id & serial# ? Blocked sessions
I have blocked sessions and see which session is blocking them, having session_id and serial#. Is it possible to connect to such session? How?
Background: using V$SESSION_BLOCKERS I see sessions are ...
0
votes
0answers
31 views
After enabling SSL in Oracle user must log in twice
I've enabled SSL for my Oracle 12c DB. The lsnr starts up fine and I can access it via a sqlplus / as sysdba (no password auth there, it's OS local). However, if I attempt to connect as a user which ...
1
vote
1answer
221 views
About real time statistics oracle 19c only for particular table
Reg Real-Time statistics which extends online statistics gathering(12c) to also include conventional DML statements.
Real-time statistics helps the optimizer generate more optimal plans.Whereas bulk ...
