iSelfSchooling.com - Copyright © 1999-2007 iSelfSchooling.com  References  Job Openings  |  Secure Login
    Home  | Search more...  |  FREE Online VIDEO Oracle Training  |  Gift Store  |  Bookstore

   Unlimited access!   

    Oracle  Syntax  | Suggestions Your Contribution  |  FREE Legal Forms

 

Email2aFriend Homepage us! |  Bookmark   -  Copyright & User Agreement

Products/Services

 Vision/Mission

 Community Sharing

 Services

  Products

 Biography

 Contact Us

 FAQ

 Current News

 Website Traffic

 Bookstore

 FREE Training

 SQL

 PL/SQL

 Forms 

 Reports

 Other TOOLS

 Fundamentals

 Performance

 OEM

 Application Server

 Grid Control

 Articles

 Prepare for OCP

Oracle SYNTAX

 Oracle Functions

 Oracle Syntax

 Oracle 10g Syntax

  PL/SQL Syntax

UNIX and more...

 UNIX for DBAs

 LINUX for DBAs

 DB using PHP

  A+ Certification

 Basics of JAVA  

 Tips of  SEO

Finance/Jobs

 Financial Aid

 Skilled

 Oracle

 Jobs

  Magazine

More Training

 Q & Answers

 SQL-PL/SQL

 DBA

 Developer

 Important Notes

 Case Studies

 9i New Features

 10g New Features

 10g Qs/As

 Grid Control

 OracleAS # I

 OracleAS # II

  LDAP and OID

  HTTP Server

 Instructor-Led

  Virtual Hosts

 Community Sharing

More to know...

Acknowledgement**

 FREE Legal Forms

 Who is who

 Market Place

 University Directory

 Advisory Articles

 Links...

 

 

Topics:  How to connect to the Oracle database from Back-end and Front-end tools

More Resources by Google:

The Oracle database and Developer are very easy to install.  The only difficulty that you may face is:  How to establish connectivity between the Oracle developer tools and the Oracle database on the same machine such as windows98.  This Hands-On, it will teach you how to make this connectivity.

   

    1- Start listener

   

    2- Create a Service Name using the Net8 Easy Configuration

 

    3- Test the Service Name

 

    4- Copy SQLNET.ORA from the oracle database folder to the developer folder

 

    5- Copy TNSNAMES.ORA from the oracle database folder to the developer folder

 

    6- Add the LOCAL string to the registry

 

    7- Login to the “SQLPLUS” tool

 

Manuscript

Go to “MS-DOS” and start the listener.

=

Open the Net8 Assistant tool or Oracle Net8 Easy Config tool.

=

Type “DBS” as a new service name, and then click “NEXT.”

=

Choose “TCP/IP”, then click “NEXT.”

=

Type 127.0.0.1, and click “NEXT.”

=

Type your Global Database name.

Mine is “oracle,” then click “NEXT.”

=

Click on test.

The connection should be successful.

You may have to enter a USERID and PASSWORD.

Then click “CLOSE.”

Click “Next.”

and “Finish.”

=

On MS-DOS, type tnsping then the service name.

You should get a message like this.

=

Open “windows explorer.”

Go to the oracle database home, network, and then the admin folder.

Copy the “sqlnet.ora” and “tnsnames.ora” files to the developer’s admin folder.

=

Close the window.

=

Edit the registry file.

=

Expand “Local machine.”

Expand “Software.”

Select  “Oracle.”

Add a new string value.

Name it “LOCAL.”

Then double click on the “LOCAL” icon and type “dbs” (the service name).

And Click “OK.”

=

Close the window.

=

To test the service name, Login to sqlplus as scott/tiger using the service name.

=

Exit “SQLPLUS.”

=

Open any Oracle tool such as “SQLPLUS” and login as “SCOTT/TIGER” without the service name.  Remember.   The sqlplus uses the service name that you added to the registry file.

 

Click ‘OK.”

=

That is all.

=

And I wish you good luck in you set up.

 
 
 
Google
 
Web web site