Questions tagged [oracle]

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

Filter by
Sorted by
Tagged with
0 votes
0 answers
18 views

Insert values in PowerShell Variable into Oracle Database Table

I have created a script in PowerShell (utilising the PowerShell dbaTools) which collect information about SQ Server Estate in our environment. I need to insert the result from the PowerShell directly ...
Ali's user avatar
  • 195
0 votes
0 answers
16 views

ORA-12541: TNS:no listener error when trying to login through WSL to access OracleXE Database

System Details WSL2 Ubuntu Oracle Instant Client (Inside of WSL) OracleXE (Inside of Windows) I followed the instructions guide from the Oracle Documentation, added the path to the TNS_ADMIN, ...
giovanni's user avatar
0 votes
0 answers
12 views

dbaascli - non-interactive

How can I use dbaascli without being prompted for SYS password and TDE password? I would like to input these values from a file. If I issue this command, I am being prompted. /bin/dbaascli database ...
Bjarte Brandt's user avatar
-1 votes
2 answers
29 views

I want to migrate a oracle database from one server to another server using datapump export utility.could you please explain it step by step

I am new to oracle and also migration but wants to learn how to migrate a oracle database from one server to anotherserver using datapump export utility.please help me with step by step explaination.
jyothi d's user avatar
0 votes
1 answer
34 views

Why a consistent backup still requery recovery in Oracle?

My database was in mount state and we perfomed a backup of the database. backup database format '/backup/db_full%U.bkp'; So, when restoring it, I can't simple use: Restore database; alter database ...
Astora's user avatar
  • 703
0 votes
1 answer
38 views

Oracle 19c and 21c expdp exports dumpfile of 308kb without any content

Trying to export schema using the following command on several Oracle instances: two 19c and one 21c $ expdp mySchema/myPwd@ORCL Adding CONTENT=ALL or SCHEMA=mySchema or SCHEMA=MYSCHEMA or DUMPFILE=...
Vy8's user avatar
  • 1
0 votes
0 answers
41 views

invalid username/password; logon denied with kerberos authentication

I am attempting to configure Oracle with Kerberos. I have completed all of the necessary configurations and have obtained a ticket. However, when I run SQLPlus /@ORCL, I receive the following error: C:...
SK1's user avatar
  • 1
0 votes
0 answers
46 views

How can I check the current memory management mode for an oracle database instance?

I have a vendor requesting that Automatic Shared Memory Management (ASMM) is configured to a certain threshold for an existing oracle database (version 19c) hosted on a windows box. As usual Oracle ...
Eric Swiggum's user avatar
0 votes
0 answers
25 views

How to get last executed statement on a particular table in Oracle?

Trying to identify what ghost process is inserting records into a particular table. Is there a way to get the exact query?
Dhaval Mohandas's user avatar
0 votes
1 answer
26 views

How to recover the standby database after opening

If I have standby which is db role is PHYSICAL STANDBY and it is MOUNTED. So, when I open it read/write the standby will be destroyed. (I have DataGuard) So, basically do I need to mount it again and ...
paganini's user avatar
  • 116
0 votes
1 answer
19 views

Use Field Value as where clause statement

is it possible to use the select statement result as where clause statement/Condition in oracle SQL? Eg: Condition_txt(FIELD) = 'AND b.mpal03d >= TO_DATE('01/10/2012','DD/MM/YYYY')' (Value of ...
iHateBugs's user avatar
0 votes
1 answer
42 views

How to create a stored procedure from another stored procedure dynamically in OracleI have

I have a Stored Procedure that outputs the DDL of another Stored Procedure. I need to execute this DDL dynamically. Meaning, the second Stored Procedure should get created when the first Stored ...
Vincy Wales's user avatar
0 votes
0 answers
16 views

Querying V$ARCHIVE_DEST_STATUS

-- Oracle 19c when querying v$ARCHIVE_DEST_STATUS, I get the following output: SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ#,APPLIED_SEQ#,APPLIED_THREAD# FROM V$ARCHIVE_DEST_STATUS ...
datascinalyst's user avatar
0 votes
0 answers
46 views

What is the best way to recompile invalid objects in Oracle?

I've inherited a group of Oracle instances and I've been deploying SQL scripts provided by a vendor that occasionally ends up moving various database objects into an invalid state. This in turn kicks ...
Eric Swiggum's user avatar
0 votes
0 answers
54 views

version controlling Database's Schema as well as its Data

my requirement is to version control my oracle database, like easy rollback to previous version in case the new update fails, hence securing the customer data and database schema to last stable ...
AKA's user avatar
  • 1
0 votes
1 answer
38 views

Any way to debug an Oracle Sequence?

Somewhere in a large project a sequence is being incremented one too many times. Is there some way to add a trigger or watch to the sequence when .NEXTVAL is invoked so we can get a call stack and see ...
Yimin Rong's user avatar
0 votes
1 answer
22 views

How to COPY table privileges dba_sys_privs into different table in Oracle

i want to copy table privileges dba_sys_privs in table A to new table B. i have create table B. What left now was it's table privileges'. Kindly advice. Thanks
Ahmad Hasanul Ishraf Shuib's user avatar
0 votes
1 answer
50 views

Table Partitioning on Multiple columns different types

I would like to create a partition table in Oracle SQL DEVELOPER, using two columns with different types? I want to stock in the partition table all data where: creation_date <'2021' and ...
DS_Tn's user avatar
  • 1
0 votes
1 answer
39 views

Oracle: How can a job exist and not exist at the same time?

I am trying to fix a job by deleting it and then recreating it. But I can't because it seems to not exist when I try to drop, and then exist already when I try to create Begin dbms_scheduler....
Christian Bongiorno's user avatar
-1 votes
2 answers
63 views

not return count = 0 if value is null - oracle

I'm trying to write a oracle SQL query to return if the values are not present then return the count as zero. My query : select company, sum(case when company IN ('ABC','DEF','GHI','JKL','MNO') ...
Karthik Awesomes's user avatar
0 votes
0 answers
35 views

listener issues in oracle 19c

These are my listener.ora and tnsnames.ora files listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dr_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/19.0.0/...
datascinalyst's user avatar
0 votes
0 answers
55 views

Patching 19c including MRPs

If I have 19.19 patch and latest MRP and I want to patch up to 19.22 do I need to manually remove the MRPs or are they going to be removed by the opatch ? Thanks in advance!
paganini's user avatar
  • 116
0 votes
0 answers
40 views

Oracle Database Error - ORA-01578: ORACLE data block corrupted (file # 17, block # 955795)

I have a big table with more than one hundred million records, it has this schema. schema of the table: CREATE TABLE USER_B.BIG_TABLE ( field1 NUMBER (10), field2 NUMBER(19,0), field3 ...
M_Gh's user avatar
  • 101
0 votes
1 answer
26 views

WHY is NO DATA FOUND a predefined exception?

In MSSQL, neither SELECT queries that return no rows nor INSERT\UPDATE\DELETE queries that affect no rows are treated as an exception. In my tSQL code, there are plenty of situations where an empty ...
KevinP's user avatar
  • 105
0 votes
1 answer
46 views

Problem in Oracle 19c Replication

Replication is working fine on the other servers, however on DB_B there's some problem; It is unable to receive archives. Can someone help me out? If I have missed any parameters, please do let me ...
datascinalyst's user avatar
0 votes
2 answers
37 views

Help with high CPU on Oracle Rac node caused by Oracle processes with *_so and *_ag in the process command name

I have one node in a RAC cluster that is seeing very high CPU and it seems to be caused by several Oracle processes ending with _ag and _so in the process command name. The other node is not seeing ...
jmichaelwDBA's user avatar
0 votes
1 answer
80 views

Unable to import constraints using IMPDP in Oracle 19c

I am using impdp user/password@PDB directory=data_pump_dir tables=tablename dumpfile=DP_3.dmp logfile=card.log parallel=6 there are 2 tables: Table A and Table B the tables are restored correctly, ...
datascinalyst's user avatar
0 votes
0 answers
40 views

Practices to maintain historical data via replication?

We have a use case like of banks, where we generate large number of transactions, say in transaction table and few other tables with large number of inserts, every day. Transactions are most inserted ...
Sachin Verma's user avatar
0 votes
1 answer
101 views

Extraneous Unique Index in Oracle DB DDL

I exported the DDL for the EMPLOYEE table in an Oracle DB. What is this index? What columns is this index for? CREATE UNIQUE INDEX "MY_USER"."SYS_IL0000126968C00005$$" ON "...
Nathan's user avatar
  • 113
0 votes
1 answer
32 views

Duplicating from active database fails at connection

I'm trying to duplicate a database from active database, but it seems like my connection is blocked on my auxiliary. I'm using ASM just4info. Target DB: listener.ora: LISTENER = (DESCRIPTION_LIST = ...
paganini's user avatar
  • 116
0 votes
1 answer
36 views

Setting up Oracle 19c Database instance with access from different subnets using scan listeners

We have a RAC cluster where we are upgrading a database. (12c to 19c) The upgrade process is to build a new database on the same cluster and import a copy of the old database. The old database has a ...
jmichaelwDBA's user avatar
0 votes
1 answer
17 views

Oracle returns invalid number of rows on json_table

When I run following query on Oracle 19, it returns 27 record instead of 30, and I cannot understand why, as I am expecting 30 records: select * from json_table('{"values":[[1,120674124,...
Amir Pashazadeh's user avatar
0 votes
1 answer
69 views

Oracle RAC 19c instance fails to start with ORA-29707: inconsistent value 1 for initialization parameter 1146 with other instances

After having to restart a node in a RAC cluster, we ran into "ORA-29707: inconsistent value 1 for initialization parameter 1146 with other instances" when trying to use srvctl start instance ...
jmichaelwDBA's user avatar
0 votes
1 answer
61 views

Help with simple check for Oracle Dataguard on 19c

I am new to Oracle and needing help just getting a quick script to check Oracle Dataguard. Do any of you have a simple script that could be used to just give me a quick status on dataguard? Just a ...
jmichaelwDBA's user avatar
0 votes
1 answer
177 views

Is there a way to monitor indexes in Oracle 19c

Is there a way to monitor indexes in Oracle 19c? I have turned index monitoring on ALTER INDEX my_index_i MONITORING USAGE; Using the queries below to get a rough idea when an index was used: SELECT ...
datascinalyst's user avatar
0 votes
1 answer
65 views

Oracle Database Tablespace space sizes and percent used in OEM questions.?

I am new to Oracle, and I am not quite understanding the size calculations shown in OEM under tablespaces. I know it should be simple and my well be. I need to monitor the table space but not sure ...
jmichaelwDBA's user avatar
1 vote
0 answers
35 views

How to send job notifications with dbms_scheduler via ssl encrypted smtp

We have Oracle Enterprise 19 Databases installed on Linux and using job notification via smtp with Oracle dbms_scheduler for quite a long time. Defining jobs like this and having all the needed ...
nightbird1972's user avatar
0 votes
1 answer
74 views

Oracle 12cR1 - How to Switchover In Multiple Physical Standby Environment With Cascaded Standby Scenario

Current Environment: 12cR1 RAC Production Database -> Let's say PROD 12cR1 Single Instance Physical Standby (Active Data Guard) -> Let's say DR1 Planned Environment: 12cR1 RAC Production ...
rndm_acct1's user avatar
1 vote
2 answers
87 views

How to search text in oracle view

I need to create a filter where I can locate specific text in my views. I tried using the following queries: SELECT OWNER, VIEW_NAME FROM DBA_VIEWS WHERE UPPER(TEXT) LIKE UPPER('%ABC%'); But ...
Igor Oliveira's user avatar
1 vote
2 answers
62 views

Could Oracle RecycleBin get cleaned automatically

In an AWR report, I observed following queries getting execured. delete from RecycleBin$ where bo=:1 delete from RecycleBin$ where purgeobj=:1 As per our DBA, those were executed from the ...
Sajith's user avatar
  • 111
1 vote
1 answer
75 views

How to change defaults in oracle docker image

I have been trying to change a few defaults in the database and set a language in default oracle docker image, but I have been failing. I have been trying to ALTER SYSTEM SET NLS_LANGUAGE = 'GERMAN' ...
pnikonowicz's user avatar
-1 votes
1 answer
87 views

ORA-01400: cannot insert NULL into

I have two tables: create table country( country_code varchar2(2) PRIMARY KEY, country nvarchar2(57) NOT NULL ); SQL> desc airport_final Name Null? Type -------------------...
Java_Beginner's user avatar
1 vote
0 answers
33 views

GridDB on Oracle Linux

I need to install GridDB on an Oracle Linux 7.9 machine. There are 3 GridDB distributions, for: CentOS 7.9 Ubuntu 18.04 openSUSE 15.1 I am ruling out Ubuntu as being the farthest from Oracle Linux, ...
jedison's user avatar
  • 111
0 votes
1 answer
55 views

Oracle statement inserting duplicate data

I am using this statement to insert records from another table: SQL> insert into city(city_code, country_code, city) select distinct(city_code), country_code, city_name from airport_final; 2 ...
Raakh's user avatar
  • 17
0 votes
2 answers
34 views

inserting data from another table

create user TESTING identified by "Test"; grant connect, resource to TESTING; grant dba to TESTING; connect TESTING/Test; set define off; create table airport_final ( iata_code varchar2(...
Raakh's user avatar
  • 17
0 votes
1 answer
126 views

Oracle 19c and ONS and FAN Events

I am working on learning more about Oracle Transparent Application continuity and FAN events. I noticed on my test 2 node 19.21 Oracle RAC that I get this error when I type the following onsctl error....
cptkirkh's user avatar
-1 votes
1 answer
74 views

Need help with DBMS_COMPRESSION.GET_COMPRESSION_RATIO

I need some help on how to run the DBMS_COMPRESSION.GET_COMPRESSION_RATIO package on all the tables of a database to see if is worth the implementation or not. This is the procedure I'm running alone ...
Daniel Soto's user avatar
0 votes
0 answers
19 views

Querying arrays in JSON fields

The DB is Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.16.0.0.0. Suppose we have a table CASE_ISSUES with a JSON field ISSUES_JSON: CASE_ID ISSUES_JSON 105 [{&...
Yimin Rong's user avatar
0 votes
1 answer
32 views

Validate "insert", "update", "delete" in the body of a trigger

I need to create a query where I can remove triggers that have "insert", "update" or "delete" in their body from the result. I'm using the following query for this SELECT ...
Igor Oliveira's user avatar
0 votes
1 answer
71 views

oracle pdb Relocation to new server

We plan to migrate the data (8 PDBS with at least 50 TB Data) of our old oracle server 19c to the new one (same version) and we must do this task with minimal or no downtime. For this reason we can ...
TimLer's user avatar
  • 161

1
2 3 4 5
155