Questions tagged [oracle-12c]

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

Filter by
Sorted by
Tagged with
13
votes
5answers
52k 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 ...
12
votes
3answers
71k 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 ...
12
votes
1answer
915 views

How can I prevent UNPIVOT from being transformed into UNION ALL?

I have a somewhat complex Oracle query which is taking about half an hour to complete. If I take the slow part of the query and run it separately it finishes in a few seconds. Here's is a screenshot ...
10
votes
6answers
82k views

Oracle 12c create user

I have some problem with creating user in Enterprise Oracle Database System. A could'n create user using command like create user name identified by password; because of exception: ORA-65096: ...
8
votes
3answers
17k views

Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS

Background I am attempting to install Oracle 12c on CentOS 7 (deployed as a Hyper-V virtual machine) as outlined by this installation guide. Problem Everything with my installation goes well except ...
8
votes
2answers
17k views

How do I limit Oracle's memory use?

I would like to use Oracle's automatic memory management, with a limit of around 4GB. (Past experience has shown this to be plenty for my dev PC and that it is easier to get an idea about any ...
8
votes
1answer
30k views

Using Oracle12C Client with Oracle11.g database

I have been using Oracle12c client to connect to an Oracle11g database in a remote server for about one month, it wasn't giving me any problems until this week, when I started getting the error: ...
7
votes
4answers
34k views

Oracle shrinking / reclaiming free tablespace space

I have a Oracle 12c tablespace with the size of 90GB. Almost 40GB are free. TB1 54 % 90880 41383 49497 46 98304 50 % ONLINE PERMANENT The tablespace has 3 datafiles. E:\ORACLE\...
7
votes
2answers
4k views

Outer Join suppressing Index usage?

I have a client program that is executing a query against a View that outer joins one table to another. The performance is bad and I have been trying to tune it by adding the right index. The query ...
6
votes
2answers
33k 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 ...
6
votes
1answer
2k views

How to tune the query on all_constraints in Oracle 12c?

How to tune the following query, as it's taking around 8 seconds: select constraint_name,table_name from all_constraints where r_constraint_name in ...
6
votes
1answer
33k views

How to backup an Oracle database from SQL Developer

New to Oracle, usually work with SQL Server. Is there an easy way to backup an Oracle database from SQL Developer. I've read these links Database Backup and Recovery User's Guide and RMAN and it's a ...
6
votes
1answer
24k views

Get the DDL for all indexes - Oracle

I have about 5 schemas in my oracle 12c database for which I need the DDL for all the indexes for each of the schemas. DDL I have checked it on how to get the code from it, but for all the indexes and ...
6
votes
1answer
5k views

ARCHIVELOG in Oracle 12c multitenant PDB

In a Oracle 12c multitenant DB instance with multiple PDBs, is it possible to enable ARCHIVELOG mode on a single PDB?
6
votes
3answers
26k views

How to replace and overwrite all existing objects in Oracle with impdp for full database import?

I want to replace all the existing objects in my database, not just tables, into my current database. I ran expdp with the parameter full=yes as the system user, who I granted ...
6
votes
1answer
4k views

Current state of INTEGER vs NUMBER in Oracle

I am using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production and I am trying to decide on using INTEGER or NUMBER for a whole number field that will hold a LONG from Java. ...
6
votes
1answer
14k views

Oracle 12c SYSTEM user locked out

We have a development Oracle 12c database and the SYSTEM user account is locked out for one of the SID's (works fine with another SID). When I try to do a conn SID / as sysdba it keeps connecting me ...
6
votes
1answer
3k views

Recover from corrupted REDO files in oracle 12c when DB engine fails to start

I have an Oracle 12.0.1.2.0 (Enterprise package) installation on my Windows 7 development machine. After an unexpected power failure, the Oracle engine fails to start: Consequently, I am unable to ...
6
votes
1answer
2k views

What are the Oracle Dataguard Implications of Migrating to a PDB?

If I have an OLTP database with two physical standby instances (one remote) what are the implications of migrating the primary DB to being an Oracle 12c PDB? i.e. Does the process of migrating to ...
5
votes
4answers
603 views

Interpolate dates along a line

I have a road_condition table in Oracle 12c: create table road_condition ( cond_id number(5,0), road_id number(5,0), cond_date date, condition number(5,0) ); insert into ...
5
votes
1answer
40k 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:\> ...
5
votes
2answers
3k 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 ...
5
votes
2answers
303 views

Oracle does not use transitive closure to add additional predicate

Presented with a query like this: select * from a, b where a.val = b.val and a.val = 1 Oracle optimizer can use transitive closure property and combine two predicates a.val = b.val and a.val = 1 to ...
5
votes
4answers
219 views

Can this query be simplified? Calculate cumulative length of segments and collapse coordinates into linestring

I have a road_vertices table: create table road_vertices ( road_id number, vertex_index number, x number, y number ); insert into road_vertices values ('100',1,0,5); insert into road_vertices values ...
5
votes
4answers
73k 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 ...
5
votes
2answers
23k 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 ...
5
votes
3answers
4k views

How many control files should I have?

On the Oracle Database Appliance, the default deployment only gives you a single control file. I find this a little puzzling. The single control file causes a policy violation in the automatically ...
5
votes
1answer
5k 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 ...
5
votes
2answers
14k views

2 Different Oracle DB Version on same server

Is it possible to install and run 2 different oracle version(11g and 12c)software and db on same server? is it possible then how we can? and if not then why? Thanks Rahul Joshi
5
votes
1answer
3k views

Oracle TimesTen vs Oracle database in-memory

Oracle has recently announced its latest Oracle database in-memory feature in 12c. Oracle already had an in-memory database TimesTen and now I was wondering as to what the the differences between ...
5
votes
1answer
1k views

Same table alias for two different tables (Oracle)

This example has the same table alias used for two different tables. I don't understand why this is allowed by Oracle, and if allowed, how the results make any sense. create table Table_A (x number);...
5
votes
1answer
1k views

Group values: CASE text, ELSE field value

I have a ROAD table: +----+------------+ | ID | ROAD_CLASS | +----+------------+ | 1 | ARTERIAL A | | 2 | ARTERIAL B | | 3 | ARTERIAL B | | 4 | ARTERIAL C | | 5 | ARTERIAL C | | 6 | ARTERIAL C |...
5
votes
1answer
1k views

'ORA-00059: maximum number of files exceeded' on Oracle 12c

I have a test database. Every night a script drops and recreates a number of pluggable databases that are used for our automated test runs. Recently, I have started getting 'ORA-00059: maximum ...
4
votes
2answers
3k views

Query with ROWNUM returns differents rows on every execution

I have a query that is used to search for a list of sub divisions in our network. When the query is executed without any filter, it returns a different amount of rows on every execution SELECT ...
4
votes
3answers
67 views

How can I pass on a value in the hierarchy based on the value of the parent using an hierarchial query?

I have a table with categories and another table with a discount for categories per user: create table category ( id NUMBER NOT NULL, parent_id NUMBER, name nvarchar2(255), PRIMARY KEY( id) )...
4
votes
2answers
91 views

Construction events: Get the condition from the previous inspection

I have a constr_events table: create table constr_events ( event_id number(4) not null unique, road_id number(4) not null, constr_date date not null, reset_condition number(9,2)...
4
votes
2answers
2k views

Bloom Filter about filtering in oracle

I read a great blog about bloom filter in Oracle, and I have a few questions about the Bloom filter use case - Filtering in this blog. SQL> CREATE TABLE DIMENSION ( col1, ...
4
votes
1answer
2k 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 ...
4
votes
3answers
26k views

Oracle 12c client installer error

I'm trying to install Oracle client 12.1.0.2.0 (32-bit) on a completely clean copy of windows Server 2012, and I'm hitting a problem. The installer runs fine until it gets to the final part - the net ...
4
votes
1answer
68 views

Oracle analytic functions - how to get the highest RANKing row?

Test data: create table test ( grp varchar2(16) , mbr varchar2(16) , reading1 number , reading2 number ); -- group A: 3 members, 1 duplicate set -- group B: 2 members, 1 duplicate, one reading ...
4
votes
1answer
3k views

Fill in the gaps between rows using the previous row's values

I have a road_insp table: create table road_insp ( insp_id int, road_id int, insp_date date, condition number(38,2) ) ; insert into road_insp (insp_id, road_id, insp_date, ...
4
votes
1answer
3k views

Oracle error ORA-65052: statement involves operations with different container scope

I'm a relative newb to Oracle. I have set up an instance of Oracle 12c running on a RHEL 7 VM. I am connecting to the database created during installation through and running some installation scripts....
4
votes
1answer
761 views

Oracle RMAN - MAXPIECESIZE ignored for Level 0 backups

I'm having issues with Oracle 12.1 rman - specifically the MAXPIECESIZE parameter not being honored by my Level 0 backups. This value is set in rman as CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/...
4
votes
1answer
6k views

How to get Page Name given Page ID in Oracle Application Express

Prefix: I have looked all over the net for this answer. Let me prefix the question by describing what I am trying to do: I am trying to create a unique list of shortcuts to pages in my application for ...
4
votes
1answer
5k views

How do I use RMAN to create a test database from a full recovery backup dataset?

In plain english for a someone whose DBA role is a third or seventh hat, and rarely has to touch Oracle, how do I use RMAN to create a test database from a full recovery backup dataset? I've kept my ...
4
votes
3answers
18k 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 ...
4
votes
2answers
832 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 ...
4
votes
2answers
1k views

How to install olaptrain sample schema on oracle 12c?

I need to install the sample schema available from the Oracle website: http://download.oracle.com/otndocs/products/warehouse/olap/olaptrain_install.zip I am trying to run the commands as given here: ...
4
votes
0answers
298 views

RMAN-06169, but only when backing up via OEM 13c

When running a Level 1 or Level 0 backup via OEM 13c, the following RMAN error causes the run to fail. (The RMAN script is being ran with proper sysdba credentials from OEM 13c.) RMAN-06169: could ...
4
votes
1answer
7k views

Unable to open/connect to Oracle 12c Enterprise Manager Express [duplicate]

I have a just installed a new single instance installation of Oracle 12c (12.1.0.2.0 on Windows x64) with ASM. The database itself is working OK (can be accessed locally and remotely via port 1521), ...

1
2 3 4 5
18