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

learn more… | top users | synonyms

0
votes
2answers
32 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
0answers
13 views

Can redo logs contain all the transactions committed or uncommitted? [on hold]

Can redo logs of Oracle database server contain all the transactions committed or uncommitted ? thank you
0
votes
1answer
24 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
20 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
40 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 ...
0
votes
1answer
13 views

Export from Oracle 10g and import to Oracle 12c unable to create users

I have and old install of Oracle 10g with a lot of users and tablespaces in it, for development purposes. Now, I need to migrate these users, tablespaces and everything else, to an Oracle 12c ...
1
vote
0answers
13 views

How to time SPARQL queries on an Oracle12c database?

I have an Oracle 12c instance setup with an Apache Fuseki endpoint sitting on top of it. I am able to query the database using the Fuseki endpoint. I want to be able to get the execution time of some ...
1
vote
1answer
32 views

Importing Oracle12c database

i am using Oracle 12c in debian Jessie i want to import an old database exported with expdp on oracle 12c when i try to launch the commande 'impdp' i got those errors : 'ORA-39002: invalid operation' ...
0
votes
0answers
9 views

Load Multiple images (BLOBs) into the Oracle Database

I have a folder with several images. My database table is a simple table with 2 fields: name (char) and image (BLOB). How can I import my images located in my C disk (e.g.: C:\Users\me\images) into my ...
0
votes
0answers
32 views

Error ORA-12547: TNS:lost contact

I installed Oracle12c Database in my server i run SQLPLUS with the command 'sqlplus /nolog' and when i type 'conn sys /as sysdba' i got this error ORA-12547: TNS:lost contact Can you help me ...
0
votes
1answer
24 views

Record of schema related changes - Oracle

Is it possible to get the all changes that is made to schema as in what privileges was first assigned to the schema on creation, creation date, if later modified with different privilege what was that ...
0
votes
1answer
13 views

select string that doesn't contain a substring/field

TableA.content is varchar2(4000), which was populated from a CLOB value that contains markup and text for a website, paragraphs actually. TableB.keyword contains a string that I want to find in ...
0
votes
0answers
17 views

why database fill only one datafile of tablespace?

database tablespaces give error mail to me. It says TABLEINDEX haf %2 free size. But I looked, only 5.th datafile filled %85 and others are not filled (%0 or %1) all datafiles are 32 GB. I send photo. ...
0
votes
1answer
14 views

Oracle Listener.ora ignored

I have the following listener.ora file located in $ORACLE_HOME/network/admin/ : TESTSID = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = ...
0
votes
1answer
62 views

Error launching sqlplus

I try to run sqlplus on my server with the command sqlplus /as sysdba and I got this error sqlplus: error while loading shared libraries: ...
0
votes
1answer
86 views

missing files, installing Oracle DB 12c on Oracle Linux 7.2

when I try to Install the Database I get this error message: Source location is incomplete. Make sure you have downloaded and extracted all the relevant archives. I did try this twice with the same ...
0
votes
2answers
48 views

Massive deviation of tablespace max_size compared to bytes used by segments on that tablespace

I just checked the size of our tablespaces, because the admins said that they've made them bigger after we've had a full tablespace yesterday and I've discovered something really strange. I hope ...
0
votes
1answer
62 views

Connect to Oracle RAC from SQL Developer?

We have set up RAC database on server. We can connect to database from sqlplus on the server using SCAN address. However, if I try to connect to RAC using SQL developer from client machine using SCAN ...
0
votes
1answer
42 views

How to grant privileges to use DBMS_OUTPUT in Oracle?

SET SERVEROUTPUT ON, DBMS_OUTPUT work perfect in my user, System or DBA. But when i create new user, it's not work! How to grant privileges to use this?
0
votes
1answer
40 views

Can I install Oracle 12c and NOT use pluggable databases?

I've just installed Oracle 12c. I did not select any of the fancy new options, I just wanted an Oracle instance. I'm fairly new to Oracle but I was used to 11.2.0.4. Every command I try now fails ...
0
votes
0answers
61 views

TNS Time out Error ORA-12170

I am trying to connect to a remote Oracle 12c database from a client machine that has 11g oracle drivers for ODBC. I can reach to remote machine through ping but can not Telnet the remote machine on ...
1
vote
1answer
57 views

Can standby database of a physical database be pluggable or vice versa?

We are currently planning to upgrade our databases from 11g to 12c. But I have some confusions regarding 12c. Here are my questions. Can standby database of a non-container database be pluggable or ...
0
votes
2answers
56 views

Table redefinition ends with ORA-02448

I'm trying to redefine a table to be partitioned. What I did: CREATE TABLE WERTEVAR_TMP( "WVTEIL" NUMBER(10,0), "WVMERKMAL" NUMBER(5,0), "WVUNTERS" NUMBER(5,0), "WVWERTNR" ...
0
votes
1answer
49 views

Very large subpartitions after table redefinition

I'm trying to redefine a table to be partitioned. The original table has about 1.5M rows and about 150MB size. select segment_type, segment_name, bytes / 1014 / 1024 as SIZE_MB from user_segments ...
1
vote
1answer
112 views

What does node eviction mean in the Oracle RAC world?

Software environment: Oracle 12c with RAC running on RHEL The question might sound rather banal, but I wasn't able to find any word on this in the Oracle documentation I read thus far. By searching ...
1
vote
1answer
25 views

Exclude Generated Objects - SQL Developer

I am a software developer that supports and develops an application that connects to both Oracle databases and SQL Server databases. I have created a connection to a database (orcl) using the SYS ...
0
votes
1answer
33 views

How do you create a new database in SQL Developer?

I am a software developer that supports and develops an application that connects to both Oracle databases and SQL Server databases. I want to learn more about database administration. In SQL ...
1
vote
0answers
58 views

Configure Oracle database (first time user)

I am trying to learn how to use Oracle Database. I downloaded the Standard Edition version 12c from here: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html. I ...
4
votes
1answer
79 views

Is Oracle 12g free to download for learning purposes? [closed]

I am a software developer that supports and develops an application that connects to both Oracle databases and SQL Server databases. I want to learn more about database administration. Therefore I ...
0
votes
0answers
46 views

Fetching user info from many databases at one go

I have a requirement to fetch all the schema available in 100+ Oracle instances running in RHEL environment. All the schema information such as username, roles assigned and is to be dumped in one ...
1
vote
1answer
50 views

Should we consider “sqlplus” as an Oracle client?

I am a newbie of SQL*Plus and Oracle, and I have 2 questions about them. (1) Executing "sqlplus / as sysdba" command: $ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Thu Feb 18 ...
1
vote
1answer
53 views

Increase logging/tracing on Oracle 12c database

I need to connect TLS-secured-ly to an Oracle 12c (from some random Java program, using JDBC connection) I set up my listener to use TCPS, I made my wallet and everything and still my program is ...
1
vote
1answer
36 views

Are db_recovery_file_dest and db_recovery_file_dest_size parameter dynamic or static?

Please have a look at the output below: As I know we can check if the parameter is static or dynamic in Oracle using this query. Please correct me if I am wrong. But I have seen something ...
0
votes
2answers
46 views

Ignore white spaces for comparison in unique constraints of Oracle

How can I tell to Oracle DBMS to ignore white spaces while comparing varchar values for Unique Constraints. It means that NAME 1 is exists in a table column with Unique Key, inserting NAME1, causes ...
2
votes
1answer
405 views

understanding ORA-01792 maximum number of columns in a table or view is 1000

We've recently migrated a server from Oracle 11 to Oracle 12c and ran into a few annoying issues. One of them is that a few a reports give the following error: ORA-01792: maximum number of columns ...
0
votes
1answer
99 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
48 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
33 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
85 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
21 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
78 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
21 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
33 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
55 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
54 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
60 views

Change IP of nodes in Oracle RAC

I have a two node RAC database running in OEL 7 server. If there is a need to change the IP addresses of the already running server to a new one, will that hamper the functioning of the database? ...
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 ...
2
votes
1answer
51 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
118 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
48 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 ...