Skip to content

ORA-00022 While Accessing Shared DB Link

SYMPTOMS

Application team created a shared public database link, while accessing the link , they are getting below errors.

ERROR at line 1:
ORA-00022: invalid session ID; access denied
ORA-02063: preceding line from <DBLINK-NAME>
Process ID: 59963
Session ID: 291 Serial number: 12343

 

CHANGES

 

CAUSE

BUG 18759589

SOLUTION

Please apply the below patch and  let me know in case of any issues..

Patch 18759589: ESSC: ORA-22 AFTER UPGRADE FROM 11.2.0.2 TO 11.2.0.4

Release Oracle 11.2.0.4.0

Platform Linux x86-64

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: