Oracle logs prompt ORA - 28546 what's the problem-CodePudding

Trace the file E: \ APP \ wouldn \ \ ADMINISTRATOR \ diag \ an RDBMS wouldn \ Trace \ orcl_ora_6820 TRC
Oracle Database 11 g Enterprise Edition Release 11.2.0.4.0-64 - bit Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU: 8 - type, 8664, 8 Physical Cores
The Process Affinity: 0 x0x0000000000000000
The Memory (the Avail/Total) : Ph: 18777 m/32767 m, Ph + PgF: 51202 m/65533 m
The VM name: VMWare Version (6)
The Instance name: former
Redo thread mounted by this instance: 1
Oracle process number: 19
Windows thread id: 6820, image: ORACLE. EXE (SHAD)

* * * 2017-10-24 09:05:57. 391
* * * CLIENT ID: () the 2017-10-24 09:05:57. 391
* * * SERVICE NAME: () the 2017-10-24 09:05:57. 391
* * * the MODULE NAME: () the 2017-10-24 09:05:57. 391
* * * the ACTION NAME: () the 2017-10-24 09:05:57. 391

The Network protocol error on first data after new connect
Probable error (ORA - 28546) in the network administration

CodePudding user response:

The

Quote:

$oerr ora 28546
28546, 0000, "the connection initialization failed, probable the Net8 admin error"
//* Cause: A failure occurred during initialization of A network connection
//the from the Oracle server to a second process: the connection
//the was completed but a disconnect occurred while trying to
//perform protocol - specific initialization, usually due to
//the use of company's network separate protocols by opposite sides
//of the connection. This usually is under caused by incorrect
//the Net8 administrative setup for the database links or external
//procedure calls. The most frequent specific causes are:
//-- the Database link setup for an Oracle - to - Oracle connection
/home/connects to a Heterogeneous Services agent
//or an external procedure agent.
//-- the Database link setup for a Heterogeneous Services connection
/home/connects directly to an Oracle server.
//-- The extproc_connection_data definition in tnsnames. Ora
Home//connects to an Oracle instance an external
//procedure agent.
//- Connect the data for a Heterogeneous Services database link,
//usually defined in tnsnames. Ora, does not specify (HS=).
//- Connect the data for an Oracle - to - Oracle database link,
//usually defined in tnsnames. Ora, specifies (HS=).
//* Action: Check the Net8 administration in the following ways:
//-- the When using TNSNAMES. ORA or an Oracle Names server, make sure
//that the connection from the ORACLE server USES the correct
//service name or SID.
//- Check the LISTENER. ORA on the connection end point 's host machine
//to the assure that this service name or SID connects to the
//correct program.
//- Confirm in TNSNAMES. ORA or the equivalent service definition
//that the service 'extproc_connection_data' does NOT contain
//(HS=), or that the service definition, informs by a
//Heterogeneous Services database link DOES contain (HS=).
//
Quote:
CodePudding user response:
reference 1st floor minsic78 response:

The
Quote:
$oerr ora 28546
28546, 0000, "the connection initialization failed, probable the Net8 admin error"
//* Cause: A failure occurred during initialization of A network connection
//the from the Oracle server to a second process: the connection
//the was completed but a disconnect occurred while trying to
//perform protocol - specific initialization, usually due to
//the use of company's network separate protocols by opposite sides
//of the connection. This usually is under caused by incorrect
//the Net8 administrative setup for the database links or external
//procedure calls. The most frequent specific causes are:
//-- the Database link setup for an Oracle - to - Oracle connection
/home/connects to a Heterogeneous Services agent
//or an external procedure agent.
//-- the Database link setup for a Heterogeneous Services connection
/home/connects directly to an Oracle server.
//-- The extproc_connection_data definition in tnsnames. Ora
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull