Questions tagged [oracle-12c]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
276 views

rtkit-daemon[1119]: The canary thread is apparently starving. Taking action

I am using Oracle Linux Server release 7.9, we have installed oracle 12c on this machine and running a consistent load. During the night time after running the test for more than 8-10 hours, suddenly ...
user avatar
4 votes
5 answers
15k views

Oracle Database 18C XE Installation completed with Errors

I am getting the below error while trying to install Oracle Database 18C XE on my local system (Windows 10 Pro). Oracle Database Installation Completed with Errors The wizard was interrupted before ...
user avatar
  • 41
0 votes
1 answer
1k views

WebLogic servers (installed as a windows service) automatically stop

I have installed Oracle Database 12c Release 2, along with Oracle WebLogic Server 12c (12.2.1.4) and Oracle Forms and Reports 12c on my system, according to the documentation provided in the main ...
user avatar
  • 1
0 votes
2 answers
982 views

TOAD(11.5) - DB Connection fails with 'protocol adapter not loadable' , windows 10

It all started with me trying to import 11g db dump into 12c R2 oracle. DB Dump - 11.02.0 Server - 12.2.0.1.0 I was getting the tns error 'could not resolve connect identifier specified'. After ...
user avatar
0 votes
1 answer
382 views

How to fix OGG-01163 in oracle goldenGate

Have an error in my *.rpt file: 2019-09-26 17:58:56 ERROR OGG-01163 Bad column length (56) specified for column AUTHORISATION_ID in table TCPF.OPERATION, maximum allowable length is 40 When the ...
user avatar
1 vote
0 answers
2k views

weblogic server 12.2.1.3.0 config.cmd did not work on windows 10

I am trying to setup weblogic server 12.2.1.3.0 on windows 10. I run fmw_12.2.1.3.0_wls.jar successfully. But when I try to create domain using config.cmd file, configuration wizard wasn't opened. I ...
user avatar
  • 11
0 votes
1 answer
131 views

Create Consecutive Months

I am trying to create a database where each clients runs are summarized based on consecutive monthly runs. The code below builds a table which looks like this: drop table RUNNING_LOG; create table ...
user avatar
  • 101
1 vote
0 answers
23 views

how to run 'current' or 'multiple' SQLs in LINQPad

I've search around and can't find what I'm looking for here. Hoping a SuperUser can guide me. I'm working with Oracle inside LINQPad. Just basic SQL. And I can't figure out how to get the app to run ...
user avatar
0 votes
0 answers
357 views

how to parse an oracle DDL script?

My problem is that I need to key in details of a list of DDL script into my metadata table but due to the size of the file, it is difficult to do it one by one. I would like to check is there any way ...
user avatar
  • 525
0 votes
1 answer
148 views

how to set oracle 18.3 variable environment permanently in redhat 6.9

I'm trying to set oracle variable environment in my .bashrc file, but Boy!... export LD_LIBRARY_PATH=/usr/lib/oracle/18.3/client64/lib:$LD_LIBRARY_PATH /usr/lib/oracle/18.3/client64/bin/...
user avatar
  • 91
0 votes
1 answer
1k views

weblogic server installation issue

I got my weblogic installation file here: https://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html I was able to open my Admin command prompt (Win key+R, type cmd and ...
user avatar
  • 1
0 votes
1 answer
364 views

ORA01017 - invalid username and password logon failed

1) I installed Oracle 12c (64 bit windows)12.2.0.1.0 2) I installed sql developer and tried to connect to the database, I realized I forgot user name and password. I dont even remember if I entered ...
user avatar
1 vote
1 answer
4k views

Oracle.DataAccess.Client and .NET Framework errors in Microsoft Excel

When trying to access an Oracle 12c Database through Excel and Power Query, I received an error stating The recommended provider("Oracle.DataAccess.Client") is not installed. You can continue ...
user avatar
2 votes
0 answers
254 views

How to set up driver for Oracle 12c database on Mac

I work on a Mac (macOS Mojave 10.14.1) and I am trying to set up an ODBC driver to connect to an Oracle database (my eventual aim is to connect via R using the DBI package). I don't have the ...
user avatar
1 vote
0 answers
120 views

Connecting Oracle 12c OSB to Oracle 9i Database is having an intermittent connection error

After upgrading OSB to 12C, all JCA connections to 9i Database is having an error with: The invocation resulted in an error: Invoke JCA outbound service failed with connection error, exception: com....
user avatar
3 votes
0 answers
690 views

No Support for Oracle UDT in latest version of oracle.manageddataaccess.dll

With oracle.DataAccess.Types we were able to integrate user defined types in oracle. But In latest version of Oracle.ManagedDataAccess.Types UDT is not supported. It seems that ODP.NET Managed Driver ...
user avatar
  • 31
0 votes
1 answer
480 views

Oracle 12.2 Breaks on Install on Windows 10 Pro machine

I am coming from a Linux background, so I don't know much about Windows at all. I have a factory fresh Windows 10 Pro machine and I have anti-virus and firewall disabled. I downloaded the 12.2c ...
user avatar
0 votes
1 answer
249 views

ssh connection refusing and .runinstaller pop up not coming

Facing one issue during two node RAC setup in Laptop. .runinstaller at first showing the "DISPLAY CAN NOT SET ERROR". Then after sort this out by setting display it is not shwing any popup so that I ...
user avatar
  • 1
0 votes
2 answers
638 views

login on oracle database 12c release 2

I am new with Oracle database. So I went ahead and installed Oracle database 12c release 2 following some instructions on youtube. In another video tutorial I saw this where the he clicks on Password ...
user avatar
0 votes
1 answer
315 views

Oracle startup hangs after OS upgrade

I'm just upgraded My Fedora 25 to Fedora 27 using Upgrading Fedora 26 Workstation to Fedora 27 but after rebooting the system, now I can not start my Oracle DB. I'm using Oracle 12.1.0.2 ...
user avatar
2 votes
0 answers
12 views

Is it possible to view queries with resolved variables in ODI's code executions?

In ODI's operator tab you can check the state of an execution, and inside each execution the SQL used for each transformation. On the project i'm working on we use a lot of variables when developing ...
user avatar
1 vote
1 answer
178 views

What is consuming ZFS pool space?

Environment: SP firmware 3.2.4.1 zfs Solaris 11 zones Problem: Poor system design has lead to constant space pressure on the internal disks. Once a pool goes over 80%, zfs goes into a whole lock ...
user avatar
  • 141
2 votes
1 answer
2k views

Failed to install Oracle client with an error "path is too long"

I'd like to know how to install Oracle Client on my Windows 10 pro PC/Dell Vostro 3860 properly cause of I got a problem to install the client software that "PATH is too long" error. What I tried to ...
user avatar
  • 25
1 vote
2 answers
2k views

With the Linux subsystem (beta) on Windows 10, can I install Oracle 12c and use it in bash (Linux subsystem)?

I want to install Oracle Database 12c on my Windows 10 PC and use it with Linux commands on the provided bash. Can I do this? If so, then how?
user avatar
  • 111
1 vote
0 answers
56 views

Change the name of an object within an archive

My company has some software that uses a 3rd party library to interact with an oracle database. It hasn't been tested in a long time, and now that we need to verify that it's working, we can't get ...
user avatar
2 votes
1 answer
12k views

How to prevent high memory usage for Oracle RDBMS Kernel Executable?

I had set up Oracle DB 12c to my computer a few days ago and it slowed my computer down badly. I noticed that is causing high memory usage today. This usage stems from Oracle RDBMS Kernel Executable ...
user avatar
  • 21
-1 votes
1 answer
2k views

Error while installing jdeveloper 12 c in windows 10

Since .exe file is not working directly i extracted jdev_suite_122110_win64.exe file and executed the command in command prompt as mentioned in this question C:\PROGRA~1\Java\jdk1.8.0_25\bin\java.exe ...
user avatar
0 votes
0 answers
123 views

Something drops my 1521-portrequest for OracleOraDB12Home1TNSListener - what and why?

I'm quite desperate, running out of ideas for this continuos failure: I can't connect from SYS03 (with SQLdeveloper) to SYS06 Oracle Listener on port 1521. the other way round (OLIPP06/Sqldeveloper ...
user avatar
  • 111
10 votes
3 answers
41k views

Can I delete user directory after deleting user?

The reason I ask is because I recently made the mistake of installing Oracle 12c on my sub-performance laptop. Noticing the excessive amount of resources this added up to on startup, I decided to ...
user avatar
0 votes
1 answer
1k views

Can't import a dmp file to oracle 12c database (imp-00037)

I am trying to import a dmp file to my oracle 12c instance, while I used to do that without trouble I got a file which didn't work with both imp and impdp. After long research without a result I ...
user avatar
0 votes
1 answer
662 views

Comparison between Oracle RAC Cluster Database (10gR2, 11gR2 and 12cR1) and deployed Oracle DB on Linux Cluster [closed]

Oracle RAC implementation may be costly for small enterprise, but how it would be if Linux cluster is implemented and then standard Oracle DB is deployed on that cluster to achieve availability like ...
user avatar