Oracle Database 12c. Please also tag oracle for search purposes.

learn more… | top users | synonyms

0
votes
1answer
40 views

Backup and Restore with RMAN Oracle 12c

I'm trying using RMAN to create and restore backups. I'm getting an error stack trace when trying to restore to one of the backups that I have made. The error is RMAN-00571: ...
0
votes
1answer
42 views

I don't want to have the error when I drop a table although the table doesn't exist [closed]

I am using Oracle 12c and I am not interesting to have an error while droping my table 'CONTINENT' in case it doesn't exist. I did this set echo on set serveroutput on alter session set ...
0
votes
1answer
19 views

Plug a PDB in a new CDB without XML manifest

In oracle 12c the ALTER PLUGGABLE DATABASE "PDB1" UNPLUG INTO 'PDB1.XML' statement create the XML manifest. Is it possible to plug a PDB in a new CDB if it isn't correctly unplugged first and the ...
0
votes
1answer
23 views

SQL.EXPIRE_TIME in sqlnet.ora

I have set sql.expire_time parameter to 10 which recommends me to keep in my two node RAC database. At times, my application gets the error ORA-3135, therefore I suspect that this parameter could have ...
0
votes
1answer
17 views

Restricting info to SYS users - Oracle

Is it possible to restrict sensitive information from users having sysdba role? Does Data redaction help us in achieving this? I know we can restrict particular schemas to prevent from viewing from ...
0
votes
0answers
24 views

How to backup and restore asm password file stored on ASM if ASM isn't available?

Oracle recommends backing up the ASM password file using pwcopy in ASMCMD. This would only copy it to another diksgroup. source : Backing Up and Restoring an Oracle ASM Password File in a Disk Group ...
0
votes
1answer
16 views

OR-01422 ORA-06512

Can someone help to solve this error? I couldn't write pl/sql query of this .thanks. spool 150OMGIddl.sql declare c clob; begin SELECT ...
0
votes
1answer
16 views

Standby archive deletion

I have a primary database with a standby in data guard configuration running in a RHEL host. Thing is the storage assigned to this DR is very less, meaning the archive logs file system gets full in ...
0
votes
0answers
29 views

How to concatenate using cast(collect()) in Oracle DB?

My current query: select distinct mb.BP_TYPE,mb.ABS,mb.BLD_SEQ_CODE, mb.BPCODE||'~'||(select LISTAGG(mbp.PROCEDURE,' ') within group(order by mbp.LINE,mbp.SLN1,mbp.SLN2) from MIS_BS_BB_PROC mbp ...
1
vote
1answer
49 views

PL/SQL block fails in job but succeeds in SQL*Plus

I created a PL/SQL block which gathers certain data from tables in my Oracle 12c database and writes them into a .csv file. I cannot share the whole PL/SQL block but can outline the code --create ...
0
votes
2answers
31 views

IP Change in Oracle database Query

I have a two node RAC database running in OEL 7 server. Now if there is a need to change the IP addresses of the already running server to a new one, will it hamper my functioning of database? What ...
0
votes
1answer
26 views

Oracle home is missing

I have an Oracle 12c database running in OEL 6.. yesterday due to some OS related issues, my Oracle home software mount-point got erased completely. The only thing that is left is the pfile and data ...
1
vote
1answer
44 views

Backing up database with missing datafile

Is there a way to backup a Oracle 12c database which has a missing datafile? I dont have backups. Database is running in archive log mode. One of the data files is physically missing from the disk. ...
1
vote
1answer
57 views

Don't preallocate many gigs of ram in Oracle Database 12c?

I've just installed Oracle Database 12c Enterprise for Windows. The first thing I've noticed is it preallocates almost 10GB ram. How can I configure Oracle to only allocate and deallocate ram as ...
1
vote
0answers
17 views

How to enable missing Tempspc column in Oracle explain plan

I am trying to debug "ORA-01652: unable to extend temp segment" from a data warehouse ETL batch job, but my plan_table_output view from explain plan does not show the "Tempspc" column. But I do not ...
1
vote
1answer
23 views

Oracle 12 - Reporting on Roles

Is there a way to report on all the custom roles and/or responsibilities created within Oracle, Outside of SQL? I am looking for a dashboard that shows how many have x role, y role that could be ...
4
votes
2answers
97 views

Oracle sort order changed

We recently deployed a new environment with a newer version of Oracle (12c) instead of 11r2. Only recently I noticed my data returned is sorted differently. Instead of having small letters, capital ...
1
vote
2answers
36 views

Oracle binaries query

im not sure if this would be considered as a question or not. I would delete it if not counted for. But just wanted to know, where can I get Oracle 12.1.0.1 software binaries. ...
0
votes
0answers
21 views

Enabling audit in Oracle

I have a table 'class' owned by the schema 'test' and I need to audit all operations on the particular table. audit INSERT,UPDATE,DELETE ON test.class -- will this be sufficient to do the trick? ...
0
votes
1answer
49 views

Read-only user query in Oracle

I have been asked to create a read only user in a Oracle database 12c. The read only user must have read only grants only to the objects of select schemas, which I created and handed over. But now ...
0
votes
1answer
47 views

kind help to correct syntax [closed]

create table first as (SELECT * FROM edge1 h1 inner join edge1 h2 ON ( h1.e1=h2.e1 AND h2.e1 != h1.e2 AND h2.e1 != h1.e3 AND h2.e1 != h1.e4 AND h2.e1 != ...
0
votes
1answer
66 views

Non-RAC single instance with ASM startup query

How to start a non-rac single instance with ASM file system. As in the case of RAC after reboot of server, the ASM and CRS resources startup automatically.. but with non-RAC but with ASM storage, what ...
3
votes
0answers
66 views

Help with query to find intersection between arbitary rows of a table under conditions

CREATE TABLE "SYSTEM"."SAMPLE" ("E1" VARCHAR2(20 BYTE), "E2" VARCHAR2(20 BYTE), "E3" VARCHAR2(20 BYTE), "E4" VARCHAR2(20 BYTE) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ...
2
votes
1answer
72 views

fastest way to generate permutations of a table with n columns and put in a new table added one more question to same how to remove duplicate rows

As i am from mathematics background and require to do some huge permutations to start in my work kind help. If i have a table by name sample1 with n columns what is fastest way to get all the ...
1
vote
1answer
62 views

Tracing failed login attempts in Oracle

I have some users who are logging in with a wrong password and their accounts get locked. Now I need to find the source of the failed login attempt. The machine, username etc. Is it possible to find ...
3
votes
2answers
50 views

Oracle import dmp file: ora exceptions

I'm trying to import a .dmp file to my oracle RAC database using the following command: C:\app\ptmp>impdp [user]/[password]@'DEVRAC-SCAN:1521/DB' DUMPFILE=UPG_E_7d291ff.dmp ...
3
votes
1answer
40 views

USERS Tablespace Best Practices for Application Schema

When creating a user/schema to hold external application data, what are best practices for the tablespaces that the user is defaulted to? Should the user created be defaulted to the USER tablespace ...
0
votes
0answers
66 views

Find all possible pairwise 2 rows such that there intersection is only one element I have also a general question help on the same

Kind help to find the intersection of all pairs of rows of table and display only those pairs whose intersection is only at one element. Here I have a table say with 4 varchar elements for a sample ...
0
votes
0answers
31 views

Are all Oracle DB Control features available in Enterprise Manager Express or Cloud Control?

I'm having a hard time figuring out if the new replacements for DB Control (Express and Cloud Control) support all of the features that were available in DB Control. I know Express is very limited, so ...
0
votes
1answer
40 views

How can I use Oracle Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database?

How can I use Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database? I want to have a replication/slave database to have all the ...
5
votes
2answers
159 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 ...
0
votes
1answer
18 views

How to pass parameters to delete statement?

While executing this PL/SQL block: CREATE OR REPLACE PROCEDURE procAuth_Title_Delete (auth_ID NUMBER, title_Nos IN NUMBER) IS BEGIN DELETE FROM ...
0
votes
1answer
62 views

Oracle migration unable to create indexes

I want to move the contents of a database instance to another using the expdp and impdp utilities. The source instance is version 12.1.0.1.0 and the destination is 11.2.0.1.0 so I modified the expdp ...
0
votes
0answers
28 views

Composite Partition for Oracle SQL Table

This is my first time that I'm working with composite partitions. I'm trying to arrange by list and range. My code is as follows: CREATE TABLE CHANGE_LOG_DRIVER_COMP ( LICENSENUMBER VARCHAR2(100 ...
1
vote
2answers
62 views

Testing on Logical Standby Database

Primary DB: 11.2.0.3 Enterprise Standby DB: 12.1.0.2 Enterprise I've found several articles on making changes on a Physical Standby DB, but I've been having difficulty locating how to enable ...
1
vote
2answers
35 views

Fetching recent/historical queries run on a database from an application

I'm getting some database errors from an application related to unique constraints however none of the records have any duplicate values so I want to check what query was run that produced the error. ...
0
votes
0answers
19 views

Move encrypted String from Oracle DB to DB2

I have a normal String athakur@test.com. It is stored encrypted in oracle DB with some encryption key. The algo used is not available in DB2 and I want the same data in DB2. I am not able to ...
0
votes
0answers
91 views

Oracle 12c database configuration assistant failed

This is the frist time I install it on my machine and this error ocurred: I added Perl to the enviroment path but the problem is still there. This proplem appears when I configure the database ...
0
votes
0answers
25 views

PL/SQL to find Special Characters in multiple columns and tables

I am trying to come up with a script that we can use to locate any special characters that may exist in a column of data except for period, dash or underscore, and using variables. My Data - ...
1
vote
1answer
80 views

Is it possible to run Oracle 12c and AD-Server on Windows Server 2012 R2?

I have tried to install Oracle 12c Enterprise Edition on a computer also running as AD Server. Including the October 2015 patch. Operation system is Windows Server 2012 R2 A managed service account ...
1
vote
4answers
526 views

grant all privileges of all tables in database to a user

I use oracle 12c. I try to grant all privileges of all tables to a user. And in future I don't need to add any privileges to that user. I need to do this. I don't want to grant system tables to that ...
0
votes
0answers
41 views

Properly configuring Oracle Charset and NLS parameters

I'm trying to figure out the reason why Oracle SQL Developer shows question marks/rubbish on non-latin symbols. Currently I have 2 DBs on separate severs/instances, one of which works fine, and the ...
0
votes
0answers
22 views

Create connections in sqldeveloper. 12505 error

I have oracle 12c installed in my ubuntu 15.10, I can run sqlplus with sqlplus / as sysdba and run it in a CLI. But I want to be able to use it with sqldeveloper. cat ...
0
votes
1answer
25 views

Substring a result and renaming it

I wrote the below query which works just fine. The PARAM_ID has a CLC_Q<number> form. SELECT * FROM DB.TABLE WHERE PARAM_ID LIKE 'CLC_Q%' AND SUBSTR(PARAM_ID,6) BETWEEN 35 AND 45 ...
1
vote
1answer
97 views

RMAN backup of RAC database failing

Backup goes through if I don’t have any explicit connection to any instance : RUN { ALLOCATE CHANNEL ch1 TYPE DISK FORMAT '\\192.168.2.11\test\DF_CH00_%U'; ALLOCATE CHANNEL ch2 TYPE DISK FORMAT ...
1
vote
3answers
290 views

Import Database from Oracle .DBF files

Recently my Oracle Installation has been crashed and I reinstalled the Oracle again. I have my old Oracle Data files (.DBF files) which have been recovered from old installation. Now, I need to ...
0
votes
1answer
46 views

Append hint with autotrace

I'm doing a direct-path insert which executes successfully. When I try to autotrace the execution, I get the ORA-12838: cannot read/modify an object after modifying it in parallel. SQL> insert ...
0
votes
1answer
54 views

How to find current setting of “FORCE PARALLEL QUERY” in Oracle

I can change (override) the current level of parallelism in an Oracle session using e.g.: alter session force parallel query parallel 6; Is there any system view of function that will return me the ...
0
votes
1answer
233 views

Oracle 12c Installation (Grid) on RHEL 7.1 CLSRSC-214: Failed to start 'ohasd' [duplicate]

root.sh script execution failing with following error please advice ./root.sh Performing root user operation for Oracle 12c The following environment variables are set as: ORACLE_OWNER= grid ...
1
vote
0answers
54 views

SQLPlus TNS:protocol adapter error

i have two Oracle 12c instances. currently both are shutdown. when I try to connect with sqlplus / as sysdba it says tns protocol adapter error contents of tnsnames.ora are DB12102 = (DESCRIPTION = ...