Database Administrators

Questions tagged [oracle-18c]

Ask Question

Oracle Database 18c. Please also tag oracle for search purposes.

15 questions
Newest
Active
Bounties
0
Unanswered
Filter by
Sorted by
Tagged with
1
vote
0answers
23 views

Oracle procedure takes forever to compile if I use public synonym

I have a procedure that queries a table through a DB link. If my procedure uses a public synonym through the DB link, it takes forever to compile. I'm creating the procedure in Oracle 12c. The DB ...
1
vote
1answer
49 views

Issues setting up Oracle 18c XE on Windows Server 2012 r2

I've been running into some problems getting my Oracle installation up and running on Windows Server 2012 r2 at work. Initially, I had installed Oracle on my Win10 laptop for test purposes - I ...
2
votes
0answers
94 views

Insert statements completion increase over time [closed]

here's my situation: I recently setup an Oracle 18c instance on a virtualized Microsoft Windows Server 2016 (4 cores, 16GB RAM, seperate disk for running oracle and it's datafiles) running a (more or ...
1
vote
2answers
63 views

Issue Moving data from 11g to 18c

I have an rman database backup from Oracle 11g XE which i am trying to import into oracle 18c XE database using below commands rman target / shutdown abort; startup nomount; SET DBID ...
1
vote
0answers
79 views

Oracle 18 on Windows with long hostnames doesn't talk to the local listener?

Note: Initially this was about installing Oracle 18c XE on a Windows machine with a long (> 15 chars) hostname. During our further tests we then noticed that Oracle 18c XE does not work properly at ...
0
votes
1answer
24 views

Falied to load resource files of Oracle APEX plugin

I've installed a plugin in APEX, but when I've tried to use it on a page, I've got some nasty errors and page not working properly. The files are present in the plugin settings: But, as you can see ...
0
votes
0answers
45 views

Connect to Oracle database as apex_version user

I'm talking about schemas like APEX_040200, APEX_050100, APEX_180300, APEX_190100 etc. I'm trying to install an APEX Plug-in that is being installed from a script, where developper commented Assumes ...
0
votes
0answers
35 views

Reference apex_workspace_apex_users or wwv_flow_fnd_user in a foreign key constraint

What I'm trying to do is to extend authorisation upon APEX basic users to use it as conditions of pages rendering. I would like to create additional tables to store some workspace specific info about ...
1
vote
1answer
200 views

Error while configuring REST for Oracle APEX on Windows

I'm trying to deploy Oracle APEX 18 on Windows 8.1 PC using Oracle REST Data Services and Oracle Database 18c XE following this guide. But when I'm trying to run @apex_rest_config.sql I get this ...
0
votes
1answer
361 views

Cannot create an additional database in Oracle 18c XE

Creating a new database in Oracle 18c XE throws this error, does this mean that I can only use the database created by the installation? ORA-00442: Oracle Database Express Edition (XE) single ...
1
vote
1answer
885 views

Oracle - Can't login with “/ as sysdba”, but can with “sys as sysdba”

I've been working on setting up a docker container running Oracle DB XE 18.4.0. I have the container built from Oracle's dockerfiles and it is working fine, except that I cannot login using connect / ...
0
votes
0answers
339 views

Change Encryption Wallet type from PASSWORD to AUTOLOGIN

I am currently working on an Oracle 18.3 DB and I have a script which allows me to create an encrypted seed PDB. As part of this script, we encrypt the system tablespaces (like SYSTEM, SYSAUX, and ...
1
vote
1answer
61 views

How to disable Oracle OCI client transparent reconnect

I have an application I wrote that uses OCI to connect to an Oracle database. The database has recently been upgraded to Oracle 18, and since then database searches in the application randomly stop ...
1
vote
1answer
4k views

Oracle 11g XE to 18c XE - What is the difference? Is 18c can be used like 11g XE?

I have worked on Oracle 11g XE about two months ago. After that I de installed them about a week ago. Now, I am curious to learn a little bit more about databases and I tried to installed Oracle 11g ...
2
votes
1answer
4k views

Oracle database 18c – ORA-12541: TNS:no listener

I have installed Oracle 18c in my local machine and i have created a user names as USER_NAME := c##scott Passkey : oracle When i used to connect to that user using cmd. The following error is ...