Questions tagged [oracle-12c]

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

Filter by
Sorted by
Tagged with
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), ...
2
votes
2answers
9k views

“Unable to display page” with Oracle 12c Enterprise Manager Database Express

i'm using redhat 6, installed 12.1.0.2 of oracle and created a database. database (dev12ee1) is a non-container database, there is also an 11g database on the server (dev11ee1) lsnrctl status shows ...
2
votes
2answers
918 views

Trigger to get next prefixed ID: Is there a better way?

I have a projects table: +------------+-----+ | PROJECT_ID | ... | +------------+-----+ | LC000001 | | | LC000002 | | | LC000003 | | | LC000004 | | | LC000005 | | +------...
1
vote
3answers
9k views

Oracle 12c Express Enterprise Manager on Centos 6.5 is not reachable

I have Centos 6.5, and installed Oracle 12c. As dbca utility says after configuring new db, EM Express should be available on https://hostname:5500/em In fact, it is not. Neither on localhost nor by ...
2
votes
1answer
3k views

Step by step establish a connection between SQL Server 2014 and Oracle 12c

I have two servers (both servers are on Windows OS): Server_A running Oracle 12c Server_B running SQL Server 2014 I want these servers to be able to see each other, so I can SELECT anything I want ...
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 ...
2
votes
3answers
2k views

Why are my backups using so much space? ORA-19804

I had a backup job that was failing like this: RMAN-03002: failure of backup plus archivelog command at 10/20/2016 01:16:23 ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim ...
2
votes
2answers
159 views

Tuning Java Pool after getting ORA-04031

I'm running Oracle 12.2.0.1 Standard edition on Windows 2012 RC2. I'm NOT running Oracle's Automatic Memory Management. We are seeing these in the alert log: ORA-04031: unable to allocate 4096 ...
1
vote
2answers
860 views

Granting access only to standby database

One of the physical standby databases in my environment is open in read-only mode and used for reporting purposes . I want to give users access only to this particular standby, not to primary db. ...
1
vote
2answers
636 views

How to connect to root with Oracle Developer VM

I have the Oracle Database App Development VM (12c) and am trying to create a new container. Specifically: conn / as sysdba create pluggable database pdborcl admin user system identified by oracle ...
5
votes
4answers
218 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 ...
1
vote
1answer
149 views

Rotate table for year-over-year comparison

I have a road_insp table: create table road_insp ( insp_id int, road_id int, insp_year int, condition number(10,2) ); insert into road_insp (insp_id, road_id, insp_year, condition) ...
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
4answers
600 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 ...
3
votes
2answers
496 views

Select most recent inspection

I have a ROAD_INSPECTION table: +----+------------------------+-----------+ | ID | DATE | CONDITION | +----+------------------------+-----------+ | 1 | 01/01/2009 | ...
3
votes
1answer
74 views

Select most recent inspection, break tie between inspections from same year

I have a road_insp table: create table road_insp ( insp_id int, road_id int, insp_date date, length number(10,2) ); insert into user.road_insp (insp_id, road_id, insp_date, length) ...
2
votes
3answers
597 views

Pivot, categorize and group by

This question is similar, yet different, to another DBA SE question I have here: Group by NAME and YEAR, categorize NAME I have a FINANCE_SOURCE table: +-----------+------------+-------------+-------...
2
votes
1answer
3k views

Allow remote access to Oracle 12c

After finishing the installation of Oracle 12c on Centos 7, now I try to allow access on my PC (via SQL Developer) to the server. The problem is that when I do: lsnrctl status I get this error: TNS-...
2
votes
1answer
56 views

Group by NAME and YEAR, categorize NAME [duplicate]

I have a FINANCE_SOURCE table (I think it might be called a vertical table): +-----------+------------+-------------+--------+------+ | SOURCE_ID | PROJECT_ID | SOURCE_NAME | AMOUNT | YEAR | +--------...
1
vote
1answer
1k views

Startup oracle database 12c manually with SQL*Plus command not when OS loads

I changed oracle instance to manually start from services.msc (service name is "OracleServiceORCL"), Because I want to start it up manually with SQL*Plus commands whenever I want, not with OS load. ...
1
vote
5answers
3k views

Duplicate Oracle Database from Windows to Linux

I have a regular Oracle 12c database already created, named ECLS. I've been given a pile of .BKP files, not from this database, and have been told to replace everything in ECLS with the contents of ...
1
vote
1answer
313 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 ...
1
vote
3answers
8k 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
1answer
9k 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
2answers
335 views

Select strings with line breaks

How can I select strings that have line breaks in them? I can think of these possibilities when it comes to line breaks in strings: create table test1 ( id number(4,0), f1 varchar(25)); ...
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 ...
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
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 ...
3
votes
4answers
2k views

Upgrade scenario: Oracle 8.0.5.0.0 to Oracle 12c?

we have a very old Oracle 8.0.5.0.0 database here that - unfortunately - is still used heavily as every day production system. I want to start making plans on how to get this DB upgrade to a recent ...
1
vote
4answers
9k views

Unable to check whether the location specified is on CFS

I have googled this error message and it says: INS-30014: Unable to check whether the location specified is on CFS Cause: The location specified might not have the required permissions. Action:...
1
vote
1answer
38k views

Linux Error: 111: Connection refused LSNRCTL

I have a problem starting my listener, I am using Centos 6.5 and Oracle 12cR1. Database has been installed successfully. Now my issue is when I start my listener, the following error is shown: ...
1
vote
1answer
76 views

How to point tablespace in Oracle's pre-built Developer Day VM to another mount point

I have downloaded and started up Oracle's pre-built OTN Developer Day VM. The VM is running on an SSD. I want to load some data for development purposes. I am planning to create a new user and load ...
-1
votes
1answer
329 views

Extract values from oracle pl sql cursor

I have a function that returns a cursor. When I execute select t.id, t.f_rc(id) from my_table t I get id F_RC(TID) 1 < cursor > 2 < cursor > 3 < cursor > ... How to expand ...