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.
7,809
questions
1
vote
0
answers
36
views
Object visualization problem with owner DBA
I'm having a problem viewing other owners' objects, even though I'm logged in as a user with DBA permissions
PL/SQL does not display the view/edit spec & body option
For testing purposes, I ...
0
votes
1
answer
33
views
Issue with DBSAT Tool Stuck at "Setup Complete" Stage
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 the "Setup complete" stage and does not ...
0
votes
0
answers
82
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, ...
- 101
0
votes
1
answer
66
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 "...
- 30.3k
0
votes
0
answers
81
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 ...
0
votes
0
answers
46
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 ...
- 149
0
votes
0
answers
101
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 ...
- 157
1
vote
2
answers
141
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 ...
- 153
0
votes
1
answer
77
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....
- 13
0
votes
1
answer
94
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
- 1
0
votes
2
answers
50
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 '...
- 3
0
votes
2
answers
40
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 ...
- 101
0
votes
0
answers
50
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 ...
0
votes
0
answers
168
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 ...
박대철
0
votes
1
answer
273
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 ...
- 101
0
votes
1
answer
92
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 );
...
- 103
0
votes
1
answer
163
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 ...
- 13
0
votes
1
answer
186
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 ...
0
votes
1
answer
68
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)
(...
- 801
1
vote
0
answers
25
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 ...
- 111
0
votes
0
answers
54
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 ...
- 1
0
votes
1
answer
82
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 ...
- 560
0
votes
1
answer
25
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 ...
- 145
0
votes
0
answers
32
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 ...
0
votes
1
answer
96
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=...
0
votes
1
answer
61
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 ...
0
votes
0
answers
73
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 ...
0
votes
0
answers
42
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,
...
0
votes
1
answer
81
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 ...
eclipse
0
votes
0
answers
138
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
...
supolu
0
votes
0
answers
48
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:...
tSuBaKaShIrA
0
votes
1
answer
91
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 ...
- 1
0
votes
0
answers
46
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 ...
0
votes
1
answer
34
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:
...
- 1
0
votes
1
answer
707
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 ...
0
votes
1
answer
570
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....
2
votes
3
answers
179
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 ...
- 121
0
votes
1
answer
95
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 ...
- 1,143
1
vote
1
answer
278
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 ...
- 325
0
votes
0
answers
92
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, ...
- 1
0
votes
0
answers
106
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 ...
- 637
0
votes
1
answer
106
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 ...
- 801
0
votes
1
answer
210
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=...
- 1
0
votes
0
answers
322
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:...
- 1
0
votes
0
answers
583
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 ...
- 620
0
votes
0
answers
146
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?
0
votes
1
answer
90
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 ...
- 118
0
votes
1
answer
34
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 ...
0
votes
1
answer
52
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 ...
0
votes
0
answers
191
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 ...