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
12 views

Avoding combinatorial explosion with multiple one-to-many joins?

To explain I have a "compound" entity and each compound can have one or more lots. Each lot can have 0 to multiple measurements of each measurement type. There are many measurement type each ...
beginner_'s user avatar
  • 211
0 votes
0 answers
9 views

sqlplus connects to my Oracle server only on "second try"

My Oracle DB used to work fine but lately I have the following problem: When I try to connect with sqlplus with a non-interactive command as the following, from the very machine I deployed my DB on, ...
Andrea Montalbani's user avatar
0 votes
1 answer
23 views

SQL developer connection password forgot

I am new here so I might not be able to give the exact detailed information about the problem but here we go.I had a connection made as system in sql developer.I forgot the password so I thought I ...
user avatar
1 vote
0 answers
15 views

[Oracle Goldengate]Extract process abended: OGG-00662 OCI Error ORA-01435: user does not exist

I created an Oracle GoldenGate EXTRACT process in Multitenant. EXTRACT ES2K_SIT USERID C##[email protected]:1521/L1DB,PASSWORD **** EXTTRAIL /nas/ogg_oracle/dirdat/S2K_SIT/e1 DISCARDFILE /home/ogg/...
Nick Hu's user avatar
  • 11
0 votes
0 answers
22 views

why oracle can not startup, log error ora-27047

when sqlplus startup oracle this is the log: SQL> startup ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2260088 bytes Variable Size 671089544 bytes ...
user avatar
0 votes
0 answers
28 views

Pod Oracle does not start correctly

In a Kubernetes architecture context, I am dealing with a problem that I cannot explain. Here I have my configuration of a statefulset oracle : containers: - name: oracle image:...
user avatar
0 votes
1 answer
47 views

What is the performance implication of composite index column ordering on inserts?

I have a table with 4 columns, in which one of them is primary key, one is time_created, ID of the upstream service (say ID) and the type of upstream service (say service_name). This table is append ...
pdmnhn's user avatar
  • 1
-2 votes
0 answers
23 views

Oracle sessions ,process and connections

What is the relationship between oracle sessions, oracle connections and processes? What can be the values for each them? Does all of them need to be of same values? like 1 to one? for example 100 ...
user1929905's user avatar
0 votes
0 answers
22 views

Can an 19C asm instance be created after doing a software only install

I have installed ASM on 12c and 19c using the GUI. In both methods it create a +DATA diskgroup. Is it possible to do a simple Software only install and then manually create an empty ASM instance with ...
Oracle DBA 's user avatar
0 votes
1 answer
24 views

Migration of Data Guard HW Servers to Cloud Servers

I'm looking for information & advice on the best way to migrate from a hardware Oracle 19c Data Guard server pair to an Oracle 19c Cloud Data Guard server pair. Our configurations currently are: ...
P_J's user avatar
  • 1
0 votes
1 answer
68 views

Encountering an Issue with Oracle ORA-39405 Error

I've been researching and testing for days now, and so far, I haven't been able to solve my problem. I'd like to know if any of you have ever encountered this. I'm facing a challenge with a client's ...
Thiago Roque's user avatar
0 votes
1 answer
34 views

sqlplus / as sysdba Connected to an idle instance

anyone can Me help uderstand what is happends? i have oraenv corectly, use su oracle to change user, use this command to conncet as sysdba - sqlplus / as sysdba answer is: SQL*Plus: Release 19.0.0.0....
Tomasz Myszak's user avatar
0 votes
2 answers
52 views

how best to have a record versioning or tracking in relational database?

The scenario involves maintaining versions of a 'Product' object (e.g., Product table) and creating new records when the product changes to the latest version (e.g. v2 from v1). It is crucial not to ...
Enigma's user avatar
  • 101
0 votes
1 answer
17 views

ORA-14405 when dropping a tablespace with no data

I was cleaning up tablespaces and wanted to delete one, and after moving all the segments from it, I got the following: SCOTT.OE> drop tablespace fact_index including contents and datafiles; drop ...
Mark Stewart's user avatar
  • 1,133
1 vote
1 answer
50 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
  • 305
0 votes
0 answers
26 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
20 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
0 votes
1 answer
39 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
  • 713
0 votes
1 answer
46 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
56 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
57 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
31 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
29 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
  • 118
0 votes
1 answer
21 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
44 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
24 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
55 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
1 answer
39 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
26 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
53 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
46 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
71 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
39 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
62 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
  • 118
0 votes
0 answers
53 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
27 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
48 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
51 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
118 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
36 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
  • 118
0 votes
1 answer
57 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
18 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
95 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
103 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
270 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
90 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
43 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
98 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
2 3 4 5
156