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,606
questions
1
vote
0
answers
7
views
ORA-27046: file size is not a multiple of logical block size
I have oracle19c container, running by docker-compose:
version: '3.7'
services:
oracle:
image: container-registry.oracle.com/database/enterprise:19.3.0.0
container_name: oracle19c
ports:
...
MiH
0
votes
1
answer
8
views
Oracle19c container cannot startup after turning on archive log
I'm running oracle19c container.
This is the docker-compose file:
version: '3.7'
services:
oracle:
image: container-registry.oracle.com/database/enterprise:19.3.0.0
container_name: oracle19c
...
MiH
0
votes
0
answers
7
views
Oracle :Invalid username/password; logon denied
Oracle throws invalid username/password when trying to login with a created user.
Oracle is installed locally.
SQL> show user
USER is "SYSTEM"
SQL> show con_name;
CON_NAME
------------...
0
votes
0
answers
25
views
Top reasons for temp tablespace to go offline
It was marked offline and it is fixed already.
We want to know the list of causes that marks the temp tablespace offline.
-2
votes
0
answers
12
views
Oracle free up the space and archive space
How to free up the space in Oracle server specifically in root and one arch files have 500 mb in standby server.any body solved this issue Mount details are used 98 percentage root partition in ...
Dilip Kumar
0
votes
1
answer
55
views
Why is the SYS user granted both the DBA role and the SYSDBA privilege?
If the SYSDBA privilege gives the grantee ultimate authority, then why does the SYS user also have the DBA role in addition to the SYSDBA privilege?
- 123
-1
votes
1
answer
22
views
I want to change the location of redo files on standby db
my db is generating redofiles to a certain path, lets call it 'old/path', and i want to move it to a new path, lets call it 'new/path' in oracle
can somebody help?
- 1
0
votes
0
answers
14
views
Do I need to pay for an Oracle EE license for OAS 7 RCU Installation?
I need to install OAS (Oracle Analytics Server) 7, but this version needs an Oracle RDBMS EE for the RCU. Is this free of charge, like the recovery catalog is for example, or do I need a full license?
- 1
0
votes
1
answer
37
views
How to fix ORA-00600: internal error code, arguments: [ktsircinfo_num1], [5], [104], [2789130], [], [], [], [], [], [], [], []
I change the table from non-partitioned to partitioned using
ALTER table schema.table_name MODIFY partition by list(column_name)
automatic (partition p_null values(null))
but its corrupt and throws
...
0
votes
1
answer
30
views
How to query in the given order
select * from table where options=(10,223,43,1,23,54,323,32)
But the result is not coming in the given order of options. Options need to be changed frequently.
- 1
0
votes
0
answers
16
views
ZHS16GBK to UTF-8 converting issue
I've got an unusual issue. I am using oracle goldengate to migrate oracle database of ZHS16GBK charset to postgresql of UTF-8 charset. After working out a few issues, I encountered a charset issue ...
- 1
0
votes
0
answers
11
views
while starting oracle instance we facing LOG_ARCHIVE_DEST_1 problems
In Oracle, I have set log_archive_dest_1='LOCATION=C:\Program Files\sqldeveloper\sqldeveloper\bin\TSH1' parameter and shutdown the database. When I tried to start up the db., I got the following error:...
vamsi krishna
0
votes
1
answer
33
views
Can database administrators access and modify the database before it's opened?
I'm trying to answer the following question (asked in a previous exam and supposedly having one correct answer):
To create a DATAFILE and Assign it to a DATABASE, the instance can't be
started in ...
- 123
-1
votes
0
answers
22
views
oracle windows 19c client 62 bit install hangs at 0% prerequisite checks
[![enter image description here][1]][1]
Trying to install oracle 19c windows client on windows 10 enterprise. At first it would not get past step 1. Found another entry and re-started setup with:
...
- 145
0
votes
0
answers
22
views
Cross Version EXPDP/IMPDP of Indexes
Our source database is 11g and target is 19c.
My question is about exporting and importing indexes.
Does the EXPDP command "exports" the actual index structure or just the "Create index&...
- 141
1
vote
2
answers
38
views
how to audit users with old password versions
I must set
SQLNET.ALLOWED_LOGON_VERSION_SERVER=12a
on all of my database servers.
How can I check if clients still use old authentication protocols?
I know I can check DBA_USERS for old password ...
- 163
-3
votes
0
answers
38
views
how do you improve a search on a column which is not a primary key eg searching by name on a very large table to get an account number
I am using an Oracle database 19c. I have a table for all the account numbers of our customers. Searching by account number is very fast but they want to search for the account number using the ...
-1
votes
1
answer
37
views
How to export and Import entire oracle database using sqlplus on terminal linux machine?
I have database that i want export from one machine and import into another machine using sqlplus on linux terminal.
I have tried nothing
Bruce Wayne
0
votes
0
answers
34
views
Can a user connected as sysdba always bypass auditing mechanisms?
Can a user connected as sysdba always bypass auditing mechanisms? What could be done to minimize (or prevent) auditing prevention?
- 123
0
votes
1
answer
34
views
LSNRCTL cannot stop Listener
When I'm trying to lsnrctl start, i have following error:
TNS-01106: Listener using listener name LISTENER has already been started
However, if i try to lsnrctl stop:
Connecting to (ADDRESS=(PROTOCOL=...
- 3
0
votes
1
answer
23
views
ORA-12015 materialized view complex query error with simple join two table
I have 2 simple table which has columns like :
table1 :
"OBJECTID" NUMBER NOT NULL ENABLE
"OLCEK_ID" NUMBER(*,0)
table2 :
"OBJECTID" NUMBER NOT NULL ENABLE
i created ...
0
votes
2
answers
31
views
Script disabling/enabling foreign keys
I want to script disabling and enabling Foriegn KEY constraints.
I'm testing with the following setup. As you can see from below I am able to successfully disable the constraints but I can't seem to ...
- 105
0
votes
1
answer
74
views
How is the current sequence number in the control file used during recovery?
During recovery, how is the current sequence number used to determine the redo log files used to re-construct the database as well as the order in which to apply the changes recorded in them?
- 123
0
votes
1
answer
28
views
Set column value to different randomly chosen values from another table
My goal: Set PID_FM in every row to a randomly picked value out of all the values matched by the subquery.
However the FM_ID is only picked once, and therefore the whole column has the same value. I ...
- 1
0
votes
2
answers
80
views
What's inside a redo record in Oracle's Redo log?
While reading the Redo log wiki page, I was confronted with the following statement:
For example, if a user UPDATEs a salary-value in a table containing employee-related data, the DBMS generates a ...
- 123
-2
votes
0
answers
16
views
Compilation error in sql trigger
CREATE OR REPLACE TRIGGER depleted_check_update
BEFORE UPDATE ON product
FOR EACH ROW
DECLARE
finished INTEGER := 0;
cust VARCHAR(30);
flag INTEGER := 0;
CURSOR c1 IS SELECT ProductID FROM ...
0
votes
0
answers
25
views
DBA_TAB_MODIFICATIONS out of whack in Oracle when moving partition or subpartition segments
I've observed that when moving a partition or subpartition of a table (ALTER TABLE xyz MOVE PARTITION abc), the row count of the moved segment gets reflected in DBA_TAB_MODIFICATIONS at higher levels (...
- 265
0
votes
1
answer
77
views
CREATE CONTROLFILE failed ORA-01210: data file header is media corrupt
I am trying to recover a DB beacause I've lost control file. So I try to create a new one:
CREATE CONTROLFILE REUSE DATABASE "MYDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
...
- 3
0
votes
0
answers
40
views
SQL*Net message from client too important
It is not easy to describe my problem but I will try. We noticed a slow processing problem with the database when migrating an application from a current VM named VM1 (RedHat 7.9, Java 8, Tomcat, ...
dsea
0
votes
1
answer
43
views
Dropping Oracle Diskgroups with Oracle not running
I'm trying to startup an Oracle database in SQL*Plus, and I have the following error:
ORA-39510: CRS error performing start on instance 'MYDB' on 'MYDB'
CRS-2672: Attempting to start 'ora.DATA.dg' on '...
- 3
0
votes
2
answers
64
views
expdp fails with error ORA-31626 without any details on a full export
I am exporting a complete database (full=y) on oracle 11gR2 on Linux, and always get this error. There are no other messages, so the problem is not about timeout or permissions as shown elsewhere. ...
- 4,742
0
votes
2
answers
96
views
VM ORACLE 23c: ORA-39246: cannot locate master table within provided dump files (dmp files from ORACLE Cloud)
Context:
2 DBs in ORACLE Cloud (free) account, version 21c and version 19c
1 ORACLE 23c instance in Linux VM instance running on a desktop computer.
Doing expdp and impdp of a specific schema from ...
- 111
0
votes
3
answers
35
views
Redo logfiles are missing on Oracle database 11g manual standby database
Log files are missing on my standby database server, please help to re create it. My standby database was created manual method.
I need to get the missing redo logfiles back on standby database.
Sujoy Dhar
0
votes
0
answers
20
views
Is there any way to exchange the name of a table with a current table online?
A table currently syncing using ogg on target side has a few differences with the source side. So I will resync the table to a new name on target side alone. But how can I exchange the table name with ...
- 1
0
votes
1
answer
32
views
How can I monitor and address fragmentation on RDS for Oracle database?
I'm planning to migrate my database from on-premises to AWS RDS for Oracle. However, I'm not sure if Amazon RDS supports tools such as Automatic Fragment Advisor or the Automatic Segment Space ...
1
vote
1
answer
61
views
rebuild index in Oracle
when do I need rebuild an index.
we are using in data warehouse bitmap indexes. if I truncate table and there is no row and after that I insert new rows an index should be rebuilt as far I know ...
Pato
0
votes
0
answers
16
views
Transferring data from 3 different databases into a single database or datawarehouse using SSIS
In my company we have 3 different databases 1- SQL SERVER,2- Oracle database
so now I need to transfer all the data from 3 databases into a single SQL Server databases using SSIS.
Can anyone suggest ...
1
vote
1
answer
18
views
[[FATAL]] [[DBT-06103]] The port (5,500) is already in use in Docker Container
I'm trying to use Oracle 19c DB Container for my test cases in Jenkins Job but DB Container is intermittently failing with this error
[FATAL] [DBT-06103] The port (5,500) is already in use.
ACTION: ...
0
votes
2
answers
65
views
Truncate tables in other schema
I have logged into a dev02 schema with a user and password and another schema dev08 with a different user/password in the Oracle database. Now from dev02, I run the command: truncate table dev08....
- 101
1
vote
1
answer
18
views
How to propert check "manual standby" replication?
I was using the following query to check the last applied archivelog in my manual standby (basically a copy of archivelog from primary to standby and recover in destination)
COL NEXT_CHANGE# FOR ...
- 626
1
vote
1
answer
34
views
limit access to oracle scan port by IP address
We run an Exadata XM-8 with multiple DBs for a variety of clients in our company. I want to limit access to one of the DBs to one particular server. I know I can run a logon trigger and limit the IP ...
- 13
1
vote
1
answer
60
views
It's possible share a disk between two diskgroups after limit the disk space in ASM?
I am not able to get a new disk in the moment and I was woldering if it's possible to share a disk between two diskgroup.
I have a FRA diskgroup with a disk of 200gb and I need to add 100gb in DATA ...
- 626
1
vote
1
answer
55
views
Convert column with unix timestamp from UTC to a different time zone
Good afternoon,
I have a column within one of my tables that is stamped with a UNIX timestamp. I would like to have the return in my current timezone, PST. I have the following query and the below ...
- 13
0
votes
1
answer
46
views
Centos 7 Oracle Database 12c Installation Out of Memory
I am new to Oracle Database Installation and I tried to install newer version but it does not work, and when I get a full documentation on how to install version 12c, somehow I got an error out of ...
- 1
0
votes
1
answer
28
views
Should I model statistical summary as a separate entity or with the summarized entity as part of the key
I run several tests on each unit on a wafer and want to store a summary (median, cpk, std dev, etc) of the results for each test across the wafer. I also want to store a summary of the results for ...
- 101
0
votes
0
answers
25
views
Difference between schema in oracle and mysql [duplicate]
In the Oracle database, a user owns a single schema. What about MySQL? Is there something like a user owning a single schema in MySQL too? I read some documentation of schema on MySQL, it seems the ...
- 1
0
votes
1
answer
34
views
Remove all characters except two letters
I am looking for a logic to remove all characters in a string except AD & Numeric values.
Examples
String
Expected Result
AD-892839 statement
AD-892839
BOD AD-89283
AD-89283
BOD AD-89283 ACGD
...
- 11
1
vote
2
answers
102
views
DBMS_SCHEDULER running 10 instance of the same job
I'm trying to have a single scheduler that will run multiple (from 4 to 10) jobs at the same time.
I know this is doable if I just make multiple dbms_scheduler of the same job, (job1, job2....) . but ...
- 11
0
votes
1
answer
27
views
Recovering RMAN Backup Into a New Database
I have a RMAN backup from an old oracle DB that I need to open on a new PC with a new instance of oracle installed.
I am unsure how to go about this as from what I can see in the documentation ...
William Glover
0
votes
0
answers
15
views
SDO_GEOMETRY Queries
I have 2 tables in my oracle database: AIRPORTS and POPULATED_PLACES. Both tables were transformed to SRID 3426 and spatial indexes were created as well as USER_SDO_GEOM_METADATA table.
AIRPORT has ...
- 101