Wednesday, January 27, 2010

ORA-12560 Error When Trying to Create New Database After New Install [ID 973264.1]


Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4.0 - Release: 10.2
Information in this document applies to any platform.

Symptoms


===================
-- Problem Statement:
ORA-12560 when trying to connect as sysdba after new install to create new database.

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 5 09:37:32 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

specify a password for sys as parameter 1
Enter value for 1: xxxxxxxx
specify a password for system as parameter 2
Enter value for 2: xxxxxxxxxxx

ERROR:
ORA-12560: TNS:proto adapter error

SQL> spool /apps/oracle/RTM1U/u01/admin/create/CreateDB.log
SQL> startup nomount pfile="/apps/oracle/RTM1U/u01/admin/create/initRTM1U.ora";
ORA-12560: TNS:protocol adapter error
SQL> CREATE DATABASE "RTM1U"
2 MAXINSTANCES 32
3 MAXLOGHISTORY 50142
4 MAXLOGFILES 200
5 MAXLOGMEMBERS 5
6 MAXDATAFILES 500
7 DATAFILE '/apps/oracle/RTM1U/u02/data/system01.dbf' SIZE 1024M REUSE
8 EXTENT MANAGEMENT LOCAL


Changes

New install.

Cause

Installation issue. Binaries needed to be relinked.

Solution

-- To implement the solution, please execute the following steps::
Relink the Oracle binaries with 'relink all'

No comments: