Re: a good oracle FAQ

Hi Kevin,

Kevin Moriarty wrote:
>
> Does anyone know of a good oracle FAQ (like the java FAQ)

http://www.orafaq.org/

> A good oracle FAQ would include answers to these questions:
>
> Why do I get a 12154 error?

You can find the answer in Oracle Network Products Messages Manual:

ORA–12154 TNS:Could not resolve service name  Cause:
   The service name specified is not defined in the TNSNAMES.ORA file.  Action:
   Make the following checks and correct the error:

• Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.
• Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.
• Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable. See Chapter 4 in the SQL*Net Administrator’s Guide. If possible regenerate the configuration files using the Oracle Network Manager.

> What is the difference between an oracle instance and a database?

You'd better read original documentation... something like Server Concepts.

You can get it at http://technet.oracle.com for free.

> Where can I get oracle software for free?

http://technet.oracle.com

Good Luck!

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru