The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
36 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 ...
0
votes
1answer
28 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. ...
0
votes
0answers
7 views

Creating objects containing collections of themselves

I'm creating a simple data structure using PL/SQL to help me work with some rows in tables which have dependencies upon each other. In short, I'd like to be able to create a graph using any ...
1
vote
0answers
16 views

Oracle 12c database cannot log in as a local user

I met a problem from Oracle 12C Database, when I try to login to the user account with commandconn test/test, I got prompt of "invalid username/password, logon denied". when I use conn ...
1
vote
1answer
45 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
0
votes
0answers
55 views

Oracle RAC takes forever dropping tables

We are seeing table drops consistently take tens of seconds on our Oracle 12c RAC. It appears to be spending on its time on reliable message waits. Which I think means that it asks the other node to ...
0
votes
1answer
37 views

How to create oracle user for more than one version

I have server under RHEL 6.3 installed on that server Oracle 11gr2 and 12c, I want to create user lets say Ahmad but I want this user to be sysdba on both servers, for single server I edit ...
-3
votes
1answer
43 views

How to install Oracle DB 12c on Solaris 11.2? [closed]

I downloaded file 1 and file 2 and extracted it in one folder called ORCLDB. When I run ./runInstall as root from terminal it says The user is root. Oracle universal installer cannot continue if the ...
0
votes
0answers
48 views

sql taking < 1 sec to run in sql developer, 37 on the application side

As the title says, we have a big discrepency between a sql query we're running from our java application (jdbc thin client) and the same query run in sql developer. I clear the cache of the query ...
0
votes
2answers
62 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
23 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
85 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
145 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
40 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
635 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
280 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
342 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
433 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
44 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
109 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
102 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
36 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
121 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
472 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
172 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
525 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
80 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
145 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
43 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
89 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
89 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
2k 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
249 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
3k 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
617 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
761 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
53 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
1answer
203 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 ...
1
vote
1answer
8k 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
534 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
502 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
143 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
1answer
27 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
70 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 ...
2
votes
4answers
8k 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
147 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
96 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
88 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 ...