Questions tagged [oracle-xe]
Oracle Database Express Edition (Oracle Database XE).
79
questions
7
votes
2answers
849 views
Is it possible to accidentally use some paid feature in Oracle XE database while in an Enterprise environment?
IT in my org are wary about approving me installing Oracle Express Edition.
https://www.oracle.com/database/technologies/xe-downloads.html
Their reasoning is that apparently some DBA once said that ...
0
votes
1answer
36 views
How do I recreate the XE database in Oracle 11g Express?
My Oracle XE database was useless mess of unused tables etc. Using SqlPlus and several google results, I finally managed to drop the XE database, but now when I connect with SqlPLus IO cannot create ...
0
votes
1answer
26 views
Unable to connect to oracle user
I have hit a rather frustrating snag in that after installing Oracle 18c.
I have been unable to successfully create a user and then connect to it.
More precisely I can create the user but the ...
1
vote
1answer
110 views
APEX_LISTENER and APEX_REST_PUBLIC_USER are not being created
I am trying to install APEX 19.1 on ORACLE XE 18c but the problem is that APEX_LISTENER and APEX_REST_PUBLIC_USER are not being created. While I execute apex_rest_config.sql script via sqlplus, an ...
0
votes
0answers
19 views
How do I fix problem connecting to Oracle APEX with Express Edition 11g
These are the results of host lsnrctl start which is being run as sys as sysdba
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 16-AUG-2019
15:33:27
Copyright (c) 1991, 2014, Oracle. ...
0
votes
0answers
19 views
Importing dump file after dropping database
I was trying to import a dump file and for some reason i decided to
drop database;
so oracle got shut down and when I tried to start it, it said no pfile or spfile were there so I created them using ...
1
vote
1answer
39 views
Access oracle database from control file
When I asked a client for a copy of his database he sent me a .ctl file, it seems it is a control file of an Oracle database.
I have no experience in Oracle, I'm a SQL Server guy.
I have installed an ...
0
votes
0answers
47 views
Oracle Error when replacing package body
I get the following error when replacing a package body:
Fehlerbericht -
ORA-00604: error occurred at recursive SQL level 1
ORA-12953: The request exceeds the maximum allowed database size of 11 GB
...
0
votes
1answer
207 views
Oracle XE 18c connects with sqlplus, but not DB GUI apps
I installed Oracle XE 18c on RHEL on my laptop, got it configured, created connections with two applications (DBeaver and DbVisualizer) as well as able to connect with sqlplus. It all worked "...
0
votes
1answer
101 views
Migration from MySQL to Oracle generates empty tables
I'm using SQL Developer to migrate a database from MySQL 5.7 to Oracle 18c XE. The problem is that the tables are generated but empty, even though I'm specifying that the data should move online. I ...
1
vote
1answer
2k views
ORA-01017 Invalid Username/Password in SQL Developer
I installed Oracle 18c XE and SQL Developer 18.4, both are the latest.
Logged in with SYSTEM and created a user vbk in SQL Developer.
I see the user running select * from dba_users, but when I try ...
0
votes
1answer
766 views
Cannot create an additional database in Oracle 18c XE
Creating a new database in Oracle 18c XE throws this error, does this mean that I can only use the database created by the installation?
ORA-00442: Oracle Database Express Edition (XE) single ...
0
votes
1answer
2k views
Oracle XE installation aborts with no error explanation
I have downloaded Oracle XE 18c for Windows 64 bit, and tried to install it on a Windows 10 machine. I checked the SHA-256 checksum and it's correct.
The installation starts fine, but when it's ...
1
vote
1answer
1k views
Oracle-xe on Ubuntu 18.04 - Installation and impdp
Setup:
10 GB partition ext3 mounted at /u01
5 GB swap
Oracle-xe oracle-xe-11.2.0-1.0.x86_64.rpm - installed with alien and then dpkg
Followed instructions from https://community.oracle.com/thread/...
0
votes
1answer
2k views
How to execute sqlplus by root using sudo in linux?
Scenario:
*oracle xe11g r2 is installed( and runs properly when logged in as oracle).
*logged in as user, root
*added root to groups oinstall and dba as follows:
#useradd -G oinstall root
#useradd -...
1
vote
1answer
3k views
ORA-39001: ORA-39000: ORA-31640: ORA-27041: and Linux-x86_64 Error: 13: Permission denied [closed]
I used this command to export data:
expdp gsw/password DIRECTORY=gsw DUMPFILE=gsw.dmp logfile=gsw.log SCHEMAS=GSW
Now importing this to other server as:
[root@linux gsw]# impdp gsw/password ...
0
votes
1answer
243 views
Creating an insert trigger on views
My table definitions look like this:
I've created a view as:
users_questions(qid,username,question)
I want to create an instead of trigger on the view which puts the data
going to be inserted on ...
-1
votes
2answers
718 views
Setting up Oracle XE on Linux
I'm trying to set up oracle-xe on my Linux machine. I just need an environment to play with Oracle SQL; this is not for production.
When I try to start SQLPLUS I keep getting one of the following ...
0
votes
1answer
439 views
Migrate database through database link
There's a database called FOO in an Oracle XE 10g server that's due to be decommissioned (old.example.com). I've been asked to migrate it to some other Oracle XE 11g server (new.example.com). Both ...
1
vote
2answers
567 views
ORA-04031: unable to allocate X bytes of shared memory
Trying to start oracle service, shows me the follow error:
I have the follow SPFILEXE.ORA:
Im using ORACLE XE, but really I don't know which parameter change and what should be the value.
Please ...
2
votes
1answer
112 views
Using Oracle XE, how do I create a CASE statement To return a specific date
I am Trying to create a view based on a business calendar table called Business Payment Calendar view with two new calculated columns:
Payment Warning Date (Payment_Warning_Date)
Payment Due Date (...
0
votes
1answer
988 views
Resolving TNS Permision Denied for XE on Windows 7
I am working with Oracle 11g XE on a Win7 laptop. I have had this up and running without issue for more nearly two years. Went about a month without connecting, and the next time I tried to I got “...
0
votes
1answer
510 views
Upgrade Oracle APEX 4.0.2 to 5.1.1 error
I installed Oracle 11g XE on CentOS 7 and everything went fine.
I wanted to upgrade APEX to the latest version and followed instructions in Upgrading Oracle Application Express within Oracle Database ...
2
votes
1answer
884 views
How to export a single schema from Oracle EE to Oracle XE?
I would like to export a schema (DDL or DDL+data) from Oracle EE (Enterprise Edition) to Oracle XE (Express Edition) for development purpose (in our case: for use as test databases for Java developers)...
3
votes
1answer
2k views
How does Oracle Application Express connect to the database?
I'm a non-DBA (public works guy) mocking up some options for a simple, internal reporting front-end on an Oracle database.
I have Oracle XE 11R2 on a separate testing machine, and am going through a ...
0
votes
1answer
3k views
ORA-47500: XE edition memory parameter invalid or not specified
Recently i tried to increase the memory_max_target in Spfile as well through cmd.But After restart the instance it shows "ORA-47500: XE edition memory parameter invalid or not specified".I couldn't ...
0
votes
1answer
45 views
Does Oracle optimize database while you use? [closed]
I have a 10gb database, that the queries were running very fast on Oracle XE.
I exported this db with expdp and imported on a new server Oracle 12c (hardware better than original, much more RAM and ...
0
votes
1answer
506 views
Error when installing JServer JVM in Oracle XE on Linux AMI
I'm trying to install OJVM on Oracle 11g (11.2.0.2.0) on Amazon Linux AMI (20016.09). And I'm getting the following error after running initjvm.sql:
PL/SQL procedure successfully completed.
...
0
votes
1answer
670 views
missing scott schema in Oracle XE [duplicate]
I have downloaded Oracle XE 11.2 and successfully installed on my Windows machine. But, I didn't find Scott schema in it. During installation, I didn't get any option where it asked to create sample ...
1
vote
2answers
385 views
Restoring 40 GB Oracle backup to get db objects into Oracle 11g XE
I have backup of oracle database size is almost 40 GB.This 40GB database backup contains lots of data that I don't care about. I just wanted to restore DB objects like tables structure, procedures, ...
1
vote
1answer
483 views
Connection error while connecting to Oracle XE
This just started happening this morning, and I'm not sure what the cause is. IT just installed some sort of Windows update but I'm not sure if this is related to the issue. Basically, when I try to ...
2
votes
1answer
3k views
impdp expects wrong file path
Summary:
I'm using expdp / impdp to export a database from a test / demo database (Oracle 11.2) and import it into an instance of Oracle Express (11g) on my own machine.
The import fails because ...
1
vote
1answer
39 views
Oracle XE/SQLPlus query display more items
Is there a setting to allow Oracle XE/SQLPlus to display more items before beginning a new header?
For example:
First Name SURNAME Subject MARK
-------------...
1
vote
1answer
4k views
sp2-0667 message file sp2 lang .msb not found and sp2-0750 error is coming on windows
While i am trying to connect with with database by the command
sqlplus /nolog
than the error message is coming
"sp2-0667 message file sp2 lang .msb not found and sp2-0750 error is coming on windows"
...
0
votes
2answers
475 views
Disable MEMORY_TARGET after being locked out of database?
I'm setting up a local development environment in a virtual machine in which I installed Oracle XE among other software.
When I initially set up the virtual machine, the RAM was set to 4Gb. In this ...
1
vote
1answer
352 views
Find out where length semantics gets changed
I've code to create tables that doesn't specify length semantics:
CREATE TABLE CHAR_TEST (
CHAR_TEST_ID NUMBER(*,0) NOT NULL,
FOO VARCHAR2(6) NOT NULL,
BAR VARCHAR2(6) NOT NULL,
...
6
votes
1answer
49k views
Oracle intermittently throws “ORA-12516, TNS:listener could not find available handler with matching protocol stack”
While testing the Oracle XE connection establishing mechanism I bumped into the following issue.
Although connections are closed on each iteration, after 50-100 connections Oracle starts throwing ...
1
vote
0answers
3k views
Set session query timeout
When I develop complex queries and I make a mistake (e.g. a wrong join that will make the query run for hours or days) Oracle becomes unusable (you can't even start a local SYS session from SQL*Plus). ...
1
vote
1answer
353 views
In oracle XE, what is the difference between the autobackup and backupset direcories?
I am learning oracle db, and in Oracle XE, there are autobackup and backupset directories under flash_recovery_area/XE. In both directories, there are bkp files under the datestamped directoy.
What ...
2
votes
0answers
345 views
Does oracle workspace manager work with oracle xe 11g
According to this forum it can be using a patch but I need a support identifier to access patches.
https://community.oracle.com/thread/340084?start=0&tstart=0
This describes how to install ...
2
votes
2answers
2k views
sqlplus (Oracle XE) doesn't start on CentOS 7
I followed the steps of this document: https://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#XEINL121, but sqlplus doesn't start. Even if I used the command: "sqlplus /nolog".
The other ...
2
votes
2answers
4k views
Purge ARCHIVELOG automatically
I have an Oracle 10g XE installation (exclusively used for development) which has accumulated so far 14 GB of files at ...\oraclexe\app\oracle\flash_recovery_area\XE\ARCHIVELOG. I do need that space ...
1
vote
1answer
643 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:
$ ...
2
votes
1answer
436 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
10k 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 ...
0
votes
1answer
13k 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
1answer
2k views
How to install oracle 11g XE and use the data files of another instance (like Postgres)?
I installed Oracle 11g XE in Windows 7 x64, then Windows 8.1 (install new OS, not perform an upgrade of the previously Windows 7 x64 installation). Can be possible to install Oracle 11g XE over the ...
2
votes
0answers
540 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
2answers
2k views
Finding the highest quarter of the year
I'm sitting here and do some practise but I just can't find the Solution. Maybe someone could give me some help?
I have a table and should find the highest sale amount of a quarter per year.
Data ...
0
votes
0answers
750 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 don'...
