While creating a new vendor in Oracle Applications, the following error appeared:
APP-10000: ORA-12500: TNS:listener failed to start a dedicated server process
ORA-06512: at "PO.API_PUT_ERROR_SP", line 9
ORA-06512: at "PO.API_POVNDHDR_TRG", line 208
ORA-12500: TNS:listener failed to start a dedicated server pricess
ORA-04088: error during execution of trigger 'PO.API_POVNDHDR_TRG' occurred in AP_VENDORS_PKG.INSERT_ROW<-APXVDMVD with parameters (ROWID = , VENDOR_ID = 10282) while performing the following operation:
Insert into PO_VENDORS
The following steps were taken to troubleshoot the issue:
1. Ensured the respective Oracle services were running properly (OracleServicePROD, OracleStartPROD, the Concurrent Manager and TNS Listener) by stopping and restarting them.
2. Obtained TNS-12500 troubleshooting document from Oracle’s Metalink website and ensured that all items on the list were resolved.
3. Checked the Event Log on EWSD1PROD for error messages.
4. Checked Oracle’s ALERT.LOG file on ORA errors messages.
5. Ran ScanDisk on the E: of the EWSD1PROD (Oracle Financials) server.
6. Checked the SQL code in the procedure “PO.API_PUT_ERROR_SP”, which appeared in the error message. This showed that the procedure was attempting to access the MAXIMO instance.
7. Completed the backup on MAXIMO and allowed the Oracle database services on the MAXIMO server to restart.
Solution: Transactions were being pushed from Oracle Applications to the MAXIMO server, which had been shut down. Upon restarting MAXIMO server, the issue was resolved.
0 Comments.