Questions tagged [oracle-12c]
The oracle-12c tag has no usage guidance.
31
questions
0
votes
0
answers
1k
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 ...
4
votes
5
answers
22k
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 ...
- 41
0
votes
1
answer
2k
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 ...
- 1
0
votes
2
answers
2k
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 ...
0
votes
1
answer
1k
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 ...
- 101
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 ...
- 11
0
votes
1
answer
463
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 ...
- 101
1
vote
0
answers
30
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 ...
0
votes
0
answers
487
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 ...
- 577
0
votes
1
answer
260
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/...
- 101
0
votes
1
answer
2k
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 ...
- 1
0
votes
1
answer
494
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 ...
1
vote
1
answer
6k
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 ...
- 33
2
votes
0
answers
325
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 ...
- 121
1
vote
0
answers
201
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....
- 11
3
votes
0
answers
823
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 ...
- 31
0
votes
1
answer
586
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 ...
- 151
0
votes
1
answer
474
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 ...
- 1
0
votes
2
answers
764
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 ...
- 153
0
votes
1
answer
362
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
...
- 1
2
votes
0
answers
16
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 ...
- 21
1
vote
1
answer
312
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 ...
- 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 ...
- 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?
- 111
1
vote
0
answers
61
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 ...
- 41
2
votes
1
answer
15k
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 ...
- 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 ...
0
votes
0
answers
127
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 ...
- 121
11
votes
3
answers
46k
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 ...
- 346
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 ...
0
votes
1
answer
670
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 ...
- 287