Home » RDBMS Server » Networking and Gateways » ORA-28547: connection to server failed, probable Oracle Net admin error (10.2.0.3 windows 2003 32bits)
ORA-28547: connection to server failed, probable Oracle Net admin error [message #323693] Thu, 29 May 2008 04:41 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

Im trying to create a new DB using our scripts. But Im getting some errors, cant log in using SQLPLUS:
SQL> connect sys/******@&db_alias1 as sysdba
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error 

SQL> startup nomount pfile="e:\oracle\product\10.2.0\db_1\database\init&db_alias1..ora"
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist


I have checked for the ORA-28547 but cant see anything wrong in my files. Please have a look:

tnsnames.ora:
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

DB56.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sestows146)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = sestows146)(PORT = 1526))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DB56)
    )
  )


listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)

	(GLOBAL_DBNAME = DB56)
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
      (SID_NAME = DB56)
    )
  )


sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH = (TNSNAMES)
NAMES.DEFAULT_DOMAIN = World


Yes, the script have worked before and have not been changed. I have upgraded the ORACLE_HOME from 10.2.0.1 to 10.2.0.3...

Feel free to yell at my mistakes Smile

Regards
Hristo
Re: ORA-28547: connection to server failed, probable Oracle Net admin error [message #323737 is a reply to message #323693] Thu, 29 May 2008 06:13 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

Some pancakes and whipped cream did the trick, at least for my brain (found the fault after lunch).

This is how the listener.ora SHOULD look like:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sestows146.prg-dc.dhl.com)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
     (SID_DESC = 
      (SID_NAME = DB56)
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
      (SERVICE_NAME = DB56)
     )
  )



And yes, I can create a DB with the script now Smile

Regards
Peter

[Updated on: Thu, 29 May 2008 06:14]

Report message to a moderator

Re: ORA-28547: connection to server failed, probable Oracle Net admin error [message #324004 is a reply to message #323693] Fri, 30 May 2008 04:40 Go to previous message
Rajabaskar Thangaraj
Messages: 13
Registered: March 2008
Location: CHENNAI
Junior Member
Database Creation steps:

1. Create necessary folder
2. Create parameter file.
2. create services
Oradim -new -sid dbname

4. create password file
5. set oracle_sid=dbname
6. sqlplus /nolog
7. conn sys/password as sysdba
8. startup nomount pfile=''

In your case check the services,parameter file.
Once database creation completed, after you configure the TNS and listener file is better.

Regards
Rajabaskar



Previous Topic: Licensing fee for Transparent gateway for MS SQL SERVER
Next Topic: 10g Transparent Gatway
Goto Forum:
  


Current Time: Fri Mar 29 07:13:19 CDT 2024