ORA-28547: connection to server failed, probable Oracle Net admin error [message #323693] |
Thu, 29 May 2008 04:41 |
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
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 |
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
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 |
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
|
|
|