Home » RDBMS Server » Networking and Gateways » ORA-28547: connection to server failed, probable Oracle Net admin error (10.2.0.3 windows 2003 32bits)
|
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
|
|
|
Goto Forum:
Current Time: Sun Jun 08 13:44:59 CDT 2025
|