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
-2
votes
1answer
18 views

Iterate through a list of strings In SQL scriipt

I'm trying to create a sql file that iterates through a list and get me the information from a group of servers and save it on CSV file. The DB is Oracle, just in case :S. I'm running the file using ...
1
vote
0answers
29 views

TNS-00534: Failed to grant connection ownership to child

when I tried to connect to my oracle instance with sql developer, I see this error in logs TNS-12518: TNS:listener could not hand off client connection TNS-12560: TNS:protocol adapter error TNS-...
1
vote
0answers
64 views

Error in starting oracle 18c express editiom

I have little problem with starting oracle 18c express edition, when I tried to startup, it wrote me the error ORA-00205: error in identifying control file, check alert log for more info SQL> ...
0
votes
2answers
33 views

Launching LSNRCTL produces an error

I am trying to launch LSNRCTL on my Windows 10 64-bit laptop; Oracle 18 XE I get this error message: C:\app\Owner\product\18.0.0\dbhomeXE\bin>lsnrctl LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 ...
-1
votes
1answer
25 views

Oracle SQL - How to group by a column and count other column for each different value?

I'm struggling trying to get the desired result when querying 2 tables. These are the tables: Table1 column1 (fk) column2 other_columns... 2 a 2 a 3 c 4 a 4 b 4 b 4 d Table2 column1 (pk) ...
0
votes
1answer
29 views

SP2-0734: unknown command beginning “sys_contex…” - rest of line ignored

I Googled how to get the username of the current user and was told to use: SQL> sys_context('userenv', 'session_user') But when I type that command in, I get the error: SP2-0734: unknown command ...
0
votes
0answers
24 views

Easy way to display HTML results from Oracle (SQLDeveloper) in Browser?

I'm curious, if there is an easy way to display any kind of html reports generated in SQL-Developer by packages like e.g. dbms_sqltune.report_sql_monitor() in an external browser like Firefox etc. ...
0
votes
0answers
32 views

How can I start Oracle as a lightweight process?

I have OracleDB running in a CI pipeline in a docker image. With each test it is started and then shutdown. It's purely there because Django tests expect a real database. However it takes a couple ...
0
votes
0answers
9 views

Error occurred in Spring boot + Gradle + Oracle jdbc + jsp project

I'm doing Spring boot project, and I'm trying to add dependencies which are ojdbc8 and tomcat-embed-jasper. ojdbc8 library is for connecting Oracle database by using Hikari, and tomcat-embed-jasper is ...
0
votes
0answers
30 views

Can I safely delete /var/log/messages-20210328 which is 383M under / directory ? OS version:Oracle Linux Server 6.7. db version Oracle 11g

the content of file is displayed using # cat /var/log/messages-20210328 Output: Mar 21 04:31:11 testdb snmpd[17566]: Connection from UDP: [*.*.*.274]:61775->[*.*.*.*] Mar 21 04:31:11 testdb snmpd[...
0
votes
0answers
23 views

When does Oracle automatically flushes in-memory monitoring information?

We can use FLUSH_DATABASE_MONITORING_INFO procedure from dbms_stats package. But when Oracle automatically flush this monitoring info without using this procedure? Can we configure it? I've found this ...
0
votes
0answers
20 views

Oracle - Exchange partitions between two List partitioned tables

Need some help here. I have an ETL process which loads the data into a target table A. We have created another table B which is same as the target table in structure and this table is accessed by ...
0
votes
1answer
37 views

PL/SQL - how to identify sequences used by tables?

Is there a way to get a resultset from executing a query against an Oracle database that would return a listing of all the tables in the database and which sequence it is using (if any)?
0
votes
1answer
33 views

Oracle 12cR1 - Duplicate Database With No Resetlogs

Database version: Oracle 12cR1 Operating system: Oracle Linux 7.x ASM: yes Duplicate script: cat duplicatetodisaster.sh ORACLE_UNQNAME=xxx ORACLE_SID=xxx ORACLE_HOME=xxx rman target sys/***@PROD ...
0
votes
0answers
33 views

Graphically representing SQL queries

The Problem I am trying to document a large number of SQL queries at my workplace. I'd like to programmatically parse the queries and generate graphical representations (diagrams) of the queries. For ...
0
votes
0answers
22 views

RMAN Catalog requirement with DataGuard

If you have an 11g or 19c Oracle Standby DB setup using dataguard must you use an RMAN catalog when backing it up? I ask, because it was a requirement in much older versions of Oracle (e.g. 9i) but I ...
0
votes
0answers
35 views

RMAN-08120: warning: archived log not deleted, not yet applied by standby

BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; In Data Guard environment this command tries to 1.backup archivelog before starting backup 2.delete archivelog before starting backup 3.backup database 4....
1
vote
1answer
46 views

I am counfused about when Oracle database won't do parsing

I am confused about when Oracle database won't do parsing? In the AWR report, there is a metrics called "execute to parse", which means more SQL just execute without parsing when it ...
1
vote
1answer
15 views

Does Oracle use rowid to recover from redo log and archives?

I am learning about supplemental logging and this questios has came into my mind. What I have understood is, Oracle just save an image of the modified column in redo logs, that is why we need to ...
1
vote
1answer
13 views

What is the difference between start and enable in the Oracle RAC srvctl?

In the Oracle 12c documentation it was not clear what is the difference between the srvctl start and srvctl enable commands for services associated with a database. In the view dba_service a database ...
-1
votes
0answers
33 views

Best Suitable Database Structure in Oracle for Multiple Questions and Answers

I am building a Form in which User Select Different types of Protocol Select Protocol: Protocol 1 Protocol 2 Protocol 3 If user select Protocol 1 Then Number of Disease (Disease 1, Disease 2) Will ...
0
votes
0answers
42 views

SQL Analyze - dbms_stats consuming much CPU on Oracle Server

In one bigger DB with many user schemas and big tables I have the devs starting regulary the Analyze select dbms_stats queries , that consume a lot of cpu when started for many users at once. These ...
0
votes
0answers
27 views

Backup Optimization

The production database is configured to backup with parallelism 16. I noticed that first 16 channels is allocated and each channel backups 61 datafiles, after that, next 16 channels backup 20 ...
0
votes
0answers
30 views

Alter view Statement is throwing ORA - 01031 Insufficient Privileges error [closed]

Oracle is throwing ORA - 01031 Insufficient Privileges error In oracle when I try to execute the Alter view statement.
0
votes
0answers
48 views

Are the tables in the oracle unique? [closed]

How is a table with the same name that was deleted from a table that was created with the same name in Oracle? Does she have a unique id? SELECT * FROM all_tables For example - Does she have a unique ...
0
votes
1answer
25 views

Cartesian product of same set in oracle not working [closed]

Here is an image from SQL PowerArchitect depicting what the database contains: I am trying to run: CREATE TABLE 4 AS SELECT Sells.StoreID as ID1, Temp1.StoreID as ID2, UPC, Price FROM Sells, Sells AS ...
0
votes
1answer
49 views

SQLcl Oracle to export data to CSV without blank first line and without carriage return character at the end

For reasons, I am using the following here-doc approach to export data to CSV. $ /oracle/sqlcl/bin/sql -s username/password@//host.mybiz.com.my:1521/dwh > arca.csv <<EOF SET SQLFORMAT CSV SET ...
0
votes
1answer
48 views

What could be the best DBMS to store airbnb data for price prediction [closed]

I have a school project in which I need to predict the airbnb listings prices in 5 different cities. So I have about 400,000 records each with 19 columns. All the examples on the internet that are ...
0
votes
1answer
16 views

Oracle - PFILE or SPFILE when instance is down

This may be a stupid question, but I can't find any information out there on this. Is there a way to tell if the database uses a pfile or spfile when the instance is down? For example if an Oracle ...
0
votes
1answer
30 views

Can you have more than 65536 sessions on an Oracle RAC database?

I put this same question on Oracle's community site but this site gets a lot of activity so I am posting here also. Apologies to anyone who is on both. Other post: https://community.oracle.com/tech/...
0
votes
2answers
21 views

REGEXP_SUBSTR to split delimited values

I have a field called FREQUENCY and it has values like '10,0;30'. How do I write a regular expression to get the result like this: FREQUENCY 10 0 30
0
votes
0answers
33 views

How to find reason for rollback during rollback works in Oracle?

Working on Oracle 12.c, I have a situation, that a big transaction performs a rollback, which takes several hours. I see the status of the session e.g. in V$SESSION.MESSAGE "Transaction Rollback: ...
1
vote
2answers
61 views

Oracle procedure sometimes runs endlessy, other times finishes instantly

The procedure always compiles instantly and I'm pretty sure I don't have any infinite loops or some other bug in there. When running the procedure in SQL Developer it sometimes finishes instantly (as ...
0
votes
1answer
39 views

How are the DBA, SYSDBA, SYSOPER roles and SYS, SYSTEM users related in Oracle?

I don't know if I understand correctly the privileges of these built-in users and roles. This is the list of information I have found: I think that DBA and SYSDBA roles enable to do everything - if ...
0
votes
0answers
31 views

import .dmp in Toad : Invalid format of Import utility name Verify that ORACLE_HOME is properly set

When I tried to import a DMP file using TOAD (9.0.1) Import Utility Wizard I get an error Invalid format of Import utility name Verify that ORACLE_HOME is properly set Any suggestions please? I ...
1
vote
0answers
21 views

Oracle Database monitoring: Replication working or not?

How to define database replication is working or not by using Oracle data guard? select max(sequence#) a from v$log_history; we got primary and standby database last log sequence# from this query. If ...
1
vote
0answers
18 views

What is the threshold of sequence# difference between primary and standby database when checking replication status?

I am checking if replication is working properly in standby database. For this, i calculate the difference between sequence# of v$log_history. I am using this query to find the max sequence number. ...
0
votes
0answers
8 views

Backing up an Oracle Standby database

I have a quick rman Backup question. If I would like to run RMAN backups on my (dataguarded) 11g physical standby database, what status should that standby db be in? At the moment the standby is in ...
0
votes
1answer
15 views

how to restrict usage of datafile in Oracle

We have several datafiles with a big amount of a free space. How to shrink those files on production system. I tried to move all objects from this files into another tablespace, but RDBMS is still ...
2
votes
1answer
92 views

ORA-39014 import in Oracle 19c from DMP file of Oracle12c

I have been testing out expdp/impdp of databases from 12c to 19c( newly created database) but one db have game me this error: nohup impdp system/****@CKLPROD CONTENT=METADATA_ONLY PARALLEL=4 DIRECTORY=...
0
votes
1answer
13 views

Some view to find out which jobs are in the queue to be executed?

A environment start several refreshes along the day. If I change the job_queue_processes to 20 for example, it start several new jobs. Is there some view that I can see which jobs is waiting and will ...
0
votes
0answers
17 views

Why Oracle AWR report's I/O stats are different from the I/O monitoring data captured on operating system?

I am using Oracle 11.2 on Redhat 6.8, and working on some I/O issue. I got a AWR report of Oracle DB for a certain day, and I found that "Read per Second" in "IO Profile" section ...
0
votes
1answer
33 views

why is there an index range scan on max() query?

I have a table that logs the transmission of data to another system. create table transfer_log (id number(10), fk_data number(10), first_sent_time ...
0
votes
1answer
22 views

Oracle RAC 18c Patching - datapatch

After patching GI Home and DB Home simultaneously using command: .oraenv +ASM1 opatchauto apply /patchlocation Should i run ./datapatch from DB home or GI home? Or it doesn't matter from which home? ...
0
votes
0answers
39 views

Use Python to parallelize processing of rows, or is there a native way?

As mentioned in a recent question of mine, I'm new to Oracle: Running Oracle's sqlldr on VirtualBox VM from my MacBook (client) machine I'm back, this time with a question about the best way to ...
0
votes
0answers
40 views

Oracle 17410(connection reset) when using count(*) on cross join cte with json_table

Met strange behavior using query with json_table in cte at oracle - connection reset from server, without details. Illustrating artificial query is: with data as ( select 5 as some_value from ...
0
votes
1answer
28 views

Postgres's equivalent for Oracle's datafile recovery

In oracle, one can do a recovery from datafiles. Does Postgres have an equivalent procedure? I am already aware of the WAL files in Postgres, but I believe this is different. Datafiles in Oracle are ...
0
votes
1answer
16 views

Which view contains all Oracle's catalog views?

I don't remember and cannot find the name of the view containing the list of all Oracle's catalog DBA_%, ALL_% and USER_% views. Any help?
0
votes
0answers
26 views

Oracle impdp INCLUDE parameter

I have an script that uses IMPDP over a database link (no expdp used) to import some data from our PROD environment to a DEV environment. Some tables are rather gigantic and partitioned, and we want ...
-1
votes
2answers
37 views

sql query to fetch exchange rate by dividing the amount in the same table

Given a table sales, with item selled in two different currencies how to get the exchange in EUR Sales Table: item currency Amount A USD 1000 A EUR 833.33 B JPY 50 B EUR 200 C EUR 10 C CAD 2 ...

1
2 3 4 5
143