Questions tagged [oracle-xe]

Question 1

I am trying to setup a local Oracle database with 23ai, but I fail at the very basics. I am trying to connect to the DB after installation, but get ORA-12514: Cannot connect to database. Service FREE ...

Question 2

I am trying to make the jump from MS SQL Server and recently downloaded OracleXE. Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production . My version in SQL Plus lists as 21.3.0.0.0 and I ...

Question 3

I'm using Oracle 21c XE for an application with a database size of less than 0.5 GB. However, I’m encountering the error: ** ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT. I’...

Question 4

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 ...

Question 5

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/...

Question 6

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. ...

Question 7

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 ...

Question 8

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 ...

Question 9

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 ...

Question 10

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/...

Question 11

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 ...

Question 12

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 ...

Question 13

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 ...

Question 14

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 ...

Question 15

Stack Exchange Network

Questions tagged [oracle-xe]

Setting up Oracle DB 23 ai free on Windows

Question about Oracle XE and pluggable databases

My PGA getting filled up quickly in oracle 21 XE

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

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

Database alters MOUNT mode after reboot

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

HammerDB says about 0 Oracle TPM

Oracle XE fails on HammerDB benchmark

Cannot connect to a pluggable database via IDE

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

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

B2B application: users has its own users

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

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

Hot Network Questions