Questions tagged [oraclexe]
The oraclexe tag has no usage guidance.
16
questions
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?...
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...