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
2answers
31 views

Oracle License question - migration

Oracle EE 12.1.0.2. I need to migrate an existing (licensed) database from Server A to Server B. Do I need to license Server B during the period of time that both servers are running? The period of ...
0
votes
2answers
42 views

ORACLE TABLESPACE USERS GETS 100% USED

I am facing a problem with oracles users tablespace. It automatically grows really fast. What kind of data is stored there? And what happens when it hits 100% of space used? Is there a solution to ...
0
votes
1answer
26 views

Suppress successful insert statements or review errors on large inserts in Oracle 12c

I have ~130 SQL scripts that INSERT about ~750,000 records into an Oracle 12c database. I have a master SQL that kicks all this off using this template: set termout off set echo off; delete from ...
0
votes
1answer
41 views

How to find missing sequence number in oracle ( Sequence number may recycle within same date or next date)

I am facing same problem already achieved one. Can you please provide the solution for below problem? I have below table group master groupid from_no to_no 1 00 99 2 ...
-3
votes
0answers
30 views

How to find missing sequence number in oracle ( Sequence number may recycle within date or next day) [closed]

I am facing same problem as the already archieved one. Can you please provide the solution for below problem? I have the below table group master groupid,from_no,to_no 1,00,99 2,000,999 3,0000,9999 ...
0
votes
2answers
30 views

LRM-00101: unknown parameter name '_first_spare_parameter'

I am part-way through an upgrade from Oracle 11g to 18c on RedHat. The Database Upgrade Assistant gives the message: Errors encountered during the execution of "Database Components Upgrade". ...
0
votes
0answers
26 views

Remove/distinct duplicates on listagg - oracle

I'm using the oracle-xe 11g version and I have the below sql code that I aggregation the course code, but the output has duplicates. SELECT b.alu_cpf AS login, b.alu_nomeco ...
0
votes
0answers
16 views

Best practice guidelines for a application table archive in Oracle 12C

Database environment: Oracle 12C Enterprise edition I have a table in the application schema and corresponding history table in the history schema. The application table has about 10 small varchar2 ...
0
votes
1answer
47 views

ORACLE DB literal does not match format string

I' am having this error: ORA-01861: literal does not match format string 01861. 00000 - "literal does not match format string" *Cause: Literals in the input must be the same length as ...
0
votes
1answer
26 views

Cannot dump database in Oracle on Docker

Oracle is working fine on Docker, I can connect from sqlDeveloper with no problem, but I cannot dump the database logging into Docker in the bash command line. Runnung: expdp CONFIG0001-TEST/xxxxxxx ...
1
vote
1answer
74 views

Oracle goldengate service is not starting: Failed to retrieve the name of a missing Oracle redo log

I am trying to start GG service, when try 'start my_service' then starting but it didn't start, status is changed always starting to stopped. I need to start goldengate service.. I don't know what ...
0
votes
2answers
37 views

How to find admin user of pluggable database in Oracle 12c up

I'm creating a script and I need to know what is the admin user of pluggable database. I don't find nothing about it in documentation. Other question is, what happen if I drop a admin user of the ...
0
votes
2answers
28 views

TNS-12543: TNS:destination host unreachable

I have a installed oracle 19c but i am unable to login Please refer the following screen shot I am not unable to login which user credential require to login
0
votes
0answers
24 views

Listener does not recognize an instance

We have been running several instances in the past: PUC and PST. Access to PUC is still working but recently I tried to access the PST instance and we get the following message from Listener: D:\app\...
0
votes
0answers
21 views

Oracle XE 18c DBFS_CLIENT auth failing for SYS without SYSDBA privileges

I have been following this tutorial to setup an Oracle DBFS environment for testing. A certain step of the tutorial is pointing to the use of the DBFS_CLIENT: When I try to authenticate on the ...
0
votes
0answers
52 views

Access or modify tnsnames.ora on AWS Oracle RDS

I have an Oracle RDS instance running on AWS and I need to access the tnsnames.ora file and check its configuration since I am getting this error Caused by: oracle.net.ns.NetException: Listener ...
0
votes
1answer
28 views

Oracle INSERT with If statement for values

I'm trying to find a way to put together an INSERT which will insert a column value based on the value of another column, so for exampke INSERT INTO table1 (col1a,col1b) SELECT (dependant of the ...
0
votes
1answer
18 views

Oracle database directories destination recovery [closed]

someone messed up the database when trying to compare 2 databases and in order to bypass some errors and i was asked if i can recover it . he copied all the directories from one to another , while the ...
-2
votes
1answer
36 views

oracle find to first hyphens after last vertical bar

oracle find to first hyphens after last vertical bar using REGEXP_REPLACE SELECT REGEXP_REPLACE ('sadsa|dd|g - g|hh|yyyyy - tttt - ooo', '.*(\|)(?!.*\|).*?\-{1}', '' ) FROM dual; string input '...
1
vote
1answer
56 views

How to migrate Oracle Database to MariaDB? [closed]

Currently we have a server on Oracle version 18. We are planning to migrate to MariaDB. Is there any free service provided by MariaDB or oracle that helps migrate a database from Oracle to MariaDB?
1
vote
2answers
47 views

Oracle database 12c upgrade to 19c

I was asked to advise some business analyst on migration from Oracle DB 12c to 19c. The thing is I have never used or done anything related to Oracle DB. From my experience with MSSQL during upgrade I ...
0
votes
0answers
17 views

Why is the Oracle Goldengate 12g extract working with a heartbeat table HB whithout 'add HEARTBEATTABLE'?

It is created with a default structure. Does the Oracle GoldenGate have a default heartbeat table? Could You give links to the Oracle documentation? In my company servers it's working without add ...
0
votes
0answers
14 views

Oracle: concurrent manager crashes just after it started [closed]

I have oracle db running for ebs and now the application is not able to start due to problem with the concurrent manager. the only error log that sounds to be related is the one exist on /var/log/...
0
votes
2answers
42 views

Efficient approach to Query DB with data in text file [closed]

I've got an oracle DB set up and want to Query it after I receive data in a text file. Number of product-names present in text file are around a million. After Searching a lot I've found 2 ways of ...
2
votes
1answer
70 views

Nulling a BLOB column in Oracle 11 impdp

I need to import a 50 GB dump file containing three schemas. Over 90% of the file is taken up by a single BLOB column. How could I import the schemas, including the table containing the blobs, but ...
0
votes
1answer
44 views

how to solve ORACLE AUDSYS.SYS space error

I am having this problem "Warning: odbc_connect(): SQL error: [Oracle][ODBC][Ora]ORA-02002: error while writing to audit trail ORA-55917: Table flush I/O failed for log ID: 1 bucket ID: 0 ORA-01691: ...
0
votes
1answer
47 views

SELECT TO_NUMBER('MUST_BE_SAME_TIMEZONE_FILE_VERSION')

I upgrade Oracle from 11.1.0.6.0 (32bit version) to 11.2.0.1.0 (64bit version) using RMAN on the same Windows computer (64bit). After RMAN restored and recovered, I then try to run SQL> startup ...
0
votes
1answer
24 views

How do you delete achieve log image copies that are already backed up?

How do you delete achieve log image copies that are already backed up ? It seems like below command doesn't work: delete copy of archivelog all until time 'sysdate-1' backed up 1 times to disk
2
votes
1answer
36 views

Oracle - impdp - import a partition

I truncated a partition, and would like to import it from backup. How can I import a partition from the dump file? Export log: . . exported "XY_PROD"."XY_LOG_PLSQL" 69.16 MB 320459 ...
0
votes
2answers
38 views

Listener (lsnrctl) reload vs stop/start

Some blogs tell that reload is equal stop and start, but in my test it does not stop the listener (uptime does not change). What situation can I use only reload and when I must stop/start the ...
0
votes
0answers
24 views

How to clear alert.log without ADRCI?

I know there is ADRCI purge command since 11g, but how can I delete part of the alertlog without ADRCI for a specified time period, I want delete everything older than 15 days.
0
votes
0answers
17 views

Oracle 12c. Is it possible to export a TDE encrypted table using expdp / impdp to a database without TDE / wallet enabled?

I have an Oracle 12c database where I have encrypted certain columns of several tables, I want to import or load these tables into another database which does not have TDE enabled, as would be ...
1
vote
0answers
22 views

Using Merge in Oracle to update a table and clear out a field if the record is not in the source table

I need some help converting an MSSQL Merge statement into Oracle MERGE INTO A USING B on a.a_id = b.b_id WHEN MATCHED and isNull(a.a_field, '') <> isNull(b.b_field,'') THEN UPDATE SET a....
0
votes
1answer
43 views

Query that marries data between two databases

Database 1 is the master database where data on all domains in our client's industry are stored Database 2 (or Database N) are the application specific databases of our client. (e.g. Application ABC ...
0
votes
1answer
16 views

SQL*Loader and DC firewall timeout

We are loading a huge dataset using SQLLDR and there are index creation that lasts for a couple hours or even more. Firewall drops this connection as there is no data transfer during index creation ...
0
votes
1answer
50 views

PostgreSQL vs Oracle double

More of rant, than a question, but maybe someone would explain -- why PostgreSQL migration wiki states that FLOAT (Oracle) is REAL (Postgres) and DOUBLE is DOUBLE PRECISION when in PostgreSQL ...
1
vote
1answer
56 views

Having trouble starting my Oracle database

I'm a programming student and I just started learning databases in college. However, everytime I try connecting to my databse in Oracle SQL Developer I have this message: ORA-12505, TNS:listener ...
1
vote
0answers
42 views

Is it possible to alter normal column to virtual column in Oracle?

ALTER TABLE TAB_NAME ADD TEST_COL VARCHAR2(255); ALTER TABLE TAB_NAME MODIFY TEST_COL GENERATED ALWAYS as ('some_exp') VIRTUAL; Second script gives an error: Error report - ORA-54026: Real column ...
0
votes
0answers
39 views

getitng difference of two consecutive rows

Hi i have a result like this from my query. and i want to get the difference of a specific epmloyee break time so i need to minus the time (OUT-IN). I have search the net but i see nothing related ...
1
vote
1answer
33 views

Connecting to Oracle DB with LDAP-Credentials

So I would like to connect to a remote Oracle database from my Linux system using the oraclient 19c on the command line, but whenever I try to connect it sees the realmpart of my username as the ...
1
vote
0answers
32 views

GV$locked_object showing object locked but kill session is giving ORA-00030: User session ID does not exist

I have tried to execute a stored procedure but its running for an hour. So I have checked for locks using below query but it doesn't return anything. select session_id, a.object_id, xidsqn, ...
0
votes
1answer
49 views

ORA-03113: end-of-file on communication channel [closed]

i am beginer in oracle database. would you help me in this problem? when I start database with startup command i get this text Total System Global Area 3340451840 bytes Fixed Size ...
0
votes
1answer
36 views

Oracle shrink space release space to operational system in one step?

Does oracle release space to operational system when is issued alter table ... shrink space (one step) or just after move HWM (two steps) alter table ... shrink space compact?
0
votes
1answer
36 views

Oracle SYS views missing from DB instance [closed]

Hi i have a question but not sure what the problem was and how it happened though. The initial error when i logged in the DB dev machine was ORA-00942: table or view does not exists. Some of the ...
0
votes
0answers
23 views

Oracle ACL error on 10g

I need to execute a procedure that writes on an oracle 10g server, the procedure runs from an oracle 11g, I have the following error: ORA-24247: network access denied by access control list (ACL) ORA-...
1
vote
1answer
35 views

How to list all users that have a specific Temporary Tablespace like as default

I'd like how list all users that have a specific Temporary Tablespace Default.
1
vote
0answers
28 views

Is it possible to have somethink like Union-FS for Oracle databases?

I wonder if it is possible to have something like what Union-FS is for filesystems also for Databases? Usecase: You have a webapp (with Oracle as database in the backend) with several instances: one ...
0
votes
1answer
35 views

Oracle move online

I have Oracle Release 12.1.0.2.0 and I need to reclaim wasted space due to data fragmentation. I have been told that I should use the instruction "MOVE ONLINE". I tried the following but I'm getting ...
1
vote
1answer
30 views

How does MOVE COMPRESS affect future data?

I'm working with Oracle 11g and a requirement came down the pipeline to "[C]ompress our data [sic]." And I'm wondering how compression will affect future data. The actual PL/SQL isn't an issue (...
1
vote
1answer
15 views

The full contents of the bind-variable are not displayed in SQL Plus

I wrote a big query in bind-variable. I want to print it in SQL Plus, but the text doesn't show, only small part of it.

1 2 3 4 5 131