The joys and challenges of setting up Oracle Data Guard! Everything seemed
to be going smoothly until, , an error reared its head when attempting to
connect the Data Guard database via Toad and SQL Developer. But fear not,for
every error is but a stepping stone on the path to enlightenment. Let’s dive
into this and uncover the solution together!
Error Encounter!
Upon trying to connect with SQL Developer, we were met with a message:
Upon trying to connect with SQL Developer, we were met with a message:
Error: Status: Failure - Test failed: IO Error: Got minus one from a read call
Meanwhile, our listener.log whispered cryptic clues:
TNS-12518: TNS:listener could not hand off client connection TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux Error: 32: Broken pipe
The Solution: Permission Granted!
[root@oradbhelp bin]# chmod 6751 oracle
If you find yourself in possession of the all-powerful grid user for managing the listener, behold the key to resolution: granting permission on the oracle executable file residing in $ORACLE_HOME/bin. With a flick of the chmod wand and the incantation 6751, we bestowed upon grid the power to execute the oracle file, akin to the revered oracle user.
No comments:
Post a Comment