Questions tagged [oracle-12c]
Oracle Database 12c. Please also tag oracle for search purposes.
0
votes
0answers
7 views
ora-49204: recursive dde invocation at phase i - after switchover to standby
I am currently testing a data guard environment. After a switchover, which is performed successfully, I can see the following error in the alert.log of the new stand:
ora-49204: recursive dde ...
0
votes
0answers
9 views
Operation CTL_BOOTSTRAP canceled during phase 0, error = ORA-408
I am currently testing a data guard environment.
In the alert.log of the broker I always see the following message after a switchover:
2019-05-23 08:08:54.716 7fffffff 0 Operation ...
0
votes
1answer
26 views
How to determine/set the Java classpath for an Oracle DB?
l am trying to make use of some proprietary Oracle Java classes/methods using an Oracle provided virtual machine (E-Business Suite Vision, Oracle 12.2.28)
On my test server I define a function:
[...
0
votes
1answer
41 views
How to alter an existing partitioned table to add sub-partitions to it?
This forum has helped me earlier on many occasions and now I need someone to help me with this.
I am looking to convert a pre-existing partitioned (range) table - to sub-partitioned (composite range-...
1
vote
1answer
34 views
Missing right parenthesis after (or before) default 0, Oracle
I am trying to create a table with Oracle SQL where two columns of the table should have a default value and should not be NULL.
I am getting the error you can see below, but i am not able to ...
0
votes
0answers
10 views
ORA-01502 during insert
So I have a table with an index on a RAW datatype column. And then I have a procedure which disables all indexes on that table, truncates it, and then inserts data into it. After that it enables all ...
0
votes
1answer
19 views
Data replication from Oracle 12c to MySQL using Golden Gate - is it possible?
I have tried to replicate the tables using regular extract/replicate method and got an error "Classic Extract does not support multitenant container databases" on Oracle 12c (source db). So that means ...
1
vote
0answers
23 views
ODBC Error for Oracle Client 12.2.0.1
I installed Oracle Client 12.2.0.1 (x32) on a Win7 x64 machine. When I tried to create an ODBC by invoking "C:\Windows\SysWOW64\odbcad32.exe" and picking the "Oracle Client" from the list and clicked ...
1
vote
1answer
16 views
PDB state in Oracle 12c RAC
Installed two node Oracle RAC. On node 1 opened pdb1 and shows open mode as read and write but on node 2 it's still in mounted state?.
On Node1
rlwrap sqlplus / as sysdba
SQL*Plus: ...
3
votes
0answers
73 views
Import Oracle unicode data with OLE DB Source and destination in SSIS 2015
My issue is identical to this post on mssqltips.com, however my issue is importing from Oracle, not Excel.
I get all the way to the bottom where I need to map the output columns from my data ...
0
votes
1answer
38 views
Oracle XE 12c won't configure - getting the “port 5,500 in use” error message
I have the infamous "port 5,500 in use" error message while trying to start/configure Oracle XE 12c.
I have searched for this problem and every solution I have found has been the same - make sure the ...
0
votes
0answers
22 views
select rows without links with other tables. Orphan data
My question is acoording to keep clean a table and in addition all the database.
For this example, we have a tables with two foreign keys with other two tables.Now i want to know if it's possible to ...
1
vote
1answer
64 views
Which Oracle datafiles grow in size?
I have downloaded and started up Oracle's pre-built OTN Developer Day VM. The VM is running on an SSD. I want to move datafiles that can grow to a separate mount point (setup as a vmdk on a HDD. more ...
1
vote
1answer
55 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 ...
0
votes
1answer
22 views
data_precision and data_scale Missing from Oracle's all_tab_columns
I need to know the data_precision and data_scale values for the fields in a view in Oracle 12c. I am not the owner of the view and I do not have access to the underlying tables.
When I query ...
0
votes
1answer
35 views
How to rearrange columns in Oracle SQL Developer script output
maybe this is an already answered question, but I am relatively new to Oracle DB and couldn't find my answer around the Internet.
So I have created a table in Oracle and when running the SELECT ...
0
votes
0answers
12 views
How to find full siblings? I have been able to find the parents, but can't figure out how to join siblings based on having same parents
I have two tables (table/column names not my choice):
| Person | | Parent |
------------------------------ -----------------------
| ...
0
votes
0answers
28 views
mysql run out of memory during mview refresh
I want to create mview from mysql to Oracle using DBLink via odbc driver with Linux 64 bit os. but due to large number of Records around 2.5 cr records it raise the error
ERROR at line 1:
ORA-28500: ...
1
vote
0answers
9 views
Oracle Secure Backup (OSB) issue - “failed to read configuration data - Network is unreachable”
I am using Oracle 12.2.0.1 on Linux 6.8. I am using OSB to take a backup to tape.
After an unknown host name error in the backup log, I edited the /etc/hosts file and restarted the server.
After ...
0
votes
2answers
52 views
Fix Oracle Database chained rows
A Oracle 12c Database has a table with Chained rows:
select
owner c1,
table_name c2,
pct_free c3,
pct_used c4,
avg_row_len c5,
...
0
votes
0answers
27 views
Does “Inheritance” Make Sense with This Requirement?
I'm using Oracle 12c. Given an existing table (we call it TBL_M), and based on the criteria below, I was wondering if using inheritance makes sense to lay out the entities:
Information for one group ...
0
votes
0answers
60 views
Transactional replication from Oracle PL/SQL to MS SQL Server broke from the data in a Date column but previous records with same date are ok?
I have a heterogenous transactional replication subscription setup between PL/SQL (12C 12.1.0.1.0) and SQL Server (2008 R2), where the Oracle PL/SQL server is the publisher and the MS SQL server is ...
0
votes
1answer
35 views
Incremental level 1 RMAN not being deleted
I am doing a level 0 (full) incremental backup on Sundays, with the following global script:
printing stored global script: weekly_backup
{
allocate channel DISK1 device type disk format '&...
0
votes
1answer
20 views
What is the largest whole number in Oracle SQL table that can be stored without rounding errors?
I want to "concatenate" numbers to create temporary ids for tuples of objects, but I am worrying about precission loss and rounding errors. Query below suggests that there are no problems with ...
2
votes
1answer
67 views
Non-CDB database vs Single tenant CDB
I am looking at the prospect of upgrading from oracle 11G to 12C, and I am looking at the cdb vs non-cdb models, and I am having a hard time seeing the benefit of using CDB, without multitenant ...
0
votes
1answer
47 views
use SQLcl with EZconnect and multiple hostnames (ADDRESS_LIST=)
this is our classic tnsnames.ora
test1=
(DESCRIPTION=
(CONNECT_TIMEOUT=4)
(TRANSPORT_CONNECT_TIMEOUT=3)
(ENABLE=BROKEN)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=example1....
0
votes
1answer
58 views
don't the users SYS and SYSTEM share the table dba_users?
While being logged in as SYS, I created a new user. I ran
select username from dba_users order by username;
and I was able to see the user that i just created;
Then, I logged as SYSTEM, I ran the ...
0
votes
2answers
135 views
how to stop OracleRemExecServiceV2 from cmd?
I have Oracle 12c running on Windows 7.
When I look at the Oracle's specific services (Control Panel\System and Security\Administrative Tools\Services), I have the following 6 services:
So far, ...
0
votes
0answers
17 views
I need to run a report using rwclient or rwrun, Forms12c
I need to run a report using rwclient or rwrun, Forms12c.
What would be the necessary configuration to execute the report on the client's PC?
0
votes
2answers
74 views
Stop long running scheduled job
I need to launch a scheduled job at 12 o'clock at night and keep this job running for a period of 8 hours. What happens now is that the job is running for more than 12 hours and I really need to avoid ...
0
votes
0answers
18 views
Adop prepare failed due to the Node Manager is not up
While i am running adop prepare stage in 12.2.6 , getting a error WLSTException: Error occured while performing nmConnect : Cannot connect to Node Manager. : Connection refused. Could not connect to ...
0
votes
0answers
14 views
How many keys does wallet keystore have?
I my scenario I have configure transparent data encryption with password based
software keystore only for example 'ewallet.p12' and create a master key for software keystore.
I want to know can we ...
0
votes
0answers
43 views
Oracle Apex 18.1 installation problem windows server 2016 (db 12c)
I am trying to install oracle apex 18.1 in windows server 2016 on database 12c.
After login sys as sysdba when I give the command:
@apexins.sql sysaux sysaux temp /i/
then this error occurred.
...
0
votes
2answers
35 views
does sequence of columns in where condition matters the sequence of composite key? in Oracle Database
here, In the code where exists clause contains all primary key columns in where, I want to know that the sequence of this columns in it, matters in query performance.
update temp_fd_dtl_svj a
set ...
1
vote
1answer
133 views
ORA-48108 / ORA-48140 / ORA-48187 - diagnostic_dest value error(s) - init files / control files
This is all testing / training - none of this is related to a production env
Using ORACLE DB 12c + UNIX/LINUX 64-bit on an VM.
.
Hi Guys!
I am running in the below error(s) and seem unable to ...
0
votes
0answers
22 views
Missing bind variables in EM Database Express query download
I am investigating slow performing queries using Oracle Enterprse Manager Database Express and wanted to download the SQL text from the console. It gives the option to save the bind variables with ...
0
votes
2answers
77 views
Welcome message for oracle schema
I want to display welcome message when ever a oracle schema try to login database using TOAD or PLSQL developer only
0
votes
1answer
78 views
ORA-14224 Deferred Segment Creation is not supported for this schema
I'm trying to use deferred segment creation and not having any success.
My deferred_segment_creation parameter is set to TRUE, but new tables do not defer. I've also tried explicitly stating SEGMENT ...
0
votes
0answers
39 views
Test connection between application and DB using Oracle instant-client
Good morning
I have on one side an 12.1.0.2 Oracle database server and on the other side an application server which is running Windows Server 2012 R2 Standard.
Client connection to the database are ...
0
votes
1answer
23 views
Does tables under schema uses multiple tablespaces other than default tablespace
I have schema 'A' in a database and assigned a default tablespace as "myspace".
There are 20 tables resides under single schema and all tables are using different tablespaces.Here my doubt is "Why ...
0
votes
1answer
23 views
Consume data from other database motor from stored procedure in Oracle 12c
I have a project in which you must develop services in Oracle OSB which will call a procedure stored in Oracle 12c. The issue is that I also need data from an Informix database to build those services....
0
votes
0answers
30 views
Restrict Oracle database schema to login using Toad/PLSQL [duplicate]
I want to restrict my Oracle database schema for example john to login to database using tools like toad or PLSQL developer. this schema is used for application login using JDBC thin client. I cannot ...
1
vote
1answer
89 views
Is EXPDP the best backup approach when running Oracle on Windows with no RMAN?
Well, I'm the SQL Server DBA here, and we have a Oracle Senior Dba that manages Oracle Databases and users. I'm curious about how he is handling these servers/users.
What is the best approach, when ...
0
votes
1answer
28 views
Access tables from multiple schemas
I have two schemes with multiple tables. The queries in packages heavily reference schema names. Is it possible to remove schema names from the queries and oracle to identify the tables based on roles ...
0
votes
0answers
7 views
Keeping INSTANCE_NAME on Data Guard failover
I have a legacy application which uses a lot of PL/SQL stored procedures. It has a deeply ingrained need to know in which environment it is running, and uses the INSTANCE_NAME for that. For the sake ...
0
votes
0answers
12 views
Get the current upper limit value for nvarchar2 in an Oracle 12c db
Starting from 12c, Oracle Database provides a way to control the max byte-size of a NVARCHAR2 column. To use up to 32767 bytes instead of 4000, one has to set the parameter max_string_size to EXTENDED....
2
votes
1answer
55 views
START WITH and CONNECT BY condition in Oracle SQL
I have a question on the START WITH and CONNECT BY condition (in Oracle 12c):
This is my Oracle SQL:
SELECT
employee_id,
lpad(' ', level*2-1,' ') || last_name,
manager_id,
level,
...
0
votes
0answers
25 views
audit policy on a table does not log expected results
Running on Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production. Attempting to test auditing with the following steps:
Created a new user, MYUSER.
CREATE TABLE mytest (
id ...
0
votes
0answers
7 views
Oracle: set prefix to log messages
Is there any way to add a prefix to the log messages in an Oracle DB?
In PostgreSQL, for instance, there is the application name that can se set as a prefix to any message.
Is there any function I ...
0
votes
1answer
24 views
Why does the system generated TNSNAMES.ORA have two entires, one with a full connect descriptor and another with just a network address?
My TNSNAMES.ORA file was auto-generated when I installed my database. It generates with two entries for my database however. One entry looks "complete" with a full connect descriptor, while the 2nd ...
