Questions tagged [oracle-12c]
Oracle Database 12c. Please also tag oracle for search purposes.
850
questions
-1
votes
1answer
42 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
29 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
62 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
29 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
10 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
votes
0answers
19 views
How do I get all records with birthday falling today in oracle
I am getting a syntax error with a PL/SQL stored procedure when run exec :
Errors: check compiler log
Error starting at line : 1 in command -
exec GET_BIRTHDAYS
Error report -
ORA-...
1
vote
1answer
53 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
35 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
34 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
29 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
16 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 ...
0
votes
0answers
18 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
75 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
22 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
30 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
132 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
23 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
42 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
36 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
32 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
26 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
34 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
29 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
115 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 ...
0
votes
1answer
26 views
What is the correct way to present the disks to ASM?
Hello I would like to know which is the correct way ... or the most recommended way to present the disks to ASM, for example: I have 3 disks mapped to a server (rhel7) orasys, orafra, oradata, with dm-...
0
votes
1answer
35 views
Can I Avoid Joining The Same Table 3 Times?
I have this database schema on a Oracle 12c database :
I'm trying to answer this question :
What is the game in which Dallas Mavericks had the biggest percentage of successful 3-point shots ?
I've ...
0
votes
0answers
24 views
Exchange partition not working
I have 2 schemas TBCAM and AR_TBCAM. In TBCAM, I have a partitioned table BKP_COST_EVENT with partition name p2016. I created similar empty table in AR_TBCAM , BKP_COST_EVENT_P2016 . Now I want to ...
0
votes
1answer
29 views
Oracle : Multiple aggregate functions on a table
I have a use case where I need to
Get Max of column DATE
Concatenate all rows in column NAME
Get a value corresponding to the max value of column DATE. This operation has to be done on multiple ...
0
votes
1answer
33 views
Pass values to column to create graphs in excel
I'm trying to convert the result of a sentence into columns to create a graph in excel.
I have this sql
select
hss.instance_number INST,
to_char(snap.begin_interval_time,'dd/mm/yyyy hh24:mi:ss') as ...
0
votes
1answer
31 views
Oracle golden gate to BigQuery
Im trying to setting up the Golden gate to sync the data to BigQuery. When I start pushing the initial load, my extractor exported all the data and even from the replicat stats Im able to see the ...
0
votes
0answers
22 views
How to delete OCR backup?
I have the following backups:
sudo /u01/app/19.3.0/grid/bin/ocrconfig -showbackup
server1 2020/05/03 00:18:59 +OCR:/rac/OCRBACKUP/backup00.ocr.262.1039393129 724960844
server1 2020/...
0
votes
1answer
46 views
ORA-12518 and then TNS-12560, TNS-00534 and 64-bit Windows Error: 10022: Unknow Error when trying to connect to a cdb or a pdb (Oracle 12cR1)
I am seeking for help for a problem I try to resolve for a whole week. As the title say, I try to connect to a pdb or cdb and specifically using the @ statement.
I created my instance named 'test', ...
0
votes
1answer
47 views
SSMS Linked Server -ORA-28009: connection as SYS should be as SYSDBA or SYSOPER (Microsoft SQL Server, Error: 7303)
How could I use "Linked Server" from SSMS IDE to connect the Oracle server database with "SYSDBA"?
I've tried many methods as following to show you what I did right now:
Oracle client connect to ...
0
votes
1answer
20 views
RMAN-03009: failure of backup command due to ORA-27038 and OSD-04010:
I'm running below script in a windows server, this is same script I run across all servers
run {
configure retention policy to recovery window of 7 days;
backup current controlfile format 'F:\...
0
votes
1answer
393 views
ORA-00604: error occurred at recursive SQL level 1
I was compiling a package on an Oracle Database just fine and suddenly this error occurred:
ORA-00604: error occurred at recursive SQL level 1
ORA-01654: unable to extend index SYS....
0
votes
1answer
16 views
Filter rows by range dates and only get the rows in a range of hours
I want you to filter the rows between a date range but I only want you to return the rows of a time range of each of the days included in the previous date range.
For example, you would like to ...
0
votes
2answers
33 views
Oracle limit the number of files of audit
I would like to know how to limit the number of files of audit generated in the audit directory, I have an Oracle 12c database. The AUDIT_TRAIL parameter is equal to NONE, however it continues to ...
0
votes
0answers
97 views
oracle - Change host to 0.0.0.0 in listener
Im using oracle 12c on windows server 2016. I want to make my oracle to listen to the port 1521 to 0.0.0.0
Here is my listner.ora file.
# listener.ora Network Configuration File: C:\app\bhuvi\...
2
votes
2answers
168 views
Tuning Java Pool after getting ORA-04031
I'm running Oracle 12.2.0.1 Standard edition on Windows 2012 RC2.
I'm NOT running Oracle's Automatic Memory Management.
We are seeing these in the alert log:
ORA-04031: unable to allocate 4096 ...
0
votes
2answers
49 views
Is it possible to limit connecting users to a schema from specific terminal or program?
I read about Oracle ACL, but on first sight, it doesn't look like it limits the access to a schema on terminal, program level. Is it even possible? I did experience such limitation once. I was ...
0
votes
1answer
24 views
SQL query output to a file is failing with error code 9 when the data contains French and English characters with size > 32k
Database: Oracle 12 C
I have a MESSAGE table with BODY VARCHAR2(32000), METADATA VARCHAR2(32000).
Initially I had a problem when both columns have 32k+32k chars of data. I had fixed it by applying ...
1
vote
1answer
53 views
Run stored procedures in other schemas from stored procedure [closed]
I have a current process: a large procedure in one schema.
There is a plan to have A, B1, B2, B3 schemas (B-schemas are identical, could be B-n schemas) in Oracle 12c database.
Schemas B1, B2, B3 have ...
0
votes
0answers
14 views
tracking in odi the package which uses a given mapping
I am trying to find the whole lineage and loading process of a certain table column. To begin with i am locating the mapping used to populate the column. To do this i use:
select
m.name ...
0
votes
1answer
47 views
Deleting rows from Oracle table user_scheduler_job_run_details
Oracle Database 12c
Red Hat Linux 7
I want to delete the last 1000 records on the Oracle table user_scheduler_job_run_details because it is getting too large.
How best to delete rows from the Oracle ...
0
votes
2answers
44 views
How to export large table data into different files in oracle?
I'm having a table which contains 10 Lakh lines and need to export into different file which contails 1 Lakh lines each .
sample_01.sql ,sample_02.sql and so on
How can we take export like this in ...
0
votes
0answers
158 views
Installing Oracle 32 or 64 bit on a Windows Server 2019 to Import data into SQL server and use with Power BI
I am an Oracle noob and really struggling with this concept of 32 and 64 bit business with Oracle.
All I really want to do, is import data on a daily basis from an Oracle 12c DW into a local 2019 ...
0
votes
1answer
60 views
Querying 500 million records in Oracle view takes forever
I really need professionals help now after wasting a week of time to solve my problem and searching on Stack Overflow. I have a view created on top of two different tables. This view has 500 million ...
0
votes
1answer
74 views
DBCA and can't init database
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.2.0.1/db_1/dbs/initAWSDB.ora'
I created a new Oracle 12c ...
