ORA-12345: user string lacks CREATE SESSION privilege in
database link (linkname string)



ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)..

Answer / guest

Cause: There are several possible causes for this message:
First, you will get this message if your username in the
second database specified was not granted the CREATE SESSION
system privilege. Second, you will get this message if the
username specified in the connect string of the database
link definition was not granted the CREATE SESSION system
privilege.

Action: The action you take depends upon the cause of the
message: In the first case, ensure that your username in the
secondary database was granted the CREATE SESSION system
privilege. In the second case, ensure the username specified
in the connect string of the database link definition was
granted the CREATE SESSION system privilege in the secondary
database.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06303: IPA: Message send error

1 Answers  


LSX-00237: invalid Name "~S"

1 Answers  


ORA-13000: dimension number is out of range

1 Answers  


ORA-32102: invalid OCI handle

2 Answers  


ORA-25105: RECOVERABLE option can only be used with ALTER INDEX REBUILD

1 Answers  






NNL-00048: Error opening file: string

1 Answers  


ORA-26675: cannot create Streams capture process string

1 Answers  


ORA-36990: (XSRELGID07) %a workspace object The level relation %1p should be dimensioned by a level dimension.

1 Answers  


ORA-01668: standby database requires DROP option for offline of data file

1 Answers  


ORA-16569: Data Guard configuration is not enabled.

1 Answers  


DRG-12218: section group name missing

1 Answers  


ORA-22902: CURSOR expression not allowed

1 Answers  


Categories