We help IT Professionals succeed at work.

Creating new DB using DBCA after Oracle 8i Installation shows ORA-12560 TNS Protocol adapter error

JbolanosD
JbolanosD asked
on
3,586 Views
Last Modified: 2013-12-19
I just installed Oracle 8i into a Windows 2003 Server. The installation gave me some trouble because the java JIT, and the Network configuration got freezed. after install i ran Net8 Assistant and configured the listener. when i try to create a new DB using database configuration assistant. shows me the error ORA -15260.

below the listener.ora, sqlnet.ora and  listener status

# LISTENER.ORA Network Configuration File: D:\oracle\ora81\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = z1t3hnsppla04)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Oracle\Ora81)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = L500.CQ.BATGEN.COM)
      (ORACLE_HOME = D:\Oracle\Ora81)
      (SID_NAME = L500)
    )
  )

TRACE_LEVEL_LISTENER = USER



# SQLNET.ORA Network Configuration File: D:\oracle\ora81\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = cq.batgen.com
SQLNET.AUTHENTICATION_SERVICES= (NONE)
SQLNET.EXPIRE_TIME = 10
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)


D:\oracle\ora81\BIN>lsnrctl

LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 12-NOV-2009 09:09:
28

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=z1t3hnsppla04)(PORT=1521
)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc
tion
Start Date                12-NOV-2009 09:03:28
Uptime                    0 days 0 hr. 6 min. 2 sec
Trace Level               user
Security                  OFF
SNMP                      OFF
Listener Parameter File   D:\oracle\ora81\network\admin\listener.ora
Listener Log File         D:\oracle\ora81\network\log\listener.log
Listener Trace File       D:\oracle\ora81\network\trace\listener.trc
Services Summary...
  L500          has 1 service handler(s)
  PLSExtProc            has 1 service handler(s)
The command completed successfully
LSNRCTL>


NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)
Comment
Watch Question

Author

Commented:
rising the prize...
Devinder Singh VirdiLead Oracle DBA Team

Commented:
Are you not able  to create DB or unable to connect?

Author

Commented:
virdi ds:  there is no database created on the server. im trying create the first one. i didnt create during installation because the installer got freezed.
Devinder Singh VirdiLead Oracle DBA Team

Commented:
Can you please check if you have loopback and other network adaptors are installed. Just want to double check, check all Oracle services followed by instance name you already gave (Control Panel ---> Administrative Tools ---> Services)
Devinder Singh VirdiLead Oracle DBA Team

Commented:
Did you get any warning for network before creating the database?

Author

Commented:
i have 3 physical network adapters HP NC7781 installed and a fourth logical adapter working as a Team Network Adapter.  (i see one adapter disconnected).  but i can ping the server without problems.

on Services there are:
OracleOraHome81Agent (Rrunning)
OracleOraHome81Client Cache (not running)
OracleOraHome81CMAdmin (not running)
OracleOraHome81CMan (not running)
OracleOraHome81DataGatherer (not running)
OracleOraHome81Names(not running)
OracleOraHome81PagingServer(not running)
OracleOraHome81TNSListener(Running)

There is no Oracle Instance Created as a Windows Service.







Devinder Singh VirdiLead Oracle DBA Team

Commented:
Before creating DB (on precheck), did you see any warning message for network? I mean before creating db, does all precheck tests Succeeded.
Devinder Singh VirdiLead Oracle DBA Team

Commented:
Also do you have Microsoft Loopback Adapter installed. if you are getting warning then try loading this using control-panel ---> add new hardware ---> manual selection ---> Adapters----> Microsoft Loopback Adapter.

Author

Commented:
when i run the DB CA wizard, select create a database, custom, multipurpose, 15 users, dedicated server mode, uncheck options (spatial, jserver, advanced replica, and sqlplus help).. Global DB Name: L500.cq.batgen.com, SID=L500, compatible 8.1.0, control files defaults, schemas defaults, redo logs defaults, checkpoints default, SGA  defaults, Create database NOW...

Creating and installing Oracle Instance OK ( i can see the new window service called OracleServiceL500)
Creating Database Files (Stopped). and shows  ORA -12560 TNS: Protocol Adapter Error.  if i click abort then the windows service is deleted. if i said ingore then the db creation freezes.

Author

Commented:
checking the  sqlnet.log created by the DB CA is as follows:


***********************************************************************
Fatal NI connect error 12560, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleL500)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=L500)(CID=(PROGRAM=D:\oracle\ora81\bin\svrmgrl.exe)(HOST=Z1T3HNSPPLA04)(USER=fnadminbatca))))

  VERSION INFORMATION:
      TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
      Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
  Time: 11-NOV-2009 16:00:57
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNS:protocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 2
    nt OS err code: 0
Lead Oracle DBA Team
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
i think there are as many entries as i tried created the DB. but all the same error.
Devinder Singh VirdiLead Oracle DBA Team

Commented:
Can you use this connecting string..
Change IP address and SID as required
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SID = L500)))

Author

Commented:
i created a batch with the commands above, and selected a sample init.ora
it ran without problems.  now i connected using internal and it shows me the message "connected to an iddle instance.."

C:\Documents and Settings\fnadminbatca\Desktop>createdb
C:\Documents and Settings\fnadminbatca\Desktop>set ORACLE=SID=L500
C:\Documents and Settings\fnadminbatca\Desktop>SET ORACLE_HOME=d:\oracle\ora81
C:\Documents and Settings\fnadminbatca\Desktop>SET ORACLE_BASE=d:\oracle\
C:\Documents and Settings\fnadminbatca\Desktop>PATH=$path;d:\Oracle\Ora81\bin
C:\Documents and Settings\fnadminbatca\Desktop>ORADIM -NEW -SID L500 -INTPWD 1NT3RN4L -MAXUSERS 15 -STARTMODE A -PFILE  D:\oracle\admin\L500\pfile\InitL500.ora


C:\Documents and Settings\fnadminbatca\Desktop>
Devinder Singh VirdiLead Oracle DBA Team

Commented:
This errors occurs when there ORACLE_SID is not properly set. you can set this parameter in registory. Open registory using regedit command and add ORACLE_SID, ORACLE_HOME, etc along with values there. Also you can set the path in the properity of my computer.
While setting ORACLE SID, I believe you missed underscore.
C:\Documents and Settings\fnadminbatca\Desktop>set ORACLE=SID=L500
it should be ORACLE_SID=L500 without any space.

Author

Commented:
yes it is!
i connected using sqlplus as internal and then i run the below statement statement
and it works. the database created ok.

startup nomount pfile="D:\oracle\admin\L500\pfile\initL500.ora";
CREATE DATABASE L500
LOGFILE 'D:\oracle\oradata\L500\redo01.log' SIZE 1024K,
    'D:\oracle\oradata\L500\redo02.log' SIZE 1024K,
    'D:\oracle\oradata\L500\redo03.log' SIZE 1024K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'e:\oracle\oradata\L500\system01.dbf' SIZE 264M  REUSE AUTOEXTEND ON NEXT 10240K
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;


now when i try connect using dbastudio it sa

Author

Commented:
Thanks Virdi Ds: i think the problem is the wizard!  because by doing manually as you suggested the db creates wonderfull.  now i jut need to be more specific with initialization parameteres.
Thanks.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.