Questions tagged [oracle-18c]

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

Filter by
Sorted by
Tagged with
2
votes
1answer
103 views

How do I create a new Oracle schema?

I’m pretty familiar with Relational DBMS in general, but not with Oracle. I have Oracle 18c XE running inside Docker (on MacOS). I connect to it using a third party client (SQLPro Studio on MacOS). ...
0
votes
2answers
78 views

Select arbitrary single value for GROUP BY: What's the fastest option?

I have a query that I use to indicate locations in a map where there are overlapping points: select min(objectid) as min_objectid, longitudex, latitudey, count(1) as count, min(...
0
votes
1answer
32 views

Need for backup with Active Dataguard

When exploring the features of Oracle Active Dataguard, I found that one of them is block change tracking to allow the standby db to take the load of backups instead of the primary database doing them....
0
votes
0answers
27 views

Changes in OraOleDB v18

I use OraOleDB (Oracle's OleDB implementation) in a C++ application on Windows to create tables and insert rows. In the application it is also possible to connect with Oracle using ODBC through OleDB. ...
0
votes
1answer
44 views

enforcing function/constant names length in Oracle 18 to be 30 characters

in Oracle 18 is there a way to enforce the max length of function names (and constant-names) to be 30 chars only (as it is in Oracle 11 and priors)?
0
votes
0answers
25 views

Application connection pooling load balancing the transactions on 18c RAC

Application connecting a 2 node 18c RAC. JVMs are using connection pool and transactions are routed to the nodes via the connections in the pool. So the initial load across the nodes are distributed ...
0
votes
2answers
40 views

What are the benefits of moving redologs, data- and controlfiles to another location?

I have installed Oracle 18c XE and was wondering what benefits/disadvantages would come from seperating the data that is stored inside the databases managed by the dbms and the actual Oracle ...
0
votes
1answer
55 views

Oracle 18c opatch util cleanup not working

System: [oracle@hostname:/opt/oraclegrid/18]$ uname -a SunOS hostname 5.11 11.4.24.75.2 sun4v sparc sun4v Database: Oracle 18c 18.10 (April 2020 patch), RacOneNode setup Opatch OPatch Version: 12.2....
0
votes
0answers
36 views

ORA-01403 _sometimes_ while reading a file on Oracle 18c

Edit: We just checked: it also happens in on-premise Oracle 18c, latest patchset and everything. In Oracle PL/SQL we are opening and reading a file. The file exists, we are getting data, but then ...
0
votes
2answers
43 views

Trigger: Only raise error if related record was NOT created between now and last Sunday

I have a trigger that prevents inserts into a DELETES table under certain conditions: CREATE OR REPLACE TRIGGER D202574_custom BEFORE INSERT ON D202574 FOR EACH ROW DECLARE v_upd_row NUMBER; ...
0
votes
0answers
12 views

How to shutdown and startup a database to delete datafiles in between

OS: Windows 10 Professional / DBMS: Oracle 18c XE How would one approach the issue of losing a connection while shutting down the database? I would like to have one script which deletes datafilepaths ...
0
votes
1answer
17 views

Is it possible to grant a user the equivalence of ownership over a another users schema?

Im trying to create a trainer/trainee environment in Oracle 18c XE. So far I have 4 trainee users which all have the hr-sample installed. Now, I plan on having one trainer user that is able see ...
0
votes
3answers
49 views

How can we clean up/backup of .DBF files in Oradata folder in ORACLE on windows

We have very less space on our C Drive where the DBF files are stored in windows server. Can we clean up some space any logs can we removed on observation could see that DBF files are taking huge ...
0
votes
2answers
109 views

Can't find missing packages Oracle Linux 8

super newbie here. Trying to learn DBA stuff. I've been trying to install oracle database 18c on Oracle Linux 8 but there are two missing packages that are just not being found. I need these to ...
0
votes
2answers
77 views

Impact of “_oracle_script”=true in Oracle database 18c

I just installed Oracle XE 18c (I migrated from 11g XE) ... After running the installer, I saw new features; for example, Oracle now supports a multitenat model and a concept called pluggable ...
0
votes
0answers
58 views

Unable to find oracle/dms/console/DMSConsole

I am using centos-8, java-8, tomcat-8, oracle 18.4.0 XE I not able to connect to the database. Tried to check everything that I was able to do but not able to understand where is the mistake. I ...
0
votes
1answer
29 views

Migrate Oracle 12c to 18c in AWS RDS

Currently we have an Amazon RDS Oracle 12c instance and we need to upgrade it to Oracle 18c in a new RDS instance. What is the correct approach to do this? Can we set up an 18c instance staright ...
0
votes
2answers
73 views

Unable to import DMP file that is made in 11g2 to Oracle 18c

My OS=CENTOS 7 Oracle=18c XE I am trying to import a DMP file that is exported from XE 11g2 and now trying to import it in 18c XE. Here are the errors: [root@linux gsw]# impdp user/pass ...
0
votes
1answer
20 views

Not able to access Oracle manager online. Port 5500 is closed [closed]

I am using Oracle 18c XE on CentOS 7. The database installed successfully but not able to bring it online to my hostname. what I did is: Added port 5500 in firewall: firewall-cmd --permanent --add-...
0
votes
1answer
131 views

[[FATAL]] [[DBT-06103]] The port (5,500) is already in use [duplicate]

I am trying to install oracle 18c XE on CentOS 7. I have opened the ports: firewall-cmd --permanent --add-port=1521/tcp firewall-cmd --permanent --add-port=1630/tcp firewall-cmd --permanent --add-...
0
votes
1answer
39 views

Is Oracle 18c XE good enough to start learning to be a DBA? [closed]

I don't know if the esteemed community here will find this question silly, but at the same time I thought that I would get a good answer to my question here. As of now, I am into writing SQL queries/...
1
vote
1answer
37 views

Keep getting “Connected to an idle instance” in 18c when trying to connect to database

I installed Oracle Database 18c yesterday and then installed Oracle Application Express v20.1. Everything was perfect and I was able to work on Apex too. Then I shutdown the computer and today I ...
0
votes
1answer
27 views

How does one connect to a schema within a PDB (other than schema SYS)?

Using Oracle 18c on RedHat Linux 8 Connecting to CDB as 'SYS', I cannot figure out how to connect to a schema within the PDB other than as 'SYS'. Maybe I don't understand the CDB/PDB architecture ...
0
votes
2answers
170 views

What are v$database, SID, ServiceName, istance in Oracle 18c?

I have set up Oracle 18c (18.4) on Windows 10 on a company laptop (localhost should be the same as my company's domain name). Once I've created user SYSTEM with password at the installation I tried to ...
0
votes
1answer
457 views

LRM-00101: unknown parameter name '_first_spare_parameter'

I am part-way through an upgrade from Oracle 11g to 18c on RedHat. The Database Upgrade Assistant gives the message: Errors encountered during the execution of "Database Components Upgrade". ...
0
votes
0answers
26 views

Oracle XE 18c DBFS_CLIENT auth failing for SYS without SYSDBA privileges

I have been following this tutorial to setup an Oracle DBFS environment for testing. A certain step of the tutorial is pointing to the use of the DBFS_CLIENT: When I try to authenticate on the ...
0
votes
1answer
21 views

Defining password complexity and its action on “grace” state USERS

I have Oracle USERS linked to external applications that came to "grace" status. I tried to change the assword time expiration to unlimited but it doesn't apply to those account (considering I guess ...
1
vote
1answer
47 views

Create a view with distributed Lobs

I have two Oracle 18c instances (instance 1 with schema DB1 and instance 2 with schema DB2) and I know that there ist a support for distributed lobs since 12.2. So i did the following: CREATE TABLE ...
2
votes
1answer
153 views

Scheduled snapshots of views (without using materialized views or Oracle Golden Gate)?

I have 40 views in an Oracle 18c GIS database that are used in a map in a workorder management system (WMS). The views are served up to the WMS map via a web service. There are an average of 10,...
0
votes
0answers
86 views

How to import db-sample-schemas into Oracle's DB?

I need to import some sample dump file for educational and testing purposes. I've found the next dump file and tried to import it using: imp testuser/oracle file=/home/oracle/PurchaseOrders.dmp ...
0
votes
1answer
3k views

Unable to install Oracle XE 18c on Centos 8

I am trying to install Oracle 18 on Centos 8 64 Bit. I have been able to install the prerequiste component, that in itself requires pre-requisites, but the Oracle install itself fails. Any ...
0
votes
1answer
101 views

Unable to connect to oracle user

I have hit a rather frustrating snag in that after installing Oracle 18c. I have been unable to successfully create a user and then connect to it. More precisely I can create the user but the ...
0
votes
1answer
83 views

Automatically purge dropped tables in Oracle

I am using an Oracle 18c database in a build system. One of my builds is for a JPA/Hibernate project, which is configured as "create-drop". This means it will create all tables during startup and ...
0
votes
1answer
90 views

Oracle JSON ADT in Collection

Why is the table() operator not working? create or replace type tmp_011040_t2 as table of (JSON_OBJECT_T) NOT PERSISTABLE; declare l_objects tmp_011040_t2; begin l_objects := tmp_011040_t2(); ...
0
votes
1answer
68 views

How to make Swingbench 2.6 and Oracle 18c work together?

Swingbench 2.6 supports Oracle 12c and I have been using it for 12c successfully. But I want to use it with Oracle 18c for testing purposes. In case of using different wizards from swingbench\winbin ...
0
votes
0answers
456 views

exceeds the maximum allowed database size when export database oracle 18c

I have worked on Oracle Database 18c Express Edition, while I try to export database schema by using expd command, I have an issues ORA-12954: The request exceeds the maximum allowed database size ...
1
vote
1answer
439 views

APEX_LISTENER and APEX_REST_PUBLIC_USER are not being created

I am trying to install APEX 19.1 on ORACLE XE 18c but the problem is that APEX_LISTENER and APEX_REST_PUBLIC_USER are not being created. While I execute apex_rest_config.sql script via sqlplus, an ...
1
vote
0answers
84 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
977 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 ...
1
vote
2answers
831 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
438 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 ...
1
vote
1answer
446 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
196 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
229 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 ...
2
votes
1answer
735 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
1k 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 ...
2
votes
1answer
3k 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
1k 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
131 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
9k 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 ...