Oracle Environment: The public dblink that Oracle 10.2.0.1 creates connects Oracle 11.2.0.3
Ora-01017:invalid Username/password; Logon denied ora-02063:preceding line from
I. Creating Dblink
Create Public database link dmz63
Connect to XYY
These days on business trip to Gansu, a customer cluster a little problem. The CRS detection of the nodes found a bit unusual, but it was strange that the business was not affected. The following are the results of my tests:
[Grid@tysy1 bin]$
The following are the most recent errors encountered in user data recovery:
2012-03-08 13:56:04.178Ksedmp:internal or fatal errorOra-00600:internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []-----Pl/sql Call Stack-----Object Line
DBMS_METADATA.GET_DDL () is used to get the DDL for the object, as follows.
Note: In Sqlplus, to better demonstrate the DDL, you need to set the following parameters:
Copy Code code as follows:
Set Line 200
Set pagesize 0
Set
Monitor startup error, report the following error:Lsnrctl startLsnrctl for linux:version 9.2.0.4.0-production on 06-jul-2009 14:37:59Copyright (c) 1991, 2002, Oracle Corporation. All rights
--varchar,varchar2
Contact:1.varchar/varchar2 used to store variable-length stringssuch as varchar (20), stored in the string ' ABC ', the field in the database is only 3 bytes, not 20 bytesThe maximum value for 2.size is 4000, and the minimum value
1.1. asm:prcr-1079
The ASM listener startup failed.
The reason for the error:
The Ld_library_path variable was not configured to cause the Oraagent.bin to be unable to locate the library file.
Workaround:
Configure the Ld_library_path variable.
What is the difference between startup Nomount and startup Mount in Oracle startup?Answer: Startup Nomount: Launch instance, read parameter file, allocate memory space, start background process, open trace file and alarm file. Startup mount: Mount
Because the requirements involve Oracle's CLOB type field, the merge into statement is always unsuccessful in MyBatis's mapper XML file.Attach Error code Keyproperty= "id" >SELECT to_char (sysdate,' YYYYMMDD ') | |Seq_dr_bcxx.nextval as ID from
In the software development process, programmers often encounter string splicing and splitting work.Take Java development as an example:The foreground passes in a string concatenation of a JSON data, such as: "1001,1002,1003", which may represent a
In general applications, when you need to use table to present data to end users, the consistency of the display ordering of the data in the table greatly affects the customer experience. You typically want implementations such as multiple query
when using the union all connection, if a set of a column nvarchar2 or nvarchar type, and B in the collection does not have such columns, "to replace is the character set mismatch, there are two workarounds, see the following exampleCases:
Http://www.cnblogs.com/songdavid/articles/2067534.htmlWhen calling the EBS standard API, it may be possible to return some incomprehensible errors, such as when I recently developed rcv_transaction_interface, the data card is not in the interface
You can display modal windows in Oracle Forms to display normal messages, Error message or asking for confirmation eg. On deleting a record or saving a record etc. using Show_alert command. These modal window messages can be shown using Alert
You want to connect multiple databases in Oracle forms to perform certain tasks, for example you need to execute DDL o R DML statements against databases if you try to use Dblink it gives your error or suddenly quits from the oracle for Ms.
Conn Internal/oracleGrant user aaaa identified by AAAA;Conn AAAA/AAAA will error:Sql>conn AAAA/AAAA will error:ERROR:Ora-01045:user AAAA lacks CREATE SESSION privilege; Logon deniedReason:The user needs at least the right to session, or the
Today, the size of the lower SGA is adjusted, and the result is the following error when restarting the database.Sql>alter system set sga_max_size=1024m scope=spfile;sql> shutdown ImmediateSql> StartupOra-00844:parameter not taking Memory_target to
This is a high quality pre-sale recommendation of Computer class OCA Certification Exam Guide (1z0-061) Oracle Database 12c SQL Foundation ". Oracle Certified Master (OCM) 's latest work, the OCA Certification exam official book, covers all OCA
LoadRunner How to connect to an Oracle databaseRecently doing a test database performance project, directly write out the connection database and database query and insert the scriptIn Vuser_init (connect to database)#include "Lrd.h"Static
Two days ago, a colleague of the database alert log constantly fl the ora-600 [ktbdchk1: bad dscn] error, the impact of the insert statement on a table, not long ago the database storage failure, similar cases are not found in known bugs. The
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service