The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
74 views

CentOS 6.5 with Oracle XE in virtualenv

I'm running a CentOS 6.5 with installed Oracle-XE. I created a virtualenv where I run my Django-NGINX-Gunicorn Webserver. Locally I can access XE via SQL Developer but when I try to access the ...
1
vote
1answer
249 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 ...
1
vote
2answers
271 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 ...
0
votes
1answer
55 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 ...
0
votes
2answers
2k 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 ...
1
vote
0answers
310 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 ...
1
vote
0answers
293 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 ...
3
votes
2answers
11k 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 ...
1
vote
1answer
592 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 ...
1
vote
1answer
845 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 ...
0
votes
1answer
1k 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 ...
0
votes
2answers
209 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 ...
2
votes
1answer
9k 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 ...
2
votes
1answer
7k 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 ...
0
votes
2answers
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 ...