Questions tagged [oracle-xe]

Oracle Database Express Edition (Oracle Database XE).

Filter by
Sorted by
Tagged with
0 votes
1 answer
256 views

Oracle Database - Can I create a table and reserve some space for it?

Business Case: We have an application that creates backups of its data. Each time that a user creates a backup, a registry is created in another table (like a historical table) ... Right now, we ...
Carlitos Way's user avatar
0 votes
0 answers
772 views

Set lsnrctl on Oracle XE 21C to listener.ora in file

I installed Oracle XE 21C on an old laptop running Oracle Linux 8.6. I followed the official documentation without getting any errors. I am trying to set the lsnrctl to the one located in /opt/oracle/...
Smooth Researcher's user avatar
0 votes
1 answer
153 views

Database alters MOUNT mode after reboot

We have Oracle XE 10.2.0.1.0 running on CentOS 6.9. The Database works stable all the time, except the system reboots. If reboot command is issued in the OS terminal, the Database enters MOUNT mode. ...
Olga Pshenichnikova's user avatar
0 votes
1 answer
1k views

On Oracle 21c XE, what should ORACLE_HOME and TNS_ADMIN be set to?

In my Windows Oracle 21c XE installation I have the product installed under: C:\Oracle\product\21c Below that there is: dbhomeXE which contains the bin directory and also network. However, I also ...
rghome's user avatar
  • 121
0 votes
2 answers
118 views

HammerDB says about 0 Oracle TPM

Have a good day, guys and girls!) Using HammerDB for Oracle benchmarking, I have this connection settings: diset connection instance IP_of_server:1521/XEPDB1 ... this messages from start and end ...
user avatar
0 votes
1 answer
158 views

Oracle XE fails on HammerDB benchmark

I have Oracle XE 21c and HammerDB 4.4. The task is to benchmark database. Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 Well, because of that I've done the ...
user avatar
0 votes
1 answer
387 views

Cannot connect to a pluggable database via IDE

I have an Oracle XE database on computer1. When I try to connect to it via sqlplus from computer2, it works fine, for both cdb and pdb connections; e.g.: rlwrap sqlplus timon@//192.168.0.115:9121/...
Timofey Pasichnik's user avatar
0 votes
0 answers
136 views

SQL*Plus 18/19 on Windows: Cannot access SQL scripts

I have this very strange observation on my Windows 10x64 machine: Given the following script file (file name test.sql): DEFINE SYS_NAME = &1 DEFINE SYS_PWD = &2 DEFINE ORACLE_HOME = &3 ...
AxD's user avatar
  • 133
0 votes
0 answers
499 views

Oracle XE 11.2.0 data pump expdb works on but impdb doesn't on Windows 10

New to Oracle DB administration here. I have a fresh localhost installation of Oracle XE 11.2.0 (x64 installation from here) on my computer using Windows 10 64-bit. I am able to connect to the DB ...
Nikolas Charalambidis's user avatar
0 votes
1 answer
131 views

B2B application: users has its own users

B2B Scenario I am trying is that: The following Roles exists in the system: Super Admin Super Admin Staff Owner (client) Admin (owner i.e. client and creates admin to define sales counters) Sales ...
Murteza's user avatar
0 votes
2 answers
5k views

ORA 01031 Insufficient privileges on GRANT SELECT on ALL_CATALOG to a user as system user

Command: GRANT SELECT ON ALL_CATALOG TO appdbuser * Error: ERROR at line 1: ORA-01031: insufficient privileges PROBLEM: I want my Oracle XE system user (<-important) to be able ...
Ozair Kafray's user avatar
0 votes
2 answers
625 views

How to connect to pluggable database using ipc in Oracle XE 18c?

Here is my listener configuration: LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 20-NOV-2020 20:01:25 Copyright (c) 1991, 2018, Oracle. All rights reserved. Connecting to (DESCRIPTION=(...
user762750's user avatar
0 votes
1 answer
262 views

Cannot login oracle database using other users

I'm currently using oracle xe c18. I can login using sqlplus / AS SYSDBA as oracle user. However, the command does not work for other users. It always shows an error ORA-01017: invalid username/...
user762750's user avatar
3 votes
1 answer
2k 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). ...
Manngo's user avatar
  • 2,719
1 vote
1 answer
381 views

Why is the schema/structure dump so slow? [closed]

I'm using Rails 6 with activerecord-oracle_enhanced-adapter adapter for Oracle 11 XE database. At the beginning of the project I was working with Postgres, but due to customer requirements I had to ...
Grizz's user avatar
  • 11
0 votes
1 answer
683 views

Making an Oracle XE instance network wide available

Im fairly new to Oracle so please bear with me. I want to install an Oracle 18c XE DBMS on a server and access it's databases remotely via DBeaver. First of all there is some confusion on which client ...
SweetPotato's user avatar
0 votes
2 answers
336 views

Number of threads in Oracle XE 18c

I just installed Oracle XE 18c ... In this page, they list the available features/resources. One of them is the use of two CPU threads ... But, in practical terms, what does this mean? Does this ...
Carlitos Way's user avatar
2 votes
2 answers
6k 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 ...
Carlitos Way's user avatar
0 votes
1 answer
636 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-...
user987376746090's user avatar
0 votes
1 answer
6k 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-...
user987376746090's user avatar
0 votes
1 answer
134 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/...
halfwind22's user avatar
0 votes
0 answers
37 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 ...
Gabriel Robaina's user avatar
8 votes
2 answers
1k views

Is it possible to accidentally use some paid feature in Oracle XE database while in an Enterprise environment?

IT in my org are wary about approving me installing Oracle Express Edition. https://www.oracle.com/database/technologies/xe-downloads.html Their reasoning is that apparently some DBA once said that ...
Jack Garbiec's user avatar
0 votes
1 answer
520 views

How do I recreate the XE database in Oracle 11g Express?

My Oracle XE database was useless mess of unused tables etc. Using SqlPlus and several google results, I finally managed to drop the XE database, but now when I connect with SqlPLus IO cannot create ...
ProfK's user avatar
  • 404
0 votes
1 answer
402 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 ...
Griffau's user avatar
  • 31
2 votes
1 answer
3k 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 ...
kledi sejko's user avatar
1 vote
1 answer
68 views

Access oracle database from control file

When I asked a client for a copy of his database he sent me a .ctl file, it seems it is a control file of an Oracle database. I have no experience in Oracle, I'm a SQL Server guy. I have installed an ...
Alfz's user avatar
  • 11
0 votes
0 answers
105 views

Oracle Error when replacing package body

I get the following error when replacing a package body: Fehlerbericht - ORA-00604: error occurred at recursive SQL level 1 ORA-12953: The request exceeds the maximum allowed database size of 11 GB ...
Adder's user avatar
  • 126
0 votes
1 answer
542 views

Oracle XE 18c connects with sqlplus, but not DB GUI apps

I installed Oracle XE 18c on RHEL on my laptop, got it configured, created connections with two applications (DBeaver and DbVisualizer) as well as able to connect with sqlplus. It all worked "...
saquaro's user avatar
0 votes
2 answers
406 views

Migration from MySQL to Oracle generates empty tables

I'm using SQL Developer to migrate a database from MySQL 5.7 to Oracle 18c XE. The problem is that the tables are generated but empty, even though I'm specifying that the data should move online. I ...
ps0604's user avatar
  • 51
1 vote
1 answer
7k views

ORA-01017 Invalid Username/Password in SQL Developer

I installed Oracle 18c XE and SQL Developer 18.4, both are the latest. Logged in with SYSTEM and created a user vbk in SQL Developer. I see the user running select * from dba_users, but when I try ...
ps0604's user avatar
  • 51
0 votes
1 answer
3k 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 ...
ps0604's user avatar
  • 51
1 vote
2 answers
6k views

Oracle XE installation aborts with no error explanation

I have downloaded Oracle XE 18c for Windows 64 bit, and tried to install it on a Windows 10 machine. I checked the SHA-256 checksum and it's correct. The installation starts fine, but when it's ...
ps0604's user avatar
  • 51
1 vote
1 answer
3k views

Oracle-xe on Ubuntu 18.04 - Installation and impdp

Setup: 10 GB partition ext3 mounted at /u01 5 GB swap Oracle-xe oracle-xe-11.2.0-1.0.x86_64.rpm - installed with alien and then dpkg Followed instructions from https://community.oracle.com/thread/...
Piotr Dajlido's user avatar
0 votes
1 answer
9k views

How to execute sqlplus by root using sudo in linux?

Scenario: *oracle xe11g r2 is installed( and runs properly when logged in as oracle). *logged in as user, root *added root to groups oinstall and dba as follows: #useradd -G oinstall root #useradd -...
AVA's user avatar
  • 167
1 vote
1 answer
8k views

ORA-39001: ORA-39000: ORA-31640: ORA-27041: and Linux-x86_64 Error: 13: Permission denied [closed]

I used this command to export data: expdp gsw/password DIRECTORY=gsw DUMPFILE=gsw.dmp logfile=gsw.log SCHEMAS=GSW Now importing this to other server as: [root@linux gsw]# impdp gsw/password ...
Raakh's user avatar
  • 13
0 votes
1 answer
445 views

Creating an insert trigger on views

My table definitions look like this: I've created a view as: users_questions(qid,username,question) I want to create an instead of trigger on the view which puts the data going to be inserted on ...
Surya Bhusal's user avatar
-1 votes
2 answers
1k views

Setting up Oracle XE on Linux

I'm trying to set up oracle-xe on my Linux machine. I just need an environment to play with Oracle SQL; this is not for production. When I try to start SQLPLUS I keep getting one of the following ...
akkarin's user avatar
  • 103
0 votes
1 answer
931 views

Migrate database through database link

There's a database called FOO in an Oracle XE 10g server that's due to be decommissioned (old.example.com). I've been asked to migrate it to some other Oracle XE 11g server (new.example.com). Both ...
Álvaro González's user avatar
1 vote
2 answers
907 views

ORA-04031: unable to allocate X bytes of shared memory

Trying to start oracle service, shows me the follow error: I have the follow SPFILEXE.ORA: Im using ORACLE XE, but really I don't know which parameter change and what should be the value. Please ...
Freddy Castelblanco Macias's user avatar
2 votes
1 answer
140 views

Using Oracle XE, how do I create a CASE statement To return a specific date

I am Trying to create a view based on a business calendar table called Business Payment Calendar view with two new calculated columns: Payment Warning Date (Payment_Warning_Date) Payment Due Date (...
LargeMarge's user avatar
0 votes
1 answer
2k views

Resolving TNS Permision Denied for XE on Windows 7

I am working with Oracle 11g XE on a Win7 laptop. I have had this up and running without issue for more nearly two years. Went about a month without connecting, and the next time I tried to I got “...
Rozwel's user avatar
  • 101
0 votes
1 answer
604 views

Upgrade Oracle APEX 4.0.2 to 5.1.1 error

I installed Oracle 11g XE on CentOS 7 and everything went fine. I wanted to upgrade APEX to the latest version and followed instructions in Upgrading Oracle Application Express within Oracle Database ...
Dejan Borkovic's user avatar
2 votes
1 answer
1k views

How to export a single schema from Oracle EE to Oracle XE?

I would like to export a schema (DDL or DDL+data) from Oracle EE (Enterprise Edition) to Oracle XE (Express Edition) for development purpose (in our case: for use as test databases for Java developers)...
user3078523's user avatar
3 votes
1 answer
4k views

How does Oracle Application Express connect to the database?

I'm mocking up some options for a simple, internal reporting front-end for an Oracle database. I have Oracle XE 11R2 on a separate testing machine, and am going through a tutorial on making a simple ...
User1974's user avatar
  • 1,437
0 votes
1 answer
8k views

ORA-47500: XE edition memory parameter invalid or not specified

Recently i tried to increase the memory_max_target in Spfile as well through cmd.But After restart the instance it shows "ORA-47500: XE edition memory parameter invalid or not specified".I couldn't ...
luvking's user avatar
  • 33
0 votes
1 answer
55 views

Does Oracle optimize database while you use? [closed]

I have a 10gb database, that the queries were running very fast on Oracle XE. I exported this db with expdp and imported on a new server Oracle 12c (hardware better than original, much more RAM and ...
John John Pichler's user avatar
0 votes
1 answer
789 views

Error when installing JServer JVM in Oracle XE on Linux AMI

I'm trying to install OJVM on Oracle 11g (11.2.0.2.0) on Amazon Linux AMI (20016.09). And I'm getting the following error after running initjvm.sql: PL/SQL procedure successfully completed. create ...
Bixxman's user avatar
0 votes
1 answer
1k views

missing scott schema in Oracle XE [duplicate]

I have downloaded Oracle XE 11.2 and successfully installed on my Windows machine. But, I didn't find Scott schema in it. During installation, I didn't get any option where it asked to create sample ...
Ravi's user avatar
  • 1,545
1 vote
2 answers
515 views

Restoring 40 GB Oracle backup to get db objects into Oracle 11g XE

I have backup of oracle database size is almost 40 GB.This 40GB database backup contains lots of data that I don't care about. I just wanted to restore DB objects like tables structure, procedures, ...
Aarif Shaikh's user avatar