Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help needed on creating database after Installation
This is a good helping hand if the Oracle is on an NT machine...
Check the log. The dbassist spools everything to a log somewhere on your disks / filesystems.
It is a good idea to make the scripts instead of making the database at once at the end of "dbassist", this gives you a better look of what is going on.
Arne S
"Daniel A. Morgan" wrote:
> 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 Mon Jun 25 2001 - 04:10:48 CDT