Re: Help needed on creating database after Installation

Jackson Zhu wrote:

> Hi,
>
> After Installation of oracle 8i, I use dbassist to create the first database
> "sales", during initialization stage, it says "not connected to ORACLE" or
> "ORACLE not available". after that, I try to login and fail.
>
> Anybody can help me?
>
> Thanks in advance

There are a very large number of possibilities. First you need to diagnose what the problem is and get back to us. Check out the following:

1. Go to the control panel, system. Are there environment variables for ORACLE_HOME and ORACLE_SID?
2. Go to control panel, services. Are their services for Oracle named OracleOraHome81TNSListener? Is it started? Are there any other Oracle services? Are any started? Which ones?
3. Go to c:\oracle\ora81\bin and type the following:

lsnrctl status?

What is the full message?

4. Also in c:\oracle\ora81\bin type the following:

tnsping <and your instance name> (most likely oracle) so "tnsping oracle"

What message came back?

5. Also in c:\oracle\ora81\bin type the following:

svrmgrl

then type

connect internal

if it asks for a password type "Oracle"

perform the following:

SELECT COUNT(*)
FROM user$;

Report any error messages.

6. Go to c:\oracle\ora81\network\admin.

Is there a file named listener.ora? tnsnames.ora? sqlnet.ora?

Daniel A. Morgan Received on Fri Jun 22 2001 - 15:10:18 CDT