On the server side, we have loaded following application software:
Requires Free Membership to View
1. W2K advanced server2. Crystal enterprise 8.0
3. Crystal professional 8.5
4. Lotus client
To connect to a different database you'll need to set up your Network definitions properly. In your %ORACLE_HOME%\network\admin directory, there should be a file called TNSNAMES.ORA. If there is no such file, create one. Otherwise, open it up. Add an entry similar to this in that file:
db_name =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = myhost)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = db_name)
)
)
Make sure that you substitute values for "db_name" and
"myhost". The SID is your database identifier uniquely
identifying your different databases. Put a second
entry for your second database similar to the above
entry. Then save your TNSNAMES.ORA file.
Once that is done, to connect to a database, try the following from a DOS prompt:
sqlplus username@db_nameThe tool will look up the "db_name" entry in your TNSNAMES.ORA file and use that information to find out how to connect to your database!
For More Information
- What do you think about this answer? E-mail the editors at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in April 2002
Join the conversationComment
Share
Comments
Results
Contribute to the conversation