Trace file E:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_6820.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit 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
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:18777M/32767M, Ph+PgF:51202M/65533M
VM name : VMWare Version (6)
Instance name: orcl
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:() 2017-10-24 09:05:57.391
*** SERVICE NAME:() 2017-10-24 09:05:57.391
*** MODULE NAME:() 2017-10-24 09:05:57.391
*** ACTION NAME:() 2017-10-24 09:05:57.391
Network protocol error on first data after new connect
Probable error (ORA-28546) in network administration
uj5u.com熱心網友回復:
Quote: $ oerr ora 28546
28546, 0000, "connection initialization failed, probable Net8 admin error"
// *Cause: A failure occurred during initialization of a network connection
// from the Oracle server to a second process: The connection
// was completed but a disconnect occurred while trying to
// perform protocol-specific initialization, usually due to
// use of different network protocols by opposite sides
// of the connection. This usually is caused by incorrect
// Net8 administrative setup for database links or external
// procedure calls. The most frequent specific causes are:
// -- Database link setup for an Oracle-to-Oracle connection
// instead connects to a Heterogeneous Services agent
// or an external procedure agent.
// -- Database link setup for a Heterogeneous Services connection
// instead connects directly to an Oracle server.
// -- The extproc_connection_data definition in tnsnames.ora
// connects to an Oracle instance instead of an external
// procedure agent.
// -- Connect data for a Heterogeneous Services database link,
// usually defined in tnsnames.ora, does not specify (HS=).
// -- Connect data for an Oracle-to-Oracle database link,
// usually defined in tnsnames.ora, specifies (HS=).
// *Action: Check Net8 administration in the following ways:
// -- 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 LISTENER.ORA on the connection end point's host machine
// to assure that this service name or SID connects to the
// correct program.
// -- Confirm in TNSNAMES.ORA or the equivalent service definition
// that service 'extproc_connection_data' does NOT contain
// (HS=), or that the service definition used by a
// Heterogeneous Services database link DOES contain (HS=).
//Quote:
uj5u.com熱心網友回復:
參考 1 樓 minsic78 的回復:
Quote: $ oerr ora 28546
28546, 0000, "connection initialization failed, probable Net8 admin error"
// *Cause: A failure occurred during initialization of a network connection
// from the Oracle server to a second process: The connection
// was completed but a disconnect occurred while trying to
// perform protocol-specific initialization, usually due to
// use of different network protocols by opposite sides
// of the connection. This usually is caused by incorrect
// Net8 administrative setup for database links or external
// procedure calls. The most frequent specific causes are:
// -- Database link setup for an Oracle-to-Oracle connection
// instead connects to a Heterogeneous Services agent
// or an external procedure agent.
// -- Database link setup for a Heterogeneous Services connection
// instead connects directly to an Oracle server.
// -- The extproc_connection_data definition in tnsnames.ora
// connects to an Oracle instance instead of an external
// procedure agent.
// -- Connect data for a Heterogeneous Services database link,
// usually defined in tnsnames.ora, does not specify (HS=).
// -- Connect data for an Oracle-to-Oracle database link,
// usually defined in tnsnames.ora, specifies (HS=).
// *Action: Check Net8 administration in the following ways:
// -- 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 LISTENER.ORA on the connection end point's host machine
// to assure that this service name or SID connects to the
// correct program.
// -- Confirm in TNSNAMES.ORA or the equivalent service definition
// that service 'extproc_connection_data' does NOT contain
// (HS=), or that the service definition used by a
// Heterogeneous Services database link DOES contain (HS=).
//Quote:
之前看到這個了 不知道怎么去解決。
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/80554.html
標籤:基礎和管理
上一篇:oracle listener.log 提示的什么問題?
下一篇:Tableau 怎么連接 Cassandra 資料庫