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-06930: CMX: error when checking ORACLE_SID

1 Answers  


ORA-13706: Invalid value "string" specified for parameter "string" in "string" analysis mode.

1 Answers  


ORA-04050: invalid or missing procedure, function, or package name

1 Answers  


DRG-10833: feedback failed

1 Answers  


NNO-00118: line string: data length string exceeds maximum of string, data ignored

1 Answers  






ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an object type

1 Answers  


ORA-15171: invalid syntax in the alias path after 'string'

1 Answers  


ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based

1 Answers  


ORA-30679: JDWP-based debugging not supported in this configuration

1 Answers  


PLS-00651: implementation type in Aggregate/Table function should be a valid type

1 Answers  


RMAN-06598: conversion between platforms 'string' and 'string' is not needed

1 Answers  


LSX-00120: value is not valid restriction of parent's maxLength

1 Answers  


Categories