Oracle Client Installation 11.2.0.1

Test the connection by using tnsping command. 

Upgrade from Oracle 11.2.0.1 to 11.2.0.2 in Windows xp using DBUA method

Downloaded the patchset 11.2.0.2 from Oracle website and run the OUI (Oracle Universal Installer)

connect to the database from oracle client

connect as scott user
C:>sqlplus scott/tiger@db1

connect as system user
C:>sqlplus system/password@db1

connect as sys user
C:>sqlplus sys/password@db1 as sysdba


We do not need the listener file in the client machine to connect to the database.

Details about environment variables in windows

We do not have oratab file in windows. Go to start->run->type "regedit". The registry will be displayed. Expand the folder called [HKEY_LOCAL_MACHINE]\SOFTWARE\ORACLE. Click on "KEY_*********", in the right hand side, we can find the details about environment variables. Another way to find out is, in the command prompt, type "set". The environment file will be displayed.

Loading records from one oracle database to another using oracle sql developer tool

The source and the destination databases are in different OS platforms. go to table->data(record) In one of the records, do a right click click on "export" tick 'export data' format: insert line terminator: environment default save as single file browse and choose the destination folder to place the output file Encoding: Cp1252/default click next click finish you will see a script click on "run script" Connection: destination connection click "ok"