{"id":1854,"date":"2016-04-05T12:05:12","date_gmt":"2016-04-05T09:05:12","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1854"},"modified":"2016-10-24T12:06:24","modified_gmt":"2016-10-24T09:06:24","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-12300-to-ora-12400","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-12300-to-ora-12400\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-12300 to ORA-12400"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12300 to ORA-12400<\/strong><\/p>\n

\n
ORA-12315: database link type is invalid for the ALTER DATABASE statement<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The database link name you specified on the ALTER DATABASE statement is not an ROM: link. You must specify an ROM: link when using the ALTER DATABASE statement to mount or open a secondary database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-issue the ALTER DATABASE statement using a valid ROM: link to the database you want to mount or open. If a valid ROM: link does not exist, create one using the CREATE DATABASE LINK command. See the Trusted ORACLE RDBMS Guide to Security Features for more information about creating database links using the ROM: link type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12316: syntax error in database link’s connect string<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The connect string in the CREATE DATABASE LINK statement has a syntactical error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop the database link and recreate it using valid syntax. See the SQL Language Reference Manual for more information about the connect string portion of the CREATE DATABASE LINK statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12317: logon to database (link name\u00a0string<\/i>) denied<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There are several possible causes for this error. First, you can get this error if your username (and password, if you are using database instead of operating system authentication) in the secondary database are not identical to your username (and password) in the primary database. Second, you can get this error if your username in the secondary database is invalid (has not been created). Third, you can get this error if the username\/password combination specified in the connect string of the database link definition is invalid (either not created or has an invalid password).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0In the first case, ensure that the secondary database contains a username (and password, if you are using database authentication) identical to the one you are using in the primary database. In general, you should always use operating system authentication in Trusted ORACLE (see the Trusted ORACLE RDBMS Guide to Security Features for more information about the advantages of OS authentication). In the second case, ensure that your username in the secondary database has been created. In the third case, ensure that the username specified in the connect string has been created in the secondary database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12318: database (link name\u00a0string<\/i>) is already mounted<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You are attempting to mount a secondary database that has already been mounted by your instance.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0to mount it. To establish access, use the ALTER DATABASE <linkname> OPEN command to open the database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12319: database (link name\u00a0string<\/i>) is already open<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You are attempting to open a secondary database that is already open.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The database is open and you need not take additional action to establish access.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12321: database (link name\u00a0string<\/i>) is not open and AUTO_MOUNTING=FALSE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The secondary database that your instance is attempting to mount is not open and automatic mounting has not been enabled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Manually mount and open the secondary database using ALTER DATABASE <linkname> with the OPEN and MOUNT options. Alternately, to allow your instance to automatically mount and open secondary databases, set the AUTO_MOUNTING parameter in the parameter file to TRUE.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12322: unable to mount database (link name\u00a0string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This message should be accompanied by additional error messages that indicate the cause of the problem.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Follow the steps outlined in the accompanying error messages to resolve the problem.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12323: unable to open database (link name\u00a0string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This message should be accompanied by additional error messages that indicate the cause of the problem.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Follow the steps outlined in the accompanying error messages to resolve the problem.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12324: cannot use the ROM: link type on a private database link<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You can only specify the ROM: link type on a public, not a private, database link.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Determine if there is an existing public database link to the secondary database. If not, and if you wish to establish public access to the secondary database, create a public database link to the secondary database using the CREATE DATABASE LINK command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12326: database\u00a0string<\/i>\u00a0is closing immediately; no operations are permitted<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The database you attempted to access is closing, so your operation has been terminated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait until the database has been reopened, or contact the database adminstrator.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-12329: database\u00a0string<\/i>\u00a0is closed; no operations are permitted<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The database you attempted to access is closed, so your operation has been terminated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait until the database is reopened, or contact the database administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12333: database (link name\u00a0string<\/i>) is not mounted<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to open a database that has not been mounted.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Mount the database with the ALTER DATABASE <linkname> MOUNT command, then re-attempt to open the database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12334: database (link name\u00a0string<\/i>) is still open<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to dismount a database that is still open.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Close the database with the ALTER DATABASE <linkname> CLOSE command, then re-attempt to dismount the database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12335: database (link name\u00a0string<\/i>) is not open<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to close a database that is not open.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The database is closed; you can proceed with dismounting it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12336: cannot login to database (link name\u00a0string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You are tyring to login while another user is mounting or dismounting the same database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check to see if the database is in the middle of being mounted or opened and try your login again once the database is accessible.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12341: maximum number of open mounts exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The number specified on the OPEN_MOUNTS parameter in the parameter file exceeds the maximum allowed (255).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the value of this parameter so that it reflects the actual number of possible open mounts to secondary databases. This must be less than 255.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12342: open mounts exceeds limit set on the OPEN_MOUNTS parameter<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The number of currently open mounts exceeds the value you specified on the OPEN_MOUNTS parameter.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Increase the value of the OPEN_MOUNTS parameter so that it accommodates the maximum possible number of open mounts to secondary databases.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12345: user\u00a0string<\/i>\u00a0lacks CREATE SESSION privilege in database link (linkname\u00a0string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12350: database link being dropped is still mounted<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a ROM: database link that was still mounted and\/or opened.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Close and dismount the database and then re-issue the drop statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12351: cannot create view using a remote object which has a remote object reference<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to create a view which references a remote object which, in turn, references an object on another database. Since the view that you tried to create references a remote object, that object cannot reference an object on another database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose a different object to reference in your view or change the remote object so that it does not reference another database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12352: object\u00a0string<\/i>.string<\/i>@string<\/i>\u00a0is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to reference (compile against) an object of a secondary database but the object is invalid and the system cannot validate or recompile it because it is in a secondary database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Manually recompile the invalid object in the secondary database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12353: secondary stored object cannot reference remote object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to either select from a remote view or execute a remote procedure which references an object on another database. Since the remote view or procedure is on a secondary database, an additional reference to another database cannot be done.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose a different object to reference or change the remote view or procedure so that it does not reference another database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12354: secondary object being dropped<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to access a object (for example, a table or view) on a secondary database that was in the process of being dropped.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Repeat the operation. If you receive this message again, try to access the object from the secondary database. If you receive an internal error or a trace file, contact Oracle WorldWide Technical Support.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12300 to ORA-12400 ORA-12315: database link type is invalid for the ALTER DATABASE statement Cause:\u00a0The database link name you specified on the ALTER DATABASE statement is not an ROM: link. You must specify an ROM: link when using the ALTER DATABASE statement to mount or open a…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1854","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-tU","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1854","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1854"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1854\/revisions"}],"predecessor-version":[{"id":1855,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1854\/revisions\/1855"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1854"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}