Please look at document need done by 2moro at 10.pm est
mr.obi
oracle_client_download_and_configuration_3.docxOracle Download and Configuration and Connection Guide
Oracle makes available client software that you can run to access an Oracle database. You may follow the following steps to install the Oracle 11g client software.
To install Oracle 11g Client:
To select the correct download for your system you will need to know whether you have a 64-bit or 32-bit operating system.
For Windows 7 you can right-click on computer and select Properties. In the window that opens look under system for System type which will be either 32-bit or 64-bit.
For Windows 7 (x64) you would need to use the 11g Release 2 Client at: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soHYPERLINK "http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html"fHYPERLINK "http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html"t-094461.html
For Windows 7(x32) or Windows Vista you would use (note: cut the link and paste it into your browser): http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
On the above page you need to Accept License Agreement before you attempt to download. You are also prompted to enter your username and password as you attempt to download. You need to create an account if you don’t have one.
Download: Oracle Database 11g Release 2 Client (11.2.0.1.0) using the Save As option so you will know where it is. Right click the downloaded zip file and choose Extract All.
After extracting you should have a "Client" folder. It contains a setup.exe program that you run to do the installation. The default selections should work, except that you should choose Administrator on the initial screen. After installing the software, you will need to configure a “local net service name”. Follow the sequence as follows start-> all program->Oracle - OraClient11g_home1->Configuration and Migration Tools-> Net Configuration Assistant to start the Net Configuration Assistant.
If you have other windows open, this program may open in a window that is behind them. Configure it as follows:
· Select Local Net Service Name Configuration and click Next
· Click Add then click Next
· For Service Name enter INFO then click Next
· TCP then click Next
· For Host Name enter Cody.AUM.edu then click Next
· Select Yes then click Next
· You should get a message that says: Connecting...ORA-01017: invalid username/password; logon denied This means that you successfully contacted the database. You are set up properly. If you did not get this message, something is wrong. Delete the Net Service Name and try again.
· Click Next then for Net Service Name enter INFO then next, next, next then FINISH. You are now ready to login with your own username and password.
Download JAVA JDK
To be able to use Oracle SQL Developer in Oracle client, you need to install the Java Standard Development Kit (Java Platform JDK) for 32-bit Windows no matter you have a 64-bit or 32-bit Windows operation system. Use the following link:
http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html
Again, on this page you will need to Accept License Agreement before you attempt to download Java SE Development Kit.
Choose Windows x86, jdk-7u25-windows-i586.exe to download. Run the downloaded JDK file to install the JDK.
To run SQL developer for the first time, follow the sequence as follows start-> all program->Oracle-OraClient11g_home1-> Application Development->SQL developer, you will be prompted to enter the pathname for your newly installed Java JDK program. If the program was installed in C and you run a 64-bit Windows, the destination will be as follows: C:\Program Files (x86)\Java\ jdk1.7.0_25\bin\java.exe. You click Browse and then follow the sequence as follows: Go to Computer -> Local Disk (C:) -> Program Files (x86) -> Java -> jdk1.7.0_25 -> bin -> click on Java and then click Open.
Connect to Oracle:
Using SQLPlus to connect to Oracle: following the sequence as follows: start-> all program->Oracle-OraClient11g_home1->Application Development->SQL Plus to start SQLPlus. Then type in your username/password@INFO
Initial password for all: crimson
Your user name is the same as your AUM email address, but does not have @aum.edu part and the number before @.
[email protected] , user name: ychen
[email protected], user name: ychen
To connect to Oracle for the first time, you will be prompted to change your password. Write down your new password. You will need this new password to connect to Oracle later.
Using SQL Developer to connect to Oracle:
· Follow the sequence as follows: Start-> All Programs->Oracle - OraClient11g_home1->Application Development->SQL Developer to start SQL Developer.
·
· Enter your own connection name, username and password and enter other parameters as the following screenshot shows. Then click Connect.
Download standalone SQL developer:
Some people like to use the standalone SQL developer. You can download it at:
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
After you download and install it. You just follow the same three steps on page 4 to configure it.
To install Oracle SQL Developer Data Modeler
To Install Oracle SQL Developer Data Modeler 3.3 use the following link:
http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html
Oracle Academy
You can find some free learning materials at Oracle Academy. In order to access them, you need to create a student account at: https://academy.oracle.com/oa-web-overview.html
You should select Information Systems at AUM as your institution.
Note: you cannot use the account you create when you download Oracle client software.
