Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
1 answer
11 views

Issue with DBSAT Tool Stuck at "Setup Complete" Stage

Sure, here is the corrected text: Hello folks, We want to perform a security assessment on our database using the DBSAT tool. However, we are facing an issue. When I run the DBSAT, it gets stuck at ...
Mahammadali Aghabayli's user avatar
0 votes
0 answers
17 views

How to import Oracle unified audit spillover files generated by Data Guard physical standby database without switching over?

I know that I can use the DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES procedure to load the unified audit spillover files (*.bin) into the internal unified audit tables in an Oracle 19c database. But, ...
cdub's user avatar
  • 101
0 votes
1 answer
51 views

Database systems - data type alignment padding and record size (C/C++ related)

In PostgreSQL there is alignment padding of various datatypes which can increase (or decrease) the size of records (as stored on disk) in varying ways (see these links, 1, 2, 3): I searched for "...
Vérace's user avatar
  • 30k
0 votes
0 answers
12 views

PDB restoration on other server

I want to restore only 1 pdb to another server, how can I do that? the rman backup which i have taken from another server has a different control file, and the server on which i am restoring the pdb ...
datascinalyst's user avatar
0 votes
0 answers
23 views

Audit attempts to access the Database, only failed for some users and all attempts for the rest

I am needing help to be able to configure an audit mechanism that allows me to record in the audit_trail the login (or create session) attempts in my databases, the problem comes when I need to record ...
miguel ramires's user avatar
0 votes
0 answers
16 views

Oracle Data Pump Export (expdp) how to exit if invalid credentials and not wait to provide valid one?

Execution: Export: Release 19.0.0.0.0 - Production on Thu May 9 07:58:59 2024 Version 19.20.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. UDE-01017: operation ...
Jakub P's user avatar
  • 157
1 vote
1 answer
31 views

Oracle SQL query slow even with indexes

I have an Oracle 19c database (19.0.0.0.0), and two tables with lots of columns, I'll mention only the relevant ones: table1: createtime date contact_key char(96 byte) table2: contact_key char(96 ...
Gábor Major's user avatar
0 votes
1 answer
32 views

SQL Developer MySQL to Oracle migration auto_increment and identity columns

Ok, So in learning about migrating from MySQL 8 to Oracle 19 I have run into an issue. My tables in MySQL have auto_increment on the primary key. When I walk through the migration and get my master....
cptkirkh's user avatar
0 votes
1 answer
28 views

join two table by closest date

I have 2 tables apply_record log_record How can I left join apply_record to log_record on the right closest date. for example final
陳品汶's user avatar
0 votes
2 answers
34 views

Gathering aggregate sum of rows, group by column in second table [closed]

Having trouble with a join and grouping values. Historically I have been able to pull sums of job sizes by client_host_name - using one table. Now we have a new table that adds a new value '...
Derek's user avatar
  • 3
0 votes
2 answers
34 views

Does Oracle database server stored runtime dynamic SQL?

I have a plsql below that executes dynamic sql. DECLARE sql_stmt VARCHAR2(200); BEGIN sql_stmt := 'SELECT employee_name FROM employees WHERE employee_id = :1'; EXECUTE IMMEDIATE sql_stmt ...
Idonknow's user avatar
  • 101
0 votes
0 answers
44 views

Copying data from old column to new column with large amount of records

While updating/copying the data from old column to new column we are facing the issue with tablespaces in database. Records count: 158 million+ Using below query to update the records, UPDATE ...
Mujahid Boramani's user avatar
0 votes
0 answers
38 views

How to connect db link from oracle to maria db?

I would like to connect a db link from Oracle 11g built in a Linux environment to MariaDB(10), a package built in a Linux environment (Synology NAS). Please guide me. The IP and port of the two are ...
user avatar
0 votes
1 answer
30 views

ORA-28000 The account is locked for SYS on the physical standby

I changed the SYS password on the primary and copied orapwd into the standby as documented. This approach worked fine for multiple databases, but for one standby, ORA-28000 appeared after a few ...
Brian Fitzgerald's user avatar
0 votes
1 answer
39 views

PL/SQL dynamic Index loop based on list variable

Currently, I am indexing column by column with the following code snippet: DECLARE already_exists EXCEPTION; columns_indexed EXCEPTION; PRAGMA EXCEPTION_INIT ( already_exists, -955 ); ...
Matt Miles's user avatar
0 votes
1 answer
34 views

Oracle 11c REMAP_TABLESPACE

I have a question about how it would affect making a remap_tablespace, I intend to make a remap_schema and remap_tablespace at the same time when I make an impdp since I want to make a copy of a ...
fah81's user avatar
  • 13
0 votes
1 answer
65 views

Oracle partition strategy suggestions

I have a transaction table with 1 billion rows per month (Approx. 50 GB/month). I will have aggregation of transactions for a specific user_id and a date range. The aggregation can be like Aggregate ...
Moinulla Baig's user avatar
0 votes
1 answer
27 views

How to register static listener in listener_scan as well?

I have a listener called "monitoramento" which has three static listener. SID_LIST_MONITORAMENTO= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=BRXXX_MONITORAMENTO) (...
Astora's user avatar
  • 723
1 vote
0 answers
22 views

Composite key with a auto-incremented column

I'm using Oracle, but this may apply to other Relational DBs, as well. Suppose I have a table T with columns C1, C2, C3, C4. Note: C4 is numeric. Is it possible to make C2, C3, and C4 a composite key ...
SBel's user avatar
  • 111
0 votes
0 answers
34 views

See an arbitrary SQL statement in oracle enterprise manager

I like to see any sql statement in the Oracle Enterprise Manager (oem) Cloud Control 13c, e.g. in the active session history. A simple select is not shown in any view. After some research I found in ...
th0rn's user avatar
  • 1
0 votes
1 answer
22 views

Flashback Logs Not Deleted With PDB Drop

There is a known issue with Oracle where the flashback logs are not reclaimable when a PDB is dropped and a restore point exists in the PDB. I can see a restore point in x$kccrsp but no restore points ...
Jim D's user avatar
  • 560
0 votes
1 answer
19 views

Network utilization maxed out during backup. Is it bad in itself?

We have a cluster of two Oracle DBs. Monitoring software agent is installed on both of the machines and overnight, when backups are happening, we get warnings that network interface utilisation on the ...
Tony Sepia's user avatar
0 votes
0 answers
25 views

Is there an analytical function to normalize values in Oracle?

In the following example we have ten random values from 6 to 233 (or any other integer range). Using common math we have, on last column, the values normalized from 0 to 1 (the usual range in this ...
Luis Santos's user avatar
0 votes
1 answer
32 views

Number of Sessions Opened in Remote Database when Executing Query with Oracle Database Link

I have a query on an Oracle database that involves accessing a remote database through a database link. Here's the query: SELECT t1.col1 , t2.col2 FROM Table1 t1 LEFT JOIN Table2@dblink t2 ON (t1.id=...
Mustafa zuhair's user avatar
0 votes
1 answer
23 views

It is possible to install ASM Grid Standalone without creating a DATA diskgroup first. It seem ohasd need to be install first

I have installed OEM grid standalone and have it working fine. However I would like to install GRID without having to create the DATA group first. In other words install ASM software using a local ...
Oracle DBA 's user avatar
0 votes
0 answers
27 views

Oracle GoldenGate SqlExec Error

I've recently intertied some Legacy code and was provide no documentation. I'm trying to understand where the issue is. Problem My Golden Gate replicats abend atleast once a week while trying to load ...
OptionalProgrammer's user avatar
0 votes
0 answers
25 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
48 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
0 votes
0 answers
45 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
33 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
52 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
0 votes
0 answers
25 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
30 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
249 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
94 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
1 vote
2 answers
65 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
  • 111
0 votes
1 answer
39 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
112 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
39 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
49 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
76 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
  • 723
0 votes
1 answer
75 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
107 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
170 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
64 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
45 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
27 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
45 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
75 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
88 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

1
2 3 4 5
156