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

AMD-00138: level names parameter not null or defaulted

1 Answers  


RMAN-06410: cannot use command when channels are allocated

1 Answers  


ORA-27064: cannot perform async I/O to file

1 Answers  


QSM-01058: MV, string, does not have column, string, for a joinback

1 Answers  


ORA-38769: FLASHBACK DATABASE failed after modifying data.

1 Answers  






ORA-24035: AQ agent string is not a subscriber for queue string

1 Answers  


ORA-02164: DATAFILE clause specified more than once

1 Answers  


IMP-00005: all allowable logon attempts failed

1 Answers  


ORA-29266: end-of-body reached

1 Answers  


ORA-25965: fact table must be included in the from clause

1 Answers  


RMAN-06506: the MAXSETSIZE option cannot be used with a backup backupset

1 Answers  


NNL-00258: Server-generated requests currently do not require authoritative answers

1 Answers  


Categories