Questions tagged [oracle-database]
The oracle-database tag has no usage guidance.
33
questions
0
votes
0
answers
217
views
Toad -- seeing windows side by side
I'd like to see the SQL editor in TOAD allow one to see windows side by side (as NotePad ++ allows with "move to other view", for example.) My purpose would be to look at to different (but ...
1
vote
2
answers
203
views
how to apply patch from Oracle Critical Patch Update Advisory?
I installed Oracle database but no longer need it. I've tried uninstalling it but that still leaves a lot of security vulnerabilities on my machine. So now I'm looking to apply the Oracle Critical ...
0
votes
0
answers
2k
views
How to read/fetch data from Oracle SQL database using PowerShell Core?
I have been researching on this for a couple of days but have been going in circles here.
I need to write a script that fetches the data from Oracle db and do something with the data. In my script I ...
2
votes
1
answer
3k
views
How to capture strings between two words/characters
How to capture strings between two words/characters either or both words have multiple occurrences but I want the words both from the first column.
1. A-Hi hello C-0987654321
2. B-Zzzzzzzzzzzz D-Hi
3....
0
votes
1
answer
1k
views
Oracle 19c won't install
Kind of a mess here. Did two successful successive installs of Oracle 19c database and now no Oracle database will install on my Windows 10 Pro machine. Found that installing Oracle Developer Tools ...
1
vote
0
answers
67
views
which io scheduler is recommended when use the blk_mq block layer with oracle database?
I have oracle Linux 6.10 with 4.1.12 kernel. I have recently moved from the legacy block to the blk_mq block. But all SCSI devices have show io scheduler is none. I have researched but I didn't find ...
4
votes
5
answers
23k
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 ...
1
vote
1
answer
1k
views
How can I fix this oracle error?
When I execute this command it won't work. Why am I getting this error? What can I do to fix this? Thanks!
$ grant read,write on directory <SID>_DATA_PUMP_DIR to system;
$ grant read,write on ...
0
votes
2
answers
3k
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
428
views
Oracle Commit size larger then available Ram, but v$memory_target_advice says OK
Running Oracle 18c on a Windows 2012R VM (VMWare). (I don't have access to any of the VM Admin tools.)
The VM has 5 vCPU, and 12GB Ram (this was supposedly the recommendation from the VM Team to ...
0
votes
1
answer
271
views
Oracle Linked Database Server
I have an Oracle 9i in my server and MS SQL Server 2017. I wanted to link the Oracle database to my MS SQL. I am trying to add the Oracle Database to MS SQL as a Linked Server.
1
vote
2
answers
5k
views
Oracle installation - SQLPlus cannot find TNSNAMES.ORA
I just uninstalled an older Oracle installation on my computer (which was working fine) and installed a new one, and the new installation can't seem to find the TNSNAMES.ORA file even though it is in ...
0
votes
0
answers
5k
views
Why does Oracle SQL Developer freezes (unresponsive) once I create a new connection?
I have only installed Oracle XE (the latest version 18g) and SQL Developer.
1
vote
1
answer
5k
views
How do I install both Oracle 64-bit and 32-bit ODBC drivers and have both working in ODBC Data Source Administrator
PREFACE:
I am a novice when it comes to oracle and installing odbc drivers.
SETUP:
Laptop - Windows 10 Pro 64-Bit
Excel - 64-bit version
Application - 32-bit
Oracle instantclient_18_5
PROBLEM
An ...
0
votes
0
answers
40
views
Can a remote server connect to a local Oracle database?
I am having trouble getting an answer - albeit it may be due to my own ignorance on the subject. However, here it goes:
Can I connect to my company's local Oracle database from a web server? ...