There is I used this blog post to install it in my machine: http://luminite.wordpress.com/2012/09/06/installing-oracle-database-xe-11g-on-windows-7-64-bit-machine/ The only thing you have to do is replace a registry value during the installation, I’ve done it about three times already, and every time found a different reference on-line, none here on stackoverflow. EDIT: as @kc2001 noted, regedit must be … Read more
Usually the msb file not found problems are the result of an environment setting problem, but in your case I’m a little suspicious of the installation (I’ve never used the apt-get + configure method). To check the sanity of the installation: ORACLE_HOME should be set to a directory path one level above the bin directory … Read more
There are two ways to set this up. If you have an SID, use this (older) format: jdbc:oracle:thin:@[HOST][:PORT]:SID If you have an Oracle service name, use this (newer) format: jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE Source: this OraFAQ page The call to getConnection() is correct. Also, as duffymo said, make sure the actual driver code is present by including ojdbc6.jar … Read more
The NVARCHAR2 datatype was introduced by Oracle for databases that want to use Unicode for some columns while keeping another character set for the rest of the database (which uses VARCHAR2). The NVARCHAR2 is a Unicode-only datatype. One reason you may want to use NVARCHAR2 might be that your DB uses a non-Unicode character set … Read more
One of the reasons of your problem could be the password policy you are using. And if there is no such policy of yours then check your settings for the password properties in the DEFAULT profile with the following query: SELECT resource_name, limit FROM dba_profiles WHERE profile=”DEFAULT” AND resource_type=”PASSWORD”; And If required, you just need … Read more
When you installed XE…. it automatically created a database called “XE”. You can use your login “system” and password that you set to login. Key info server: (you defined) port: 1521 database: XE username: system password: (you defined) Also Oracle is being difficult and not telling you easily create another database. You have to use … Read more