Oracle Database Express Edition (Oracle Database XE).

learn more… | top users | synonyms

0
votes
2answers
91 views

Connect MariaDB and Oracle XE

I got an existing MariaDB running on a CentOS 7, I want to add a reporting layer on top of it, I therefore installed an Oracle 11g XE with APEX 5. My goal is to link those two databases in order for ...
0
votes
1answer
5k views

ORA-01033: ORACLE initialization or shutdown in progress using Oracle Express

I am using Oracle Database 11g Express Edition. I'm on Windows 7-64Bit I get this error when trying to access the database: ORA-01033: ORACLE initialization or shutdown in progress I set up the ...
-1
votes
1answer
89 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
2
votes
0answers
69 views

Data not showing in English, unless you click on it - In sqldeveloper

I have installed OracleXE and imported data into it. From SQLPLUS, I can query the data and it all shows up in English. However, in SQLDEVELOPER, if I look at the data, it's in a nonsense format, ...
2
votes
0answers
10k views

Oracle XE TNS Listener fails to start

I freshly installed Oracle XE 11.2.0.2.0 and found out that the TNS Listener service fails to start. At first I tried to start the Windows service by hand. After the failure this is the entry in the ...
1
vote
0answers
241 views

Set session query timeout

When I develop complex queries and I make a mistake (e.g. a wrong join that will make the query run for hours or days) Oracle becomes unusable (you can't even start a local SYS session from SQL*Plus). ...
1
vote
0answers
108 views

Does oracle workspace manager work with oracle xe 11g

According to this forum it can be using a patch but I need a support identifier to access patches. https://community.oracle.com/thread/340084?start=0&tstart=0 This describes how to install ...
1
vote
0answers
349 views

Trouble connecting to Oracle XE running in Centos Virtual Box

I have a centos vm that I run using virtual box. I installed Oracle XE on this vm, and am now having trouble connecting to it from my SQL Developer running on my host machine (OS X). Things I ...
1
vote
0answers
659 views

SQLPlus times out when connecting to an Oracle XE database on another PC

I'm having the strangest issue. I have a very basic (I think) setup of an Oracle 11G database on one Hyper-V VM, and the Oracle 11G client on another VM. Although I'm able to access the database on ...
1
vote
0answers
355 views

Populate database column with drop-down menu item

I'm quite new to Apex and Oracle in general, but I would like to know how to populate a database column with the data from the drop-down list Currently I'm not getting further than simply creating ...
0
votes
0answers
33 views

How do I recover my data in Oracle

I am using Oracle 11 XE, I have some small applications on this, by mistake I have uninstalled Oracle from the system. But I can see the data files still existing in the server in this folder ...
0
votes
0answers
33 views

Login as SYSTEM in web console

I've installed Oracle XE 11g on Windows Server. I've set a password for SYS/SYSTEM when prompted, I've opened port 8080 to receive incoming connections and http://example.com:8080/apex loads fine. In ...
0
votes
0answers
4k views

intermittent TNS-12533: TNS:illegal ADDRESS parameters

I am running a windows XP (SP3) VM in virtualbox, on which I host Oracle XE. It has been running fine like this for a couple of years, but recently I am seeing some strange problems. My client ...
0
votes
0answers
267 views

increased tablespace but dba_tablespace_usage_metrics order shows same

Although I appear to have solved the problem of the tablespace being full I am perplexed that after altering the the datafile size that the tablespace size has remained the same. What is it that I ...