Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HotChips 2016 presentation by Oracle: Software in Silicon in the Oracle SPARC M7 Processor

Javed A Mohammed-OracleSep 9 2016 — edited Oct 21 2016

Comments

Check if your Windows temp is not full.
Test the Database connection(SYS) from local or from the same machine where you are installing FMW.
Test the DB connection on FMW machine using SQL*plus and SQL Developer. If you do not have SQL*plus, install the instant client to test the Database connection https://www.oracle.com/database/technologies/instant-client/downloads.html
Check for the DB alert/listener logs if the connection from RCU is made to the Database.
If nothing works, enable SQL*Net tracing and check what is happening post you give DB credentials in RCU.
Thanks, Suresh

SANPAT

Dear Suresh,
Checked all your given 5 points, but didn't find any problem, even able to login.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ppn)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production
Start Date 29-NOV-2021 10:28:50
Uptime 0 days 0 hr. 35 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\App\Oracle19c\network\admin\listener.ora
Listener Log File C:\App\Oracle\diag\tnslsnr\ppn\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ppn.primepak.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ppn.primepak.com)(PORT=5500))(Security=(my_wallet_directory=C:\APP\ORACLE\admin\ppn\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ppn" has 1 instance(s).
Instance "ppn", status READY, has 1 handler(s) for this service...
Service "ppnXDB" has 1 instance(s).
Instance "ppn", status READY, has 1 handler(s) for this service...
The command completed successfully

SQL> SELECT name,VALUE FROM V$DIAG_INFO where name = 'Diag Alert';
NAME--------------------------------------------------------------
VALUE--------------------------------------------------------------------------------
Diag Alert
C:\APP\ORACLE\diag\rdbms\ppn\ppn\alert

sanjay

Moving this thread to a more appropriate area. Posting in "Forms" was not the right place for this issue.

1 - 3

Post Details

Added on Sep 9 2016
0 comments
732 views