Hi people, I'm starting a new project here (Windows Forms) and was wondering what's the best option today for a small (free as in beer) dbms. I've used SQL Server Express on the past projects, but time and time again I hear people saying that the product from Oracle is faster and more powerful. It will be used in a small company (aroun...
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? ...
I'm unable to make a remote connection to an Oracle XE install (through TOAD / SQL Developer). Here's the deal. I set up a new server (windows 2003). The goal was to make a new image with several applications preinstalled, Oracle XE being one of them. Got Oracle installed no problem, connected locally, remotely and had access to the ...
Hi I am new and I am used to MS SQL Manager's Attach/Detatch functionality to drop a database into a single file so I can move it to other computers/SQL instances. In a nut shell, this is what I want to do. I have a large Oracle Express database (instance name Zeus) that I need to move onto other Oracle Express instances (brand new inst...
Is there a Linux version of Oracle XE? I could not find any info on Oracles official site. ...
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 needed to do. ...
I just installed Oracle Express edition. During the installation it asked me to set a password but not a username. After the installation completed, it directed me to a browser window and asked me to login with a username and password. The password I know but the username I don't know. Is this an IQ test? Did I fail it? ...
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 always reinstall and see. But I thought better inquire the cause. Regarding the home page. Thi...
I am using C to write a DLL that provides basic database connection functionality to a couple of different applications, using ODBC. When I use this DLL to connect to an Oracle database (Oracle 10g Express Edition, specifically) I get the following error message: Specified driver could not be loaded due to system error 1114 (Oracle in X...
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 started in the same time, if possible. If it is not possible to create new databases, then ma...
I'm writing an application which needs to work on an Oracle DB, we don't have an Oracle Db but our client does, so I've been developing/testing it using Oracle Express. Are there anythings I should watch out for in moving from the free version that might break my app when I run it against the Full fat edition? ...
Hello, Probably I'm doing something wrong but here it goes: I'm trying to create a database using subsonic.migrations in an OracleXE version 10.2.0.1.0. I have ODP v 10.2.0.2.20 installed. This is my app.config: <?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> <section name="SubSonicService" type="SubSon...
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 limit the amount of concurrent connections (for example, the number of users viewing the site)? ...
How do i go about importing a .dmp file created by DataPump into Oracle Express 10g ...
Hello guys, I have an error I cannot solve, on a ASP.NET website. One of its pages - Countries.aspx, has the following controls: a CheckBox called "CheckBoxNAME": } Also, this is the main onload event of the page: protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) ...
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 to either an incorrectly written database URL or a missing JAR file. I'm getting the fo...
This is a little something I thought I need to share. We had some issues establishing connection to Oracle. We kept getting the ORA-12154 (TNS:could not resolve the connect identifier specified) without any apparent reason. The weirdest thing was that in some application the connection was successfully established, while it kept throwin...
Hello All: My Oracle 10g Express Edition , I can login in the SQL plus but I cannot login into oracle via SQL developer and cannot view the Home page at link http://127.0.0.1:8080/apex. This was working fine until yesterday. I have checked via (WINDOWS)netstat -ab and no other app is using the 8080 port. The only thing I did today was...
I am running Oracle Database 10g Express Edition Release 10.2.0.1.0 in a dev environment with the following NLS settings: NLS_CHARACTERSET WE8MSWIN1252 NLS_NCHAR_CHARACTERSET AL16UTF16 Used clients are either PHP with oci8 extension or the Oracle SQL Developer, using both ended up in this behaviour which I don't understand: I had rece...
Hi guys: I have created a stroed func as follows: CREATE OR REPLACE FUNCTION HR.worldCount(str IN VARCHAR2) RETURN PLS_INTEGER AS BEGIN Return 1; END; / But an error occurs when I execute it: Begin DBMS_OUTPUT.PUT_LINE ('there are ' || HR.wordCount('abc')); End; Error is as follows: Error at line 1 ORA-06550: line...