The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
44 views

Duplicate data in a table given table name

For a performance testing application we need to have lot more data in our tables than what we have now. How do I duplicate the data in a table. In the process of duplicating I also need to set new ...
0
votes
0answers
9 views

Oracle In-Memory POPULATE_STATUS does not change to completed

I'm experimenting with the Oracle In-memory options for BI purposes, when I'm trying to populate one table to in-memory in the v$im_segments the POPULATE_STATUS does not change to completed, for other ...
0
votes
0answers
34 views

Connecting to Oracle database installed in one machine using Toad from another machine

I've an Oracle 12c installed in one machine in the LAN, and am able to access this database from the other machines in the LAN by the java applications using the jdbc thin driver connection ...
0
votes
1answer
37 views

dbca cant remove database cleanly

when I ran dbca as administrator under windows server 2008R2 is used to delete the database completely ( database folder, control files, datafies, redo logs, then remove all related windows services ...
0
votes
0answers
25 views

Email Column Constraint to Contain '@' character

How do you create an inline constraint for a Email Address Field that requires there be an "@" character? Pretty much I want there to be a restriction to the field so that the data entered must have ...
0
votes
2answers
158 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 ...
6
votes
1answer
159 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 ...
0
votes
3answers
140 views

How to tell from the OS whether Oracle instance is a standby, assuming no DB access?

One can easily check via SELECT database_role FROM v$database; whether your Oracle database is a primary or standby database. Is it possible to make the same determination without database access, ...
0
votes
1answer
144 views

Oracle 12c, can not chose standard edition when install!

i'm trying to install Oracle 12c on Windows 2012 R2 ... I get Enterprise Edition option only! I need to install Standard Edition!
0
votes
0answers
29 views

flashback recovery in RAC enviorment using Data Guard Broker (oracle 12c)

I am trying to flashback recover using DGMGRL from the current primary node. I am running the following command at current primary: dgmgrl> reinstate database pri but I am getting the error ...
0
votes
1answer
55 views

XMLTABLE solution without getting right parenthesis missing error

I am trying to select from an XML type and produce multiple rows. Have searched for my specific scenario/issue with not much success. Environment: Oracle 12c. I have commented out the offending code. ...
0
votes
0answers
67 views

Cant create a normal non-common user name for oracle 12c getting ORA-65096: invalid common user or role name error

I am trying to create a normal user for my oracle 12c database, but it wont let me create one that is not a common username. I have tried executing : CREATE USER TESTUSER IDENTIFIED BY "blah blah ...
0
votes
0answers
29 views

Cant login to DataBase migration assistant in oracle 12c while i can easily connect in sqlplus

I need to change the character set of my database( I have no idea how it got created with that character set in first place! would be nice to know as well). I searched and found out that i need to use ...
0
votes
2answers
80 views

How to detect in which schema a procedure is called?

I'm struggling with a problem in Oracle 12.1 regarding to procedures. We are using a data isolation approach based on schemas. We use one schema as PUBLIC and each project has exactly the same ...
0
votes
1answer
311 views

Toad for Oracle 64-bit : 1603 - Fatal error during installation

I'm trying to install Toad for oracle client, my Toad version is 12.1 for 64 bit system, i have succeeded to install oracle client 12c for 64 bit system, but i have stumbled by a problem when ...
0
votes
0answers
119 views

ORA 7445: Query causes Oracle 12 to crash

I'm currently testing my application on Oracle 12 after all tests passed OK on Oracle 11. During testing the application kept losing the connection to Oracle when running a certain query. Here is a ...
0
votes
0answers
494 views

ora-12705 cannot access NLS data files or invalid environment specified

I have i'm installing oracle in machine 12c, while installing everything goes smoothly but when it reach to database creation it passes two step. cleaning up failed stat copying database file ...
1
vote
1answer
62 views

Password of the oracle user in oracle linux?

I am trying to install oracle 12c on my virtualbox oracle linux 6.5. I ran the command oracle-rdbms-server-12cR1-preinstall , which created a user oracle . But I can't seem to login to the user cause ...
1
vote
0answers
115 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 ...
1
vote
0answers
41 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
74 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
81 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
827 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
122 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
2k 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
447 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 ...
3
votes
1answer
568 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
42 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
150 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
47 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
2answers
5k 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
3k 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
461 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
412 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
102 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
333 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
26 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
54 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
4answers
5k 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
111 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
89 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
85 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 ...
1
vote
2answers
170 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
915 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
479 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 ...