Re: HELP: cannot connect internal

Were the Windows Services created? Are they started? Is there a TNSNAMES.ORA file in \network\admin or net80\admin? Is there a listener.ora file? Is the Windows Service for the listener started? Lots of possibilities.

Yes you can create the database from scratch. That is really the best way to do it. But before you can you need an initSID.ora file and a build script to create the system tablespace, rollback tablespace and rollback segments, temp tablespace, and data and index tablespaces. I suspect you don't have those handy. <g>

But before you do ... you will still need to solve the TNS problem. Because a manual build can only be done in Server Manager.

Daniel A. Morgan

Wencai Pan wrote:

> Hello:
> I installed the oracle 8i in my windows 2000 professional machine. I use the
> Universal Installer and choose 'typical' mode, but it didn't install any
> database for me. In c:\oracle\ora81\admin and c:\oracle\ora81\oradata, they
> have a sample folder, but doesn't work. After entering 'svrmgrl' in dos
> command, it can enter server manager mode, when I try to connect
> internal/oracle, it gave me "ORA-12560: TNS: protocol adapter error".
> I also read the "Oracle 8i administrator's guide", it shows one can use
> "Database Configuration Assistant" to create a database, but I can only find
> "DBA studio" under "Database Administration". Can I create a database when
> there is no database in my computer?
> I appreciate your time and help.
>
> --
> JOY! :o) Wencai
Received on Wed Apr 18 2001 - 00:32:12 CDT