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
1
vote
4answers
2k views

Select unique records from multiple records based on max date

I have table like below +----+----------+-----+-------------+--------+ | ID | ADDR | IND | update_Date | Sq_NBR | +----+----------+-----+-------------+--------+ | 1 | PHYSICAL | Y | 11-Oct ...
0
votes
0answers
10 views

Access Oracle DB from AWS RSD Mysql DB

I have two databases. One is in Oracle and the other one is in AWS RDS MySQL. How can I access my Oracle Database from AWS RDS MySQL Database?
1
vote
2answers
193 views

oracle slow query with diferent user

I have a question with an oracle query that takes almost 20 minutes when it is executed from a schema and yet when it runs as sys users it runs in 1 second maximum ... how is this possible? ... I do ...
0
votes
2answers
34 views

How to allow for ampersand in XMLtable()?

Starting with this Q&A, note that while this works: with data as ( select 'Hallöle slovenĈina Hallöle slovenđina' str from dual ) select a.str, b.str2 from data a, xmltable( '/...
0
votes
1answer
17 views

Does the SQL/JSON Path specification allow accessing the property of a filter expression's result

I noticed a difference in the evaluation of a SQL/JSON path expression between Oracle and Postgres and I wonder which one is correct. Consider the following JSON structure: { "key1": {"id":1000, "...
4
votes
3answers
844 views

How to find archivelog gaps in the backups

I manage Oracle databases that are backed up using RMAN. How can I find gaps in the backed-up archivelogs? I.e., I want to detect when something like this happens: Take full backup with archivelogs ...
1
vote
1answer
472 views

How can I be specific about which CDB I want to connect to wrapping a PDB?

I'm quite new to Oracle. I created a CDB like cdb1 and then a PDB within like pdb1. Now I can connect to my PDB using something like: sqlplus user/password@server:port/pdb1 But can't I have two PDBs ...
2
votes
1answer
383 views

Oracle encryption wallet 12c

I exported a database to a transportable tablespace and send the data to a customer. They received the error: ORA-28365 Wallet is not open. Do I need to close the wallet before creating the export? ...
0
votes
1answer
106 views

Error handling in Pl/SQL

I'm coding something in PL/SQL for the first time and have come up with a situation. We are building a package to handle insertion tasks but it's supposed to handle the check violations instead of ...
0
votes
2answers
504 views

Oracle: Database writers idle until 'Checkpoint not complete' even with multiple redo logs

I work on an application with a steady data income of 400 MB/hr. For that purpose we have setup 10 redo log groups with a size 100MB each. Therefore, we roll over a log approx. every 15min. Because ...
0
votes
2answers
37 views

Unable to import DMP file that is made in 11g2 to Oracle 18c

My OS=CENTOS 7 Oracle=18c XE I am trying to import a DMP file that is exported from XE 11g2 and now trying to import it in 18c XE. Here are the errors: [root@linux gsw]# impdp user/pass ...
0
votes
1answer
35 views

How to get the oracle dataguard log transfer and applying status?

Logs are transferred from primary db instances to stand-by db and applied continuously. Please advise how to get the report in the following format (preferably in browser) at some frequency (say 5sec/...
1
vote
1answer
1k views

timestamp with timezone issue with TZR vs TZH:TZM

I have a Hibernate with Oracle JDBC based application inserting/updating into the following column; COLUMN_A TIMESTAMP WITH TIME ZONE DEFAULT systimestamp NOT NULL but while it automatically appends ...
0
votes
1answer
198 views

oracle dbca do not start [closed]

I need to create a new instance in an existing installation in 11gr2, but despite having configured the variables of the new instance, executing the dbca does not start, and no error message is ...
0
votes
1answer
16 views

Not able to access Oracle manager online. Port 5500 is closed [closed]

I am using Oracle 18c XE on CentOS 7. The database installed successfully but not able to bring it online to my hostname. what I did is: Added port 5500 in firewall: firewall-cmd --permanent --add-...
0
votes
1answer
23 views

[[FATAL]] [[DBT-06103]] The port (5,500) is already in use [duplicate]

I am trying to install oracle 18c XE on CentOS 7. I have opened the ports: firewall-cmd --permanent --add-port=1521/tcp firewall-cmd --permanent --add-port=1630/tcp firewall-cmd --permanent --add-...
0
votes
1answer
90 views

Failing to insert into table getting error: ORA-00600: internal error code, arguments: [ktssinseg2]

I am facing problems inserting records into my oracle database 12C R2. I have no Oracle Support. All this time I was able to do inserts into my database, but all of a sudden it is now failing. Below ...
0
votes
1answer
98 views

Oracle SCN_TO_TIMESTAMP (ORA_ROWSCN) fails

Trying to run the following SQL which is basically an exact copy of an example I have seen on multiple sites, showing how to do this (I just change the tablename) SELECT SCN_TO_TIMESTAMP(ORA_ROWSCN) ...
0
votes
0answers
26 views

You must change the ownership of ORACLE_BASE directory to “oracle” user [closed]

I am trying to install Oracle 18c XE on CentOS dedibox but this message is displayed [SEVERE] The install cannot proceed because ORACLE_BASE directory (/opt/oracle) is not owned by "oracle" user. You ...
3
votes
3answers
1k views

Oracle Database 19.3 on Windows: Howto impdp or expdp from a UNC path in Windows?

With oracle database release 18.3 it is possible to use a unc path as a directory in windows and pump a database pump from this directory with impdp. Example: C:\>sqlplus system/passwd@exampledb ...
1
vote
1answer
18 views

Move Oracle Database to New Server with Dataguard in place

I have a live Oracle Database with Dataguard in placed. I want to migrate live database to new server as tech refresh, but only Primary database. How I can achieve this? I have ideas on how I want to ...
13
votes
5answers
51k views

Oracle 12c Express Enterprise Manager webpage does not load

Problem summary When browsing to the Oracle 12c EM Express webinterface, the page times-out when using a URL like: http(s)://hostname:5500/em http(s)://hostname.domain:5500/em When using a url ...
6
votes
3answers
7k views

Add Oracle Label Security to an existing Oracle installation

We are using Amazon EC2 to host some Oracle database instances while we are evaluating and prototyping some software. We are using the AMIs provided by Oracle - specifically, Oracle Database 11g ...
0
votes
3answers
12k views

BASH: DBCA: command not found

When I use dbca command as Oracle 11g user I have the following error message: BASH: DBCA: command not found and when I checked the bash profile I found the following: # .bash_profile # Get ...
0
votes
1answer
770 views

Oracle 12c installation

I have Oracle 11g installed on my system and want to install 12c now. Read articles (Oracle docs and general) which suggest that I can do so in different homes. But, when I try to install 12c (12.1.0....
1
vote
1answer
277 views

oracle DB connection - hostdef extension doesn't exist

I am trying to connect to an Oracle DB through ERwin, yet I keep getting this error message: I know that the DB exists, as my coworkers are accessing it. The Username and Password are also correct, ...
0
votes
1answer
22 views

Why do we still need VIP when using SCAN?

When we are using Single Client Access Name (SCAN), the clients connect to the database through the SCAN name in DNS or GNS like in the example below: stackdb = (DESCRIPTION = (ADDRESS = (...
0
votes
2answers
32 views

How to connect to specific session id & serial# ? Blocked sessions

I have blocked sessions and see which session is blocking them, having session_id and serial#. Is it possible to connect to such session? How? Background: using V$SESSION_BLOCKERS I see sessions are ...
0
votes
1answer
3k views

How to execute sqlplus by root using sudo in linux?

Scenario: *oracle xe11g r2 is installed( and runs properly when logged in as oracle). *logged in as user, root *added root to groups oinstall and dba as follows: #useradd -G oinstall root #useradd -...
0
votes
1answer
13 views

Oracle PL-SQL “Regular expression” to replace each “(space)and(space)” with ',' in a string

I have a string like this x=y and g=h and u=1 and I need to replace each (space)and(space) with ,. I'm using the powerful regular_expression for this but it does not give me the desired result. ...
1
vote
1answer
17 views

Query to get duplicate records then update it by putting a sequence number

I was trying to get all records with duplicate data and update it by putting a sequence number. Let's say i have this data: +-------------------------------------------+ | first_name | last_name | ...
0
votes
2answers
9k views

Net Configuration Assistant doesn't open, created Listener in Net Manager but it isn't recognized when creating database Win 7

I have installed Oracle 11g on my Windows 7 64-bit system. The Net Configuration Assistant does not open for me to create a listener. I was able to add a listener through the Net Manger and it says it ...
1
vote
1answer
4k views

Right way to restart Oracle 12c Server with pluggable databases

I am new to oracle. I installed Oracle 12c on windows with a pluggable database on a test VM. Everything was working fine. After the installation I was able to connect via EM Express on port 5500, via ...
0
votes
2answers
35 views

sum several results

DB Source how can I add the result of 4 sum, to get this I tried this query but the total is wrong, the total include eth05 colunm. Any idea how to fix that? select router, count(*) ...
1
vote
1answer
714 views

Oracle SQL Developer: Copy paste tables, with 2 different instances, with different table structure

Here I have 2 difference instances, one is called DEV and one is called SIT2. I created a public database link, called DBLINKSIT2(Basically just to create a bridge between DEV and SIT2) and I need to ...
0
votes
2answers
35 views

query to find incorrect data [closed]

A table contains valid data and invalid data. Require query to find invalid data. Valid Data: One locatorCode can contain multiple countyCode and when even one record with serviceEndDate = 12/31/9999 ...
1
vote
1answer
41 views

Select the first row returned from the join query based on a condition

I have 2 tables PRODUCT and MANUFACTURER Table1: PRODUCT, Columns: PRODUCT_ID,PRODUCT_NAME Table2: MANUFACTURER, Columns: PRODUCT_ID,MANF_ID,ITEM_NO,DEFAULT_MANF I have to select the default ...
2
votes
2answers
932 views

Building Oracle XE docker image in Windows 10 Pro

I'm trying to install Oracle XE 18c in a docker container in Windows 10. I have docker already installed, and I need to build the image as explained here. I cloned the git repository, but I'm stuck ...
0
votes
2answers
40 views

RMAN Backup to Disk and to Cloud Parallel

I'm currently working on a backup solution for my company. One part of the solution would be to write the backup to disk and also send it to an oracle cloud archive storage for long term storage. In ...
1
vote
1answer
17 views

What does this Oracle TO_CHAR format do: “FM99990.90”

I have this number format and not able to find examples of how it will look. It is not listed on Oracle website. This below SQL is what I have and not sure what the result will look like since I don't ...
1
vote
1answer
3k views

Automating Oracle database installation on Windows

I'm trying to install an Oracle 12c database on Windows using the silent install with a response file as: setup.exe -silent -responseFile file.res Where I generate the response file using the GUI ...
1
vote
1answer
942 views

Oracle convert multiple rows to column using pivot

I have a table that contains the values +-------------+--------------+---------------------+-------------+-------------+--------------+-------+---------+-----------+---------------+--------------+ |...
0
votes
1answer
350 views

Create trigger to ignore user input for Identity Columns

Using the this table definition CREATE TABLE testtable ( id NUMBER GENERATED AS IDENTITY, desc VARCHAR2(30) ); I would like to create a trigger before inserts and updates to ...
0
votes
1answer
449 views

Why we can FLASHBACK DROP table where it is DDL command and hence autocommited?

DROP and TRUNCATE both are DDL commands and both are autocommited.Then why we can recover DROP table by using FLASHBACK(unless it is purge) and why we can not recover TRUNCATED data(don't consider ...
0
votes
0answers
43 views

Logon Trigger IP Address Issue

I have this logon trigger to restrict IP addresses. It is the same trigger I have seen everywhere. However, it is not working as expected, and I was hoping someone could give some direction. I am ...
0
votes
0answers
14 views

Itemize billing by schema in Autonomous Database

Is it possible for the operational cost of running the autonomous database to be itemized by schema (or groups of schemas) (This would allow IT to pass on operational costs to departments within our ...
0
votes
1answer
13 views

What permissions are required for complex cross-schema materialized view in Oracle?

I have a complex cross-schema query that I'd like to create as a materialized view in Oracle 19c (although the database has been ported forward from numerous historical versions of Oracle). This ...
0
votes
0answers
12 views

How to restart an installation of Oracle grid 19c

I would like to know how to perform an installation after trying a previous installation that gave an error. During the installation of the grid in a RAC 19c I was given an error almost finishing it ...
1
vote
1answer
52 views

About real time statistics oracle 19c only for particular table

Reg Real-Time statistics which extends online statistics gathering(12c) to also include conventional DML statements. Real-time statistics helps the optimizer generate more optimal plans.Whereas bulk ...
0
votes
0answers
21 views

Oracle source with SSIS 2008

I am trying to use an Oracle OleDb source in my SSIS package with no luck, every time I try to connect to the server I get the error: ORA-12154 tns could not resolve the connect identifier ...

1
2 3 4 5
134