Questions tagged [oracle-18c]
Oracle Database 18c. Please also tag oracle for search purposes.
66
questions
1
vote
0answers
35 views
TNS-00534: Failed to grant connection ownership to child
when I tried to connect to my oracle instance with sql developer, I see this error in logs
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-...
1
vote
0answers
65 views
Error in starting oracle 18c express editiom
I have little problem with starting oracle 18c express edition, when I tried to startup, it wrote me the error ORA-00205: error in identifying control file, check alert log for more info
SQL> ...
0
votes
1answer
23 views
Oracle RAC 18c Patching - datapatch
After patching GI Home and DB Home simultaneously using command:
.oraenv
+ASM1
opatchauto apply /patchlocation
Should i run ./datapatch from DB home or GI home? Or it doesn't matter from which home? ...
0
votes
1answer
32 views
Why is the schema name necessary here and how to compile without it
I'm working on an Oracle Forms 11g application linked with an Oracle 18c database and I stumbled upon a strange error when compiling my form.
Here's a snippet to illustrate the problem (I changed the ...
1
vote
1answer
17 views
Restricting input from two other tables
I'm trying to create the table CanTeach but I am getting an error ERROR 1005 (HY000): Can't create table 'mydb'.'CanTeach' (errno: 150 "Foreign key constraint is incorrectly formed"). ...
0
votes
2answers
30 views
Why does selecting an attribute of an Oracle object require an alias?
My GIS software has an Oracle 18c object type called ST_GEOMETRY.
The object type has attributes:
The attributes of the spatial type represent the following
information:
Entity: The type of ...
0
votes
1answer
44 views
Error when using DBCA to create database Oracle XE 18c
I am trying to create a new database using dbca.
Windows 10.
Please help me to find solution.
Here is the log
1
vote
1answer
457 views
Error when using DBCA to create database
I am using Oracle Database XE (18c). The install completed without any error however, when I try to create a database using dbca it shows error: java.lang.NullPointerException.
The log is:
https://...
-1
votes
3answers
214 views
Function: if either x or y are null, return null
I'm looking for an Oracle 18c function that evaluates to null if either of two variables is null.
The Constraints: (details here)
The function/expression can't contain spaces (so CASE won't work).
I ...
0
votes
2answers
156 views
Materialized view with FAST refresh on remote table: How to include a GEOMETRY column?
I want to create a fast refresh materialized view (18c) on a remote table. The MV would also have a GEOMETRY column.
Options for the GEOMETRY column datatype include:
ESRI's proprietary ...
0
votes
2answers
45 views
Materialized View: What is the Update Trigger property?
I've created a materialized view in an Oracle 18c database.
When I look at the Info tab of the materialized view in Toad, I see that there is a property called Update Trigger.
What does the Update ...
1
vote
1answer
45 views
ORA00918 - Column Ambiguously defined [closed]
I can't find what's causing the error.
All columns are qualified by their table names.
SELECT
trunc(PAT_ENC.CONTACT_DATE,'MONTH') as MonthYear,
appt.name,
PATIENT.PAT_NAME,
patient.pat_mrn_id,
...
0
votes
1answer
43 views
Oracle 19c Standard Edition RPM installation
I'm wondering if it's possible to install Oracle Standard Edition from RPM, not Enterprise Edition. It's possible to choose edition when you do 'runInstaller', is it possible to set some parameter ...
0
votes
1answer
136 views
Materialized view not purging (over dblink via view)
I've created a materialized view between a primary system (Oracle 18c) and an external system (Oracle 19c):
create materialized view primary_system.workorder_mv
build immediate
refresh force
on ...
0
votes
1answer
16 views
Select parent rows and include cost of children
I have a WORKORDER table that has parent and child WOs in it:
with workorder as (
select 'WO37342' as wonum, null as parent, 297.36 as actlabcost, 200 as actmatcost, 0 as actservcost, 0 as ...
0
votes
2answers
68 views
Check for spaces or zeros in all columns in all tables
I have multiple tables in an Oracle schema that have columns with incorrect values:
Number columns where the value is zero, instead of null.
Text columns where the value is a space, instead of null.
...
3
votes
1answer
275 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
106 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
41 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
35 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
45 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
29 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
41 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
203 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
51 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
44 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
13 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
19 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
168 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
976 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 ...
1
vote
2answers
941 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
248 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
34 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
302 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
41 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
574 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
53 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
184 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
105 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
296 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
941 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
27 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
23 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
101 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
190 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
128 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
2answers
5k 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
164 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
114 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
120 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();
...