Stack Overflow
Stack Overflow

Questions tagged [oracle-xe]

Oracle Database Express Edition (Oracle Database XE) is an entry-level, small-footprint database, free to develop, deploy, and distribute; fast to download; and simple to administer.

397 questions
118
votes
5 answers

How to create a new database after initally installing oracle database 11g Express Edition?

I have installed Oracle Database 11g Express Edition on my pc (windows 7) and I have installed Oracle SQL Developer as well. I want to create a simple database to start with, maybe with one table or two and then use Oracle SQL Developer to insert…
Zo72
  • 14,593
  • 17
  • 71
  • 103
74
votes
10 answers

ORA-28000: the account is locked error getting frequently

I am facing this error given below : ORA-28000: the account is locked Is this a DB Issue ? Whenever I unlock the user account using the alter SQL query, that is ALTER USER username ACCOUNT UNLOCK, it will be temporarily OK. Then after sometime…
Thush
  • 975
  • 3
  • 8
  • 11
66
votes
4 answers

Difference between VARCHAR2(10 CHAR) and NVARCHAR2(10)

I've installed Oracle Database 10g Express Edition (Universal) with the default settings: SELECT * FROM NLS_DATABASE_PARAMETERS; NLS_CHARACTERSET AL32UTF8 NLS_NCHAR_CHARACTERSET AL16UTF16 …
Álvaro González
  • 142,137
  • 41
  • 261
  • 360
54
votes
8 answers

URL string format for connecting to Oracle database with JDBC

I'm a newbie to Java-related web development, and I can't seem to get a simple program with JDBC working. I'm using off-the-shelf Oracle 10g XE and the Eclipse EE IDE. From the books and web pages I've checked so far, I've narrowed the problem down…
Pops
  • 30,199
  • 37
  • 136
  • 151
46
votes
9 answers

How to correctly set the ORACLE_HOME variable on Ubuntu 9.x?

I have the same problem as listed here: How to recover or change Oracle sysdba password although I did not lose the password, I entered it twice in the configure script originally, and then when I went to login (localhost:8080/apex, password not…
coderintherye
  • 901
  • 1
  • 11
  • 20
39
votes
7 answers

Oracle 11g Express Edition for Windows 64bit?

I registered on http://Oracle.com in order to download 11g R2 Express edition database. But http://Oracle.com offered me download links only for Windows 32bit and for Linux 64bit. Is there somewhere 64bit Windows version of Oracle 11g XE database? …
sanjuro
  • 1,611
  • 1
  • 21
  • 29
28
votes
1 answer

How to disable Oracle XE component which is listening on 8080?

After installing Oracle XE, something in Oracle is listening on port 8080. I am not sure if they have an Apache HTTPD, a Tomcat, or something else. But how can I disable it?
avernet
  • 30,895
  • 44
  • 126
  • 163
16
votes
3 answers

How many connections can Oracle Express Edition (XE) handle?

I'm building a web application that uses Oracle Database 10g as the database backend. I realize the Express edition has limitations, but I just wanted to make sure that number of connections wasn't one of them. Does Oracle Express Edition (XE)…
Bob
16
votes
1 answer

Problem in firefox when calling window.open

When i'm calling this code in the link of a chart in apex javascript:window.open('http://google.pt','mywindow','width=400,height=200', 'bReplace=true'); it opens a new window with google page but puts the chart page with a blank page with [object…
macwadu
  • 907
  • 4
  • 24
  • 44
13
votes
3 answers

How can I change the SID of an Oracle XE instance

I needed to change the SID of an Oracle XE database (not the Service Name) to match a production database. When I tried searching online, most of the pages were describing changing or adding a service name through tnsnames.ora; that's not what I…
Osama Al-Maadeed
  • 5,654
  • 5
  • 28
  • 48
13
votes
2 answers

Can I have multiple databases on oracle express edition

Can I have multiple databases on oracle express edition? Please let me know what are steps to setup?
Naga
  • 225
  • 2
  • 4
  • 12
11
votes
2 answers

Creating new database under Oracle XE on Ubuntu

I've just installed Oracle XE in Ubuntu. Is there any way to create new databases, besides the one that comes with the installation, preferably from the command line so that I can do it from a script? It would be nice to have multiple databases…
Gabriel
  • 2,313
  • 9
  • 29
  • 41
11
votes
1 answer

Installer is unable to instantiate the file ...\KEY_XE.reg. The file does not appear to exist

I keep getting this error when trying to install Oracle Express edition on Windows 64. I searched online and the only posts I found were for a missing registry entry. The actual file is missing in my case. I have uninstalled, rebooted, and…
user994165
  • 9,146
  • 30
  • 98
  • 165
10
votes
8 answers

Oracle 10g express home page is not coming up

I installed Oracle 10g express. Installation went well, But the home page is not coming up. I can connect using sqlplus but not with Sql Developer. I checked tnsnames.ora and listener.ora everything looks fine. Listener is also started. I can…
lostinbytes
  • 293
  • 2
  • 3
  • 11
10
votes
2 answers

ORA-27101: shared memory realm does not exist

i am facing this error when i start the oracle. I checked Oracle Home and SID. everything is set properly. ORA-27101: shared memory realm does not exist please help me to find out the solution. Thanks in advance
Gnaniyar Zubair
  • 8,114
  • 23
  • 61
  • 72
1
2 3
…
26 27