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
65 views

How to connect to Oracle RAC from HOST

For a college project, I have to set up a RAC Instance and an application, I already managed to configure my RAC lab by using virtual machines by using this video guide, now I just need to program an ...
0
votes
3answers
46 views

Oracle, defining variables in a WITH query

Just wondering if it is possible to define variables in a WITH query? I've tried but query keeps failing. Just something like WITH DEFINE var1 = 'ABC'; SUBQUERY1 (col1, col2) AS (SELECT col1, col2 ...
0
votes
1answer
82 views

Trigger created with compilation errors

SQL> create table master(pno number(5) primary key,pname varchar2(20),price number(10,2),stock number(5)); Table created. SQL> create table trans(p_no number(5),no_pro_sold number(5)); Table ...
0
votes
2answers
47 views

Oracle 12cR2 RAC - ORA-06508

Environment: DB Version: Oracle Database 12cR2 EE on Exadata RAC: True Problem: ORA-06508 on procedure. One of our users had a DBA role privilege, we don't want such a big privilege to be defined ...
0
votes
0answers
26 views

See Max Simultaneous Sessions Per User

In an effort to set a reasonable sessions_per_user profile setting for shared database accounts or other non-unique account (ie. an account an application uses to log into the database for all app ...
0
votes
0answers
30 views

Create a unique local index and ORA-14039

I'am trying to partition a index from a primary key. For that, I've done: Disable the constraint. SQL> alter table DANILO.SUB_PAT_TEST disable constraint SYS_C007918; Table altered. SQL> Try ...
0
votes
1answer
30 views

Will purging listener_scan1.log, listener_scan2.log, listener_scan3.log in Oracle 12C RAC Configuration not affect database services negatively

I have a got a oracle 12c database configuration where there is RAC configuration for DB01 on one server and DB02 on another server. The issue i have is that the listener_scan1.log, listener_scan2....
0
votes
0answers
5 views

SSIS - Attunity 5.0 Oracle destination running for hours yet row count shows data has arrived so why does the dest task look in a hung state?

Using SSDT v14 A simple package that extracts data from a SQL Server view and sends via Attunity to Oracle takes about 5 hours to run, of which 4 hours seems to be the Oracle destination task showing ...
0
votes
0answers
53 views

Oracle Query Performance

I have a query that I need it to be execute fast as possible. Even though I have indexes, it is executing very slowly and I can't figure out why. This is the query, I am trying to optimize. SELECT d.*,...
0
votes
1answer
12 views

oracle query to split data into per-date rows

I need to create a report which splits the values from table A into a row-by-date format. So for example If I create a sub-set of dates for the past week and sales in the past week, I need to output ...
0
votes
1answer
34 views

How can i Restore Oracle 12c database Schema from a full EXPDP dump on a Test Server providing a new scheam name?

I have a production database whose full dump is 500Gig and and I cannot do a full restore on a test server because of space issues. However I need to restore a certain schema in from that dump into ...
0
votes
1answer
21 views

Query to show whether a record is appeared in the previous date or not

I have a table with below structure and sample data: create table TEST_ONE ( purchase_date DATE, customer_id NUMBER ) | purchase_date | customer_id ---------------------------------- |...
0
votes
1answer
103 views

How do I SHOW TABLES in Oracle Database?

I'm trying to do a SHOW TABLES command in my Oracle Database 19c as documented here. But when I run that command all I see in the output of SQL Developer is this: Show tables handled. How can I get ...
0
votes
3answers
39 views

Does using "qb_name()" hint (query block name) in a query have significant effect on performance?

I've just become familiar with the hint "qb_name" (query block name) in Oracle and below you can see an example of using this hint in a query: select /*+ qb_name(main)...
1
vote
0answers
35 views

RMAN: not Connected to Database

While issuing the Restore Database command, the RMAN utility says Not Connected to ORACLE, but When I try connecting Oracle using the command Connect Target it says Already connected to ORACLE. All I ...
0
votes
0answers
25 views

Communication error between Oracle and Nagios

I'm trying to adapt some Perl scripts to Bash to run them in Nagios XI. The complete script, so far, is this one: . /home/oracle/.profile_RAC ORACLE_HOME=/oracle/app/grid/19300 ORACLE_BASE=/oracle/app/...
0
votes
1answer
33 views

Oracle - EXECUTE on package without explicit privileges

I'm trying to understand package permissions in Oracle. If user A is granted EXECUTE on a package owned/created by user B, and that package makes various inserts and updates to a table owned by user B,...
0
votes
1answer
29 views

Difference between oracore and oracore3 folder?

I'm trying to fix a timezone file mismatch between a server and a client. The server points to timezone_36 files and the client points to timezone 32. I got a patch from our oracle supplier but it ...
0
votes
0answers
21 views

How to store data in loop and after assign data set to out ref cursor in Oracle

I tried to store date in loop and after that dataset set to OUT SYS_REFCURSOR. In this time I declared array variable and I tried to store data in loop by each iteration. and after, I want to assign ...
-1
votes
1answer
42 views

I have error in one machine from ORACLE cluster

I am using Oracle 10g Cluster. So, the listener on 1 Oracle machine hasn't been working for a week now. I get an error: ORA-12541: TNS:no listener When I want to start listener from oracle user, ...
0
votes
1answer
23 views

Stop Dataguard configuration to test standby database

I would like to know how it would be the correct way in which I should proceed to stop the Dataguard configuration in order to perform a series of tests on the standby database. It turns out that I ...
0
votes
1answer
49 views

Oracle 12c - Logon Trigger According To Machine Information

I want to create a logon trigger. Trigger will do the following: It will block access to the database based on certain users and certain machine information. Then it will give an information message ...
0
votes
1answer
37 views

Does trailing wildcard use index? (where column like 'value%')

I have a query on a Varchar2 field in an Oracle table: select column from tbl where column like 'value%' That query uses a trailing wildcard. Question: Is Oracle capable of using an index on that ...
0
votes
0answers
30 views

Concatenate external variable into Select Statement with no. of TABS based on length of external variable

Could someone please help with this requirement. WHENEVER OSERROR EXIT FAILURE WHENEVER SQLERROR EXIT SQL.SQLCODE FAILURE SET newpage none SET trimspool ON SET feedback OFF verify OFF tab OFF echo OFF ...
0
votes
0answers
44 views

Oracle will not start with ORA-01092: ORACLE instance terminated

I'm in need of urgent help with this one. My Oracle 11gR2, running on a VM, crashed when the datastore of the host filled up. I got the VM to start and as I'm trying to start the DB, I see this: ...
0
votes
1answer
30 views

Options for handling a column that is an instance count

Consider the following table CREATE TABLE example ( example_id NUMBER, -- PK parent_ref NUMBER, -- FK to parent variant VARCHAR2(8), -- An arbitrary string ...
0
votes
1answer
42 views

how oracle data guard operate SCN?

when use data guard, primary propagate redoLog and standby apply redo log. the transaction inner redo log was applied on standby will has same SCN with primary ? the apply action will cause the ...
1
vote
0answers
29 views

Extremely slow updates to small Oracle table from rails app (oracle r12 and r19)

I'm not sure if this is a rails issue, or a database issue, but as this seems to be a schema specific issue, I'm looking at it from the database side first. (Other customers with the same setup on ...
1
vote
1answer
24 views

action can't be completed cause file is open in oracleserviceorcl

I want to delete the files I installed of oracle but it says action can't be completed cause file is open in oracleserviceorcl . is there a way to delete it ?
0
votes
0answers
22 views

FGA AUDITING does not record audit

hello i dont know why my fga auditing is not working my code EXEC DBMS_FGA.ADD_POLICY(OBJECT_SCHEMA=>'PLSQL', OBJECT_NAME=>'REGIONS', AUDIT_COLUMN=>'REGION_NAME', POLICY_NAME=>'REGPOL', ...
0
votes
0answers
34 views

DBMS_HS_PASSTHROUGH Bulk Fetch

i have question about DBMS_HS_PASSTHROUGH geting result set without stored_procedure i have oracle and i have database link so i am running this query select * from table where id >20 via ...
0
votes
0answers
35 views

how to get all ROWIDS of a chained row in Oracle Database

From Query change notification receiving a row id. with the received row id when i query the table it is returning no rows. as the table have the 400 columns row data is stored in 2 blocks which in ...
-1
votes
1answer
28 views

crontab not executing oracle database image copy

Dears i have an rman script for a full Oracle Database Image Copy that i have made and i have added it to a crontab job and buts it is not getting executed and i dont know why: below is the database ...
1
vote
1answer
26 views

EXPDP - why is block estimate significantly larger than segment size?

I'm exporting one specific table for a schema which I thought was a relatively small 5.4 GB SQL> select bytes/1024/1024 MB from user_segments where segment_name='TABLENAME'; MB ---------- ...
1
vote
1answer
21 views

SSIS: Can't save "parallel load" option in Oracle destination with Attunity driver, how to solve this?

I am working on an existing SSIS package that has proven to run successfully, however, due to data volume issues, I would like to try enabling the "parallel load" option by selecting the ...
0
votes
1answer
29 views

What if a diskgroup runs out of space?

For my BD I have a DATAC8 diskgroup that has still have 38 GB usable space, day by day, it has less space... what will happen when it's over? can the BD stop or something?
0
votes
1answer
49 views

Listener oracle in pacemaker cluster

I need some help. I have created a cluster with 2 nodes. I created all resources, but listener has errors and the pacemaker cluster status shows Oracle Listener has stopped. In the web interface I ...
1
vote
1answer
24 views

How can i see the location of Oracle Datafiles, query result set is returning a direct that starts with (+) e.g +DG_DATA/lv_vcpdata4

I am trying to find the location of oracle data files in Linux and after querying the database, i find results where the data file path starts with a (+) as below: +DG_DATA/lv_vcpdata4 +DG_DATA/...
-1
votes
1answer
108 views

Sql plus equivalent in psql

I'm tasked of migrating some code from sqlplus to psql In oracle, I have a bash script that excutes a stored procedure and based on the result it calls a sqlplus that spools multiple files to dump ...
0
votes
1answer
35 views

Collection with additional column to %ROWTYPE columns (two-way MINUS comparing two data sets)

I am looking for a way to create collection that would have one additional column that the source table/view columns referred by %ROWTYPE for simplicity. TYPE my_type IS RECORD ( mode varchar2(10), ...
0
votes
1answer
35 views

Insufficient privilege for read only transaction

I am using Oracle and SQL Developer and here is a problem I ran into. I have created a table called T_TEST and I am trying to create a read only transaction to it from another user. This is my ...
1
vote
2answers
41 views

Best way to study a new type of database if you are experienced in another type

Does anyone have a good approach to learning a new type of database when they already are proficient in another one? I have thought about writing notes to myself about how to do various tasks that I ...
0
votes
0answers
40 views

Oracle session and process reaching max utilization issue with Oracle 18c+Tomcat9

Currently we migrated to Oracle 18c+ Tomcat 9 after which we are experiencing high utilization issue with both processes and sessions. INST_ID RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION ...
0
votes
0answers
12 views

Oracle: ASM password file on RAC DB to create standby, how make it work?

In 19c I have a RAC DB with its pwd file located on +DATA/DBUNAME/orapwfilealias pointing to +DATA/DBUNAME/PASSWORD/orapwdbuname.356.1186610343 (as a result of command 'orapwd file=+DATA/...'). I've ...
0
votes
0answers
18 views

Changing HSM encryption key

A customer is asking us to update its HSM encryption keys that interfaces with its Oracle infrastructure. Never worked on such thing: I made a quick research on the Oracle docs to understand that HSM ...
0
votes
0answers
37 views

Restore PDB with rman

I have a DB running in NOARCHIVELOG mode with some users and their schemas. I'm creating a backup of my PDB using the following commands in rman (I'm connected to the PDB): SHUTDOWN IMMEDIATE; STARTUP ...
1
vote
2answers
96 views

Oracle simple count(*) SQL query takes "forever"

I'm encountering an "issue" (at least a strange/slow behavior) with a new installation of Oracle 12c on Windows Server 2019, with this query which takes at least 5 minutes to complete: ...
0
votes
0answers
24 views

How to resolve the "file 1 needs media recovery" error in Oracle 11g?

I am trying to migrate oracle 11g database from Windows to a Linux server. I have followed these steps for migration: I have opened database in mount mode. Then I have backed up file on the Windows ...
0
votes
1answer
22 views

How to split one column into two using different tables?

I am developing a frontend application in VBA, which is linked to an Oracle database. In Oracle there are the two tables Table1and Table2, which are related to each other by expTypeID and measID: ...
1
vote
0answers
205 views

Oracle forms Installation Error - INST-07545

In Oracle forms and reports when I select oracle home to be C:\Oracle\Middleware\Oracle_Home I get INST-07545: Unexpected Error. java.lang.NullPointerException as shown : Now here's another related ...