Questions tagged [oraclexe]

The tag has no usage guidance.

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

Oracle-xe18-18c configure fails

Following this article, I'm trying to install Oracle-XE on CentOS. However at the step /etc/init.d/oracle-xe-18c configure I get stuck with this: ************ Prepare for db operation 7% complete ...
Arnaud F.'s user avatar
  • 133
1 vote
1 answer
1k views

Creating javaroles in Oracle 11g XE

I have installed Oracle 11g Express Edition in my system.I want to create user who has got the role javauserpriv. After creating the user I ran the following command grant javauserpriv to dbuser(new ...
sathish kumar's user avatar
1 vote
1 answer
759 views

Installing Oracle XE in CentOS 6.5

Is it possible to Install Oracle XE in CentOS 6.5? If yes, is there a guide for dummies out there how to install XE in CentOS 6.5, without using Virtual Machine such as VirtualBox. Thanks for any ...
Charlesliam's user avatar
1 vote
2 answers
3k views

how to do ssh tunneling to oracle server without ssh server inside?

Almost all of the google result for my problem has different case about tunneling connection to my oracle server, they usually has ssh server/client within the oracle server but i have another case ...
kreamik's user avatar
  • 131
0 votes
1 answer
126 views

Can Blackboard use Oracle XE?

Can Blackboard Learn be installed on Oracle's Express Edition? When running the Blackboard install script, it executes to completion and then spits out the message that Blackboard Learn was not ...
David Hodnett's user avatar
0 votes
2 answers
14k views

Why can't I grant exec on dbms_lock.sleep() OR create a procedure using it (but I can run it fine on its own)

I am trying to write a small bit of PL/SQL that has a non-CPU burning sleep in it. The following works in sqldeveloper begin dbms_lock.sleep(5); end; BUT (as the same user), I can't do the ...
Richard Green's user avatar
1 vote
0 answers
1k views

Oracle Database 11g Express Edition - Built-in backup files-to-be-saved

Considering the built-in 'Backup Database' script (backup.bat) that comes with a new instalation of the Oracle Express 11g Edition, after finishing the script execution, what folders/files should be ...
J.Hudler's user avatar
  • 151
1 vote
0 answers
776 views

migrate 10g xe to 11g xe

The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be ...
zapping's user avatar
  • 183
3 votes
2 answers
35k views

How can I resolve Oracle 11g XE connection failure straight after installation?

I have just installed Oracle 11g XE on a Windows 7 VirtualBox VM, using all the default options. "Getting Started" fails When I click on Getting Started I get taken to http://127.0.0.1:8080/apex/f?...
lofidevops's user avatar
  • 1,325
1 vote
1 answer
883 views

How can I change NLS for an Oracle XE installed on Ubuntu 10.04?

I am trying to import a dump and I get the following message: Export file created by EXPORT:V10.02.01 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set ...
Petros's user avatar
  • 113
1 vote
1 answer
1k views

Install Oracle XE on a Centos Virtual Machine

I get the following error trying to install Oracle XE on a CentOS 5 virtual machine: You have insufficient diskspace in the destination directory (/usr/lib/oracle) to install Oracle Database 10g ...
Peter Bratton's user avatar
1 vote
2 answers
36k views

sqlplus CONNECT command with an '@' symbol in the password

I'm trying to connect to an Oracle XE database using sqlplus.exe with the following command: CONNECT SYSTEM/password@ Yes that's right, the '@' symbol is the last letter of the password, and needs ...
ian_scho's user avatar
  • 113
0 votes
2 answers
264 views

Migration from Oracle 10gR2 to Oracle XE

One of my application currently uses Oracle 10gR2 as the backend, with PL/SQL Stored Procedures, Triggers, Sequences, etc. I want to migrate to Oracle XE. Can this edition serve as the primary ...
M.N's user avatar
  • 337
2 votes
1 answer
15k views

How to create separate tablespaces in Oracle XE?

Creating separate tablespaces is possible in expensive versions of Oracle, but I can't seem to find a way to do so with the free version Oracle XE. The administration interface just has a "View ...
Nicolas Raoul's user avatar
3 votes
4 answers
17k views

Oracle XE 10g: missing file spfileXE.ora (Windows Server 2008 64 bit)

I'm having problems installing Oracle XE 10g on a Windows Server 2008 64 bit machine. After the installation the connection to the database administration page http://127.0.0.1:8080/apex fails. If ...
Paolo Tedesco's user avatar
0 votes
2 answers
4k views

How to get a consistent export with Oracle Data Pump?

I'm trying to obtain a consistent export (with data pump) from an schema emulating the CONSISTENT=Y. Currently I'm executing data pumb in this way: '/ AS SYSDBA' schemas=arrels dumpfile=arrels.dmp ...
FerranB's user avatar
  • 1,382