Oracle Database Express Edition (Oracle Database XE) is an entry-level, small-footprint database, free to develop, deploy, and distribute; fast to download; and simple to administer.

learn more… | top users | synonyms

0
votes
1answer
32 views

sqlplus not connecting to Oracle XE 11g

I installed Oracle XE 11g on my Ubuntu in vmware fusion. The oracle installation is all went fine but I am not able to connect the oracle database using sqlplus. I am getting this exception: $ ...
0
votes
1answer
72 views

migration of oracle xe 10 to xe 11 fails with wrong paths used in the import

I'm following the documentation to upgrade an OracleXE 10.2 database to OracleXE 11.2. The export succeeded without any problem, the import (on another machine with XE 11) fails though. The log file ...
0
votes
1answer
2k 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
64 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
59 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
8k 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
222 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
485 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
296 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
2k 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
158 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 ...