Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

  7. current community

    your communities

    more stack exchange communities

    company blog
Database Administrators

Questions tagged [oracle-18c]

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

12 questions
Info Newest Frequent Votes Active Unanswered
0
votes
0answers
23 views

How to migrate Oracle 11g on-premise database to Oracle 18c cloud? [on hold]

As per my knowledge, Oracle 18c can be installed as on-premise database. But what is actually cloud database? Is it that we download and install 18c on any AWS kind of cloud platform or is it that 18c ...
1
vote
0answers
38 views

Oracle 18 on Windows with long hostnames?

We're having troubles getting Oracle 18c DBCA (XE or non-XE) working on Windows machines (both Win7 and Win10) where the machine name is longer than 15 characters (the NetBIOS limit). It seems the ...
0
votes
1answer
17 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
21 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
20 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
129 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
189 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
465 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
218 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 ...
0
votes
1answer
59 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
3k 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
3k 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 ...