Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [oraclexe]

16 questions
3
votes
4 answers

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 I run sqlplus / as sysdba I get the error…
Paolo Tedesco
  • 1,296
  • 7
  • 16
  • 23
3
votes
2 answers

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?p=4950 which fails. After some browsing I came…
lofidevops
  • 1,325
  • 4
  • 13
  • 23
2
votes
1 answer

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 tablespaces" button, where I can see four tablespaces,…
Nicolas Raoul
  • 1,334
  • 7
  • 22
  • 43
1
vote
1 answer

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 user) and I got the below error. QL Error:…
sathish kumar
  • 111
  • 3
1
vote
1 answer

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 response
Charlesliam
  • 113
  • 5
1
vote
2 answers

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 with followed illustration: Web Server(port80) and…
kreamik
  • 131
  • 1
  • 4
1
vote
0 answers

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 copied to an external media ('XCOPY' Backup) so…
J.Hudler
  • 151
  • 1
  • 1
  • 6
1
vote
0 answers

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 done from 10g and then data pump import it to…
zapping
  • 183
  • 1
  • 9
1
vote
1 answer

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 import server uses WE8MSWIN1252 character set…
Petros
  • 113
  • 4
1
vote
1 answer

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 Express Edition. The installation requires at least…
Peter Bratton
  • 141
  • 5
1
vote
2 answers

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 escaping. :( Many thanks. See also Oracle pl-sql…
ian_scho
  • 113
  • 1
  • 1
  • 7
0
votes
1 answer

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 Copying database files 8% complete [WARNING]…
Arnaud F.
  • 133
  • 7
0
votes
1 answer

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 installed, but doesn't give a specific reason. Looking…
David Hodnett
  • 139
  • 2
  • 6
0
votes
2 answers

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 following: create or replace procedure sleep(seconds in…
Richard Green
  • 91
  • 1
  • 1
  • 6
0
votes
2 answers

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 nologfile=y flashback_time='2009-06-03 12:00:02'…
FerranB
  • 1,372
  • 2
  • 18
  • 28
1
2