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

learn more… | top users | synonyms

1
vote
0answers
13 views

How to Move a whole partition to another tabel on another database?

Database: Oracle 12c I want to take single partition, or a set of partitions, disconnect it from a Table, or set of tables on DB1 and move it to another table on another database. I would like to ...
-1
votes
1answer
23 views

Select catalog role - Oracle

Does select_catalog_role if granted to a schema provide access only to dba tables and v$ views only and not to other schemas created for any application? The reason i'm asking this is I need to grant ...
-1
votes
1answer
23 views

how to drop oracle 12c instance on linux

I have created an Oracle 12c container db instance. I need to drop the instance. What's the most effective way to drop instance?
0
votes
1answer
21 views

RMAN Control File Information

I have daily full backups going on for my Oracle 12c databases on linux. Daily retention on disk is 6 days. This is what happens: Full backup happens at location /orcl_bkup/backup_full After ...
0
votes
0answers
21 views

Oracle Report 12.2.1.1.0 Configure Issue

I installed Oracle 12c and Oracle frm 12.2.1.1.0 on my laptop(w10/64bit) properly and Oracle form server and form are run properly. But unfortunatly the report builder doesnt work properly. Report ...
2
votes
1answer
26 views

Can I restore a table with flashback database even if I used “drop table purge”?

If I issue the following statement: drop table DontDrop purge; It's going to be flushed out of my recycle bin so flashback statement won't work: select * from DontDrop as of timestamp to_timestamp(...
-1
votes
0answers
33 views

How do I install Oracle12c and then connect through SQL Developer? [closed]

I am having trouble installing Oracle12c and then establishing a connection. I have downloaded both files from Oracle's website for windows x64. I have read through the Oracle documentation on their ...
0
votes
0answers
35 views

Unable to create new database in 12c RAC Mode with DBCA

I am new to DBA and currently trying to implement Oracle RAC cluster according to article -> RAC Deployment on AWS. I want to create a database which is non-CDB type on this architecture, although it ...
0
votes
1answer
20 views

Why can't I establish a connection to the local oracle database from within the pre-built oracle virtual machine?

I downloaded DeveloperDaysVM2016-06-02_13.ova from http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html and successfully loaded it into Virtual Box. I logged ...
0
votes
1answer
36 views

Failure to parse data returned by server

i login oracle database 12c with sys user with sysdba privileges.But in user section when i want to show the properties of other users by double clicking it, it shows the following error- 'Failure to ...
0
votes
1answer
44 views

What is the default username and password to the oracle pre-built virtual machine?

I downloaded DeveloperDaysVM2016-06-02_13.ova from http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html and successfully loaded it into Virtual Box. I logged ...
0
votes
2answers
39 views

Grant permissions to a user to grant select to specific tables in several schemas in Oracle

I administer a small datawarehouse in Oracle. My user dwhmanager was given the SELECT ANY TABLE privilege: GRANT SELECT ANY TABLE TO dwhmanager WITH ADMIN OPTION; The idea was to have the ability to ...
0
votes
0answers
30 views

OraOLEDB.Oracle not showing up in Providers in Linked Server

Im trying to link the Oracle database to our SQL Server database. However OraOLEDB.Oracle is not in the Providers list on the Linked Servers. I have installed Oracle Database Client (12.1.0.2.0) for ...
2
votes
1answer
175 views

ORA-01017: invalid username/password;logon denied

There were other similar questions asked, but none that were able to tell me why I can't connect using a C# .NET web site I've stood up. While I know this forum is more for DBAs connecting to ...
1
vote
1answer
31 views

Setting parameters like PCTUSED when creating new tables in ORACLE 12 C

When creating new tables in ORACLE 12 C, do we need to explicitly set parameters like PCTUSED, PCTFREE, INITRANS, MAXTRANS, STORAGE etc. (as shown in example below)? Or will ORACLE automatically set ...
1
vote
1answer
40 views

Why all users excep sys and system can connect to oracle db after database deletion on multi database environment?

I have 2 database on one server. I can connect to the database with normal users but cannot connect with sys and system users and invalid username/password occurs. before that I dropped one of the ...
-1
votes
1answer
45 views

Golden Gate Privilege Missing for using Encryption

dblogin userid ogg_user, password AADAAAAAAAAAAAIAKAQIJAGAMFUFKFBGQHXBJIWGECTEIAZHJFYALFFIBGHGJBPFBCPBKEPCRCRHAESJ, AES128, encryptkey securekey1 ERROR: Unable to connect to database using user ...
0
votes
1answer
46 views

Argument out of range error

I have this query: WITH I1 AS ( SELECT * FROM XYZ A WHERE UPPER(A.DES) LIKE '%%' ESCAPE '\' --' AND NVL(A.END_DATE, TO_DATE('9999-12-31', 'YYYY-MM-DD')) >= ...
1
vote
0answers
60 views

cannot connect to oracle database in dbeaver

I created an oracle database in my local device, and i want to connect it using DBeaver but i have the oracle driver installed correctly as you can see: and when i try to connect my database i get ...
0
votes
0answers
40 views

Install Oracle Instant Client components from Custom option

Installing the Oracle DataBase Instant Client 12c, 4 options are displayed: Instant Client - This installation type installs only the shared libraries required by Oracle Call Interface applications ...
0
votes
1answer
17 views

Oracle SQL: Why are column headers missing?

I want to understand why my columns are missing their headers. Consider this table: SQL> DESC customer; Name Null? Type ------------ -------- ------------ CUST_ID NOT ...
0
votes
0answers
41 views

Archive and Logging issues in oracle 12c

When I want to enable archive log on oracle till 11g i used alter database add supplemental log data(Primary key,unique) columns In 12c I can run the same on the PDB or on the core. I need the ...
0
votes
1answer
120 views

How to connect to oracle 12c from sqlplus without password in command line

This may seem as weird question: If i have user called demo with password Pass1234 When connecting to oracle 11g I can run sqlplus like this with password in command line: on DB host: C:\> ...
0
votes
1answer
20 views

Change date precision values

Exposition: I have an oracle database table with date format as 'mm/dd/yyyy' and an unique constraint that contains the date column. My issue is that I can't seem to find a method to change the ...
0
votes
1answer
117 views

Error installing Oracle Database Client 12c: “OracleMTSRecoveryService Control Utility has stopped working”

The installation of the "Oracle Services For Microsoft Transaction Server" component fails when I attempt to install Oracle Database Client 12c (12.1.0.2.0) on Windows Server 2012 R2. When ...
0
votes
1answer
120 views

How to configure sql developer with oracle 12c?

I'm trying to connect sql developer to a fresh installation of oracle: I can connect to sys user via sqlplus I can connect to sys user via sql developer when I select Connection Type "Local\Bequeath"....
0
votes
1answer
46 views

Mixed mode auditing - 12c

Oracle 12c database comes with default Unified auditing enabled even if we set it to FALSE which has ORA_SECURECONFIG policy enabled by default. Apparently, the audit options for that particular ...
1
vote
2answers
90 views

expdp full export not exporting all schemas

On Oracle 12c, fairly new database with APEX installed. I do a expdp \"/ as sysdba\" directory=dp_dir full=y dumpfile=full.dmp logfile=full.log And I am getting just a few tables from SYS and ...
0
votes
0answers
45 views

Oracle 12c cannot start up after having failed to enable Extended Data Types

I upgraded my single instance oracle to 12c on CentOS 6.7 for the benefit of having 32767 bytes varchar2 and I followed below nice article until stopped half way when executing utl32k.sql script. ...
2
votes
2answers
97 views

RMAN DUPLICATE from backup without Target or Catalog: How is the aux instance created?

I am trying to duplicate an Oracle database based on backups to test if they can be used in case of complete system failure. Hence, I want to do this without a connection to the source database. I'm ...
3
votes
2answers
62 views

Golden Gate realtime replication basic question

I have a task to replicate unidirectional real time data from source database A to target database B. I do not need all the table from A, only few tables and few columns inside those tables. Say 10 ...
1
vote
1answer
33 views

Security and Performance Implications of SQL Tuning Advisor

I work on a relatively small development team that works with an Oracle (11g) database. It's recently been requested that all the developers be given the Advisor role so that we can utilize SQL Tuning ...
3
votes
1answer
91 views

Oracle 12c Rman Duplicate Archive Log Not Verified

I am trying to duplicate a DB from live to dev but it is failing. Can anybody advise what is going wrong? Both databases are running Oracle 12c. All database files seem to be copied over but it fails ...
0
votes
3answers
89 views

Get current time, on commit, with oracle database

When inserting a row I want to make a column, equal to the current time on commit. If I use default value sysdatetime on the column, it uses the current time at insert (which could be significantly ...
0
votes
2answers
54 views

Oracle ASM : Alter asm_diskstring when ASM Instance is Down,

I am beginner for Oracle ASM I know we can alter asm_diskstring with following ways SqlPlus ASMCA but these requires +ASM to be UP and running. Is there way to set asm_diskstring when +ASM ...
1
vote
0answers
57 views

ORA-00604 (error occurred at recursive SQL level string) hides the real error

My multithreaded program inserts records into a table. ORA-00001 (unique constraint violated) should not be fatal. But prod environment has a complex configuration with read-only schema and the table ...
1
vote
0answers
64 views

Getting email notification when jobs are created under user_schema rather than sys?

I log in as sys and set the smtp for scheduler: BEGIN DBMS_SCHEDULER.set_scheduler_attribute('email_server', '10.1.1.15'); DBMS_SCHEDULER.set_scheduler_attribute('email_sender', 'user@compny.com')...
0
votes
0answers
22 views

error while creating user with a default tablespace

I am new to Oracle 12 and I don't know how to work with Container Databases (CDB) and Pluggable Databases (PDB). In Oracle Database 12c I created a database with the dbca and I created a tablespace ...
-1
votes
1answer
64 views

Does SQL Server 2014 have a feature like Oracle Multitenant databases?

In Oracle 12c, a feature called Multitenant databases is available. This way you can have two seemingly separate databases installed on one system, yet be able to manage Backups and Resource ...
1
vote
1answer
47 views

What database name should I use to connect Tomcat with my database

I have a dump file in Oracle and I should use Oracle 12c. I installed it, created a database and imported the dump into a tablespace, but I can't connect it with my application on Tomcat. I'm lost ...
2
votes
1answer
52 views

Getting ORA-01017: invalid username/password in non-CDB database

I have installed Oracle 12c (software only in Linux) and created a non-CDB database (single tenant) database. Following is my listener.ora. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (...
0
votes
2answers
55 views

ORACLE12 - Connect Via SqlPlus

I have a local installation of Oracle Before i can connect directly via SqlPlus but now when i try to connect i have this error : ERROR: ORA-01034: ORACLE not available ORA-27101: shared ...
0
votes
0answers
280 views

FATAL INS-32012 Unable to create directory - Oracle 12c client installation

I am installing oracle client as Administrator in my Linux machine as a silent mode, I faced issue like this [FATAL] [INS-32012] Unable to create directory: /u01/app/12.1.0.2/admclient64. I don't ...
0
votes
2answers
102 views

Query against history table not using index (Oracle 12c)

I have a history table which has an 'ID' and 'TIMESTAMP' column as such CREATE TABLE hist ( HIST_ID INTEGER, HIST_TIMESTAMP TIMESTAMP, ID INTEGER, -- this is the id of the table that is being ...
4
votes
1answer
34 views

Oracle SQL 12c How to correctly use compound foreign keys in compound primary keys?

DISCLAIMER: I am a student. I do not work for an airline. I do not pretend to be a professional programmer. Greetings, I want understand what I need to correct in order for these tables to work ...
1
vote
2answers
73 views

Sanity Test on Oracle Upgrade Database

My oracle sever has been upgraded from Oracle 10g to 12c. DBA has created a box for that now my question is how developers will perform testing on that.. Can anyone provide me the sanity or unit ...
0
votes
2answers
201 views

Unable to open database (Datafile corrupted)

I am unable to open the database, but i am able to mount it. When i try to open the database, getting following error ORA-03113 - end-of-file on communication channel I am using Oracle 12C. On ...
0
votes
1answer
27 views

What system privilege is needed for a user to manage user accounts only

I'm looking to delegate user termination to our NOC. Requirements are: A user NOC will be created User NOC will execute stored procedures allowing them to either 1) lock another db account or 2) ...
0
votes
0answers
24 views

Can I delete an Oracle “Whole database backup” while a level 0 backup is being created?

I have created a Whole database backup using: -- In SQL*Plus ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 5000G SCOPE=BOTH; ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = 'O:\ORA_FRA'; alter system set ...
0
votes
2answers
59 views

Why is a Full Database Backup (as opposed to a level 0 backup) required in Oracle after switching to ARCHIVELOG mode?

The Oracle 12c 2 Day DBA manual states: While whole database backups can be an important element in your overall backup strategy, they are also a required step in some situations, such as when ...