Tech-Today
The following article will help us in configuring our Toad Oracle Freeware with Oracle XE database. For development purposes I normally use XE so it's light.
Steps:
- Install Java8 In Ubuntu
A set of commands to install Java8 on Ubuntu. sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java8-installer Now set JAVA_HOME in the environment variables. sudo vi /etc/environment // add JAVA_HOME="/usr/lib/jvm/java-8-oracle"...
- Jdbc Provider Setting In Java For Postgresql, Mysql And Oracle
Below are the summary of connection settings for differenct jdbc provider: Database Connection Url Driver Class Hibernate Dialect Cache Provider Class PostgreSQL jdbc:postgresql://[host]:[port]/[db] org.postgresql.Driver org.hibernate.dialect.PostgreSQLDialect...
- Connect To Oracle Database In Java Language
This code connects to an oracle database using java programming language. This to remember: 1.) You must add ojdbc14.jar to the project's build path. 2.) Oracle's driver name: oracle.jdbc.driver.OracleDriver 3.) Connection string: jdbc:oracle:client:@server:port:database...
- Ora-12519, Tns:no Appropriate Service Handler Found
I often encountered this error after setting up a new machine with jboss/seam/oracle project installed. To resolve this: 1.) Open command prompt, by typing cmd in Start 2.) Execute c:\windows\system\sqlplus system@YOUR_SID 3.) Execute "ALTER SYSTEM SET...
- How To Change The Default Http And Ftp Port In Oracle Xe Univ
We assume that you have successfully download and installed the OracleXEUniv.exe. How to change the default http and ftp port in oracle xe univ 1.) Click Start->Run 2.) Type C:\Windows\System32\sqlplus system@xe 3.) Enter the admin password 4.) Enter...
Tech-Today
How to setup Toad Oracle Freeware
The following article will help us in configuring our Toad Oracle Freeware with Oracle XE database. For development purposes I normally use XE so it's light.
Steps:
- Download and install Oracle XE - I use 10.2.x
- I installed in: C:\java\oraclexe
- Download and install Toad Freeware (http://www.toadworld.com/m/freeware/default.aspx)
- Can be install anywhere
- Download and install Toad Client, go to http://www.oracle.com/technetwork/topics/winx64soft-089540.html and download the following files:
- instantclient-basic-win-x86-64-10.2.0.2.0-20060503
- instantclient-jdbc-win-x86-64-10.2.0.2.0-20060503
- instantclient-odbc-win-x86-64-10.2.0.2.0-20060503
- instantclient-sqlplus-win-x86-64-10.2.0.2.0-20060503
- Extract them all in C:\java\oraclexe\instantclient_10_2
- Add the following to environment path:
- C:\java\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
- C:\java\oraclexe\instantclient_10_2
- Connect in Toad using XE connection
Optional:
You can also install the Toad Eclpse plugin to connect to the database.
- Install Java8 In Ubuntu
A set of commands to install Java8 on Ubuntu. sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java8-installer Now set JAVA_HOME in the environment variables. sudo vi /etc/environment // add JAVA_HOME="/usr/lib/jvm/java-8-oracle"...
- Jdbc Provider Setting In Java For Postgresql, Mysql And Oracle
Below are the summary of connection settings for differenct jdbc provider: Database Connection Url Driver Class Hibernate Dialect Cache Provider Class PostgreSQL jdbc:postgresql://[host]:[port]/[db] org.postgresql.Driver org.hibernate.dialect.PostgreSQLDialect...
- Connect To Oracle Database In Java Language
This code connects to an oracle database using java programming language. This to remember: 1.) You must add ojdbc14.jar to the project's build path. 2.) Oracle's driver name: oracle.jdbc.driver.OracleDriver 3.) Connection string: jdbc:oracle:client:@server:port:database...
- Ora-12519, Tns:no Appropriate Service Handler Found
I often encountered this error after setting up a new machine with jboss/seam/oracle project installed. To resolve this: 1.) Open command prompt, by typing cmd in Start 2.) Execute c:\windows\system\sqlplus system@YOUR_SID 3.) Execute "ALTER SYSTEM SET...
- How To Change The Default Http And Ftp Port In Oracle Xe Univ
We assume that you have successfully download and installed the OracleXEUniv.exe. How to change the default http and ftp port in oracle xe univ 1.) Click Start->Run 2.) Type C:\Windows\System32\sqlplus system@xe 3.) Enter the admin password 4.) Enter...