Skip to Main Content

Oracle Database Discussions

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!

SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0 Unable to proceed

Noname123Jun 23 2016 — edited Jun 26 2016

When I opened (loaded) the application web page , I got this error:  Error connecting to database PROD: ORA-10

I checked the applications it was up except the concurrent manager due to the fact that  the database is down.

I checked the listener it was up

I checked the database , it was down...

So i tried to bounce the apps and database

Workaround:

1-Shut down the applications

2-Attempted to stop the listener, then I got the following error:

lsnrctl: error while loading shared libraries: libclntsh.so.10.1: wrong ELF class: ELFCLASS64

While cannot connect to database using sqlplus. Coming up with the following error in a trace file even though proper permission are set:

error 7274 detected in background process

ORA-07274: spdcr: access error, access to oracle denied.

Linux-x86_64 Error: 13: Permission denied

I have set the permission of "oracle" but got the following error:

SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0

Unable to proceed

Know that I have sourced the environmental variables before using lsnrctl and sqlplus

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2016
Added on Jun 23 2016
7 comments
1,770 views