Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12560 when installing 8.1.7 on Win200 Server SP2

Re: ORA-12560 when installing 8.1.7 on Win200 Server SP2

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 30 Jan 2002 07:38:03 -0800
Message-ID: <a8aed4.0201300738.a0065b5@posting.google.com>


You Should Go ahead and Create the Database manually.

What you should do is.

  1. Oradim -new -sid orcl -intpwd oracle -pfile "%ORACLE_HOME%/Databases/InitOrcl.ora"
  2. Oradim -startup -sid orcl -starttype srvc
  3. sqlplus internal/oracle
  4. @%ORACLE_HOME%/Rdbms/Admin/Catalog.sql
  5. @%ORACLE_HOME%/Rdbms/Admin/Catproc.sql
  6. Shutdown Immediate
  7. take Backup.
  8. Startup

There u Have the database up and Running.

delboywood_at_yahoo.com (Derek Wood) wrote in message news:<61678921.0201300347.6e19e0_at_posting.google.com>...
> Hello All,
>
> There are a lot of postings featuring 12560 errors, but I can't seem
> to find a definitive answer to the problem.
>
> I have a new server, a clean install of Windows 200 server with SP2,

Hope MS Does not Downgrade ... [ Actually they should have said Windows 20 and not even 200... ] ;-)

> I'm doing an install of 8.1.7 Standard Edition. I choose a "typical"
> install, and specify that a starter database called "ORCL" should be
> created. Install runs okay, Net8 config assistant runs okay, database
> config assistant falls over with ORA-12560 TNS:Protocol adapter error.
>
> I have tried reinstalling several times, I have tried running svrmgrl
> and sqlplus - always fail with same error.
>
> I'm a Sybase/SQL Server DBA - so I know a bit about installing
> database software - but I'm afraid this has got me beat. I would be
> grateful for any advice. Some supporting information is attached.
>
> TIA
>
> Derek
>
> RESULT FROM LSNRCTL STATUS..........
>
> LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on
> 30-JAN-2002 11:22:
> 27
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for 32-bit Windows: Version
> 8.1.7.0.0 - Produc
> tion
> Start Date 30-JAN-2002 11:22:19
> Uptime 0 days 0 hr. 0 min. 7 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File D:\oracle\ora81\network\admin\listener.ora
> Listener Log File D:\oracle\ora81\network\log\listener.log
> Services Summary...
> PLSExtProc has 1 service handler(s)
> The command completed successfully
>
>
> MY LISTENER.ORA.......
>
> # LISTENER.ORA Network Configuration File:
> D:\oracle\ora81\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = acozor02)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = acozor02)(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\oracle\ora81)
> (PROGRAM = extproc)
> )
> )
>
>
> MY SQLNET.ORA.......
>
> # SQLNET.ORA Network Configuration File:
> D:\oracle\ora81\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
>
>
> MY TNSNAMES.ORA.......
>
> # TNSNAMES.ORA Network Configuration File:
> D:\oracle\ora81\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )

Regards,
Ganesh R Received on Wed Jan 30 2002 - 09:38:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US