The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
29 views

Importing data into Oracle 12

I got a set of files from a client which are, as far as I can tell, copies of a database in Oracle 11. Each folder has the following structure: - init<DB>.ora - orapw<DB> - arch - dbf ...
0
votes
0answers
45 views

Are there any incompatibilities between Oracle 11 and 12?

I have an application which has been validated on an Oracle 11.2 database. A client has asked me whether they can use Oracle 12c instead as that is what their IT department would prefer. Is there an ...
0
votes
0answers
22 views

How to login as common user in Oracle using Toad?

I have created a common user in Oracle and the pluggable database name is pdborcl. I am able to login as sysdba with the common userid and password but not able to login as a normal user. Can anyone ...
0
votes
1answer
48 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 ...
0
votes
0answers
23 views

Oracle 12c, exclude rows wher two columns are both null

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit I am trying to select rows with a non-null value in one of two columns. Data is being selected from a view (MY_VIEW) with both ...
1
vote
1answer
85 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: ...
0
votes
1answer
93 views

Login / Password for Oracle Enterprise Manager in VM template?

I want to setup Oracle Enterprise Manager to access our development Oracle databases. I downloaded the following VM template from https://edelivery.oracle.com/EPD/Search/handle_go Oracle VM ...
2
votes
1answer
123 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 ...
1
vote
0answers
11 views

What is a failsafe way to embed Oracle12c database with a product?

We are planning to embed Oracle12c as the default data source for our application. That means, Oracle12c and our application are going to reside on the same server. Our application runs on 64-bit ...
0
votes
0answers
30 views

how to create database(1 CDB and 2 PDB) by dbca silent mode with response file, oracle 12c

I want create a new database with 1 CDB and 2 PDB, so i write response file and use dbca tool with silent mode. But it must Manual input PDBADMIN password through terminal and only create 1 CDB and 0 ...
0
votes
0answers
41 views

What are the key points while using Oracle12c as application database

We want to use Oracle12c database as the default data store for our application. We would not be using the plugable database features ; only single instance standalone database. The database would be ...
0
votes
1answer
810 views

Linux Error: 111: Connection refused LSNRCTL

I have a problem starting my listener ,I am using Centos6.5 and Oracle12cR1. Database is been installed successfully.. Now my issue is when i start my listener ,following error are shown . ...
0
votes
0answers
637 views

[INS-30131]Initial setup required for the execution of installer validations failed. Encountering this error in Fedora 20

While I was installing Oracle 12c database on Fedora 20 I encountered this error which wasted my 2 days. "[INS-30131] Initial setup required for the execution of installer validations failed." In ...
0
votes
1answer
254 views

lsnrctl: cannot execute binary file: Exec format error [closed]

When I type lsnrctl from my command prompt the below error message is displayed: oracle@Gaurav:~$ lsnrctl bash: /u01/app/oracle/product/12.1.0/dbhome_1/bin/lsnrctl: cannot execute binary file: Exec ...
0
votes
0answers
109 views

Oracle 12C, cannot drop NOT NULL constraint on a DEFAULT ON NULL column

In windows7 I Install oracle 12 C Then I connect to database as sys user and create new user so: CREATE USER C##USER IDENTIFIED BY user_pass; GRANT ALL PRIVILEGES TO C##USER; Then I connect to ...
0
votes
1answer
47 views

Revised Question: How do I prevent Oracle 12c Database from starting on machine boot

I'd posted previously about srvctl, didn't realize it was only used if a Grid Infrastructure was installed, which in my case, is not. Anyways, I have Oracle 12c Database installed on my Windows 8.1 ...
0
votes
0answers
114 views

Oracle Database 12c and Kerberos Authentication

I have the Kerberos autentication on lunix working well but I can't configure the database to authenticate the users with Kerberos 5. I followed the official instructions on Configuring Kerberos ...
0
votes
1answer
25 views

Enterpise Manager 12c to Database 11g

Does Oracle Enterpise Manager 12c can be install with Oracle Database 11g? Because the Oracle Enterprise Manager 11g is no longer available.
0
votes
1answer
36 views

503 error while trying to access my first RESTful web service

hi, i just created a RESTful web service following this tutorial , when i try to test it i get a 503 error, i read somewhere that i have to set up the apex_listener by running the ...
1
vote
3answers
892 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: ...
0
votes
1answer
52 views

how to force oracle 12c to create histograms

I installed TPC-H on Oracle 12c and my goal is to get histograms on column groups (if anyone knows for sure that this is not possible anyway, please prove and I'll stop testing...). So I used select ...
0
votes
1answer
55 views

Defining the host on a new installation of Oracle 12c Enterprise Manager

I just started working with Oracle's products, and I downloaded the "Developer Day" VM from the following link: ...
1
vote
1answer
67 views

12c Shell to Linux

I am replacing two Oracle 11g servers with 12c TL/DR - when shelling out to a run an O.S. file, the PATH environmental variable is not being set. On the old servers we use an external library to ...
0
votes
0answers
132 views

Can't find useable blackout name

I'm trying to stop a Oracle Enterprise Manager blackout from the command-line and I can't. Is there any other way I could do that? [oracle@s:~] $ emctl status blackout Oracle Enterprise Manager ...
1
vote
2answers
145 views

Recovery from datafiles

Thanks to the recent weather/floods, we lost many of our servers. This included our central database server as well as the server that holds our backups. The database server was running Oracle 12c ...
-2
votes
1answer
508 views

Where can I download the Oracle Fusion Middleware Infrastructure Software? [closed]

I understand that since version 12c the Repository Creation Utility for Oracle Database 12c (RCU) is part of the Oracle Fusion Middleware Infrastructure Software. This brings me to the question: ...
0
votes
1answer
352 views

ORA-7445 Error on 12c

I am installing an Oracle 12.1.0.1 Enterprise Edition on RHEL 6.4 I set it up with ASMM and HugePages (64G of RAM) There may be a correlation between the errors and signing in to em express (not ...