Oracle

Fatal NI Connect error 12170. VERSION Information:TNS for 64-bit windows:version 11.2.0.1.0-productionOracle bequeath NT Protocol Adapter for 64-bit windows:version 11.2.0.1.0-productionWindows NT TCP/IP NT Protocol Adapter for 64-bit

Error 1:ora-01756:quoted string not properly terminated Chinese content cannot be inserted due to inconsistent character set encodingQuery the character encoding settings for the current database:Sql> SELECT * from V$nls_parameters T WHERE

1. ASCII Returns the decimal number corresponding to the specified character; Sql> Select ASCII (a) a,ascii (a) a,ascii (0) Zero,ascii () space from dual; A A ZERO space --------- --------- --------- --------- 65 97 48 32 2. CHR gives the

Usage Scenario: When you need to access data from another SQL Server database from an Oracle database, Oracle provides a tool: gateways. With this tool, you can create dblink to connect to SQL Server or a different company's database----depending on

Oracle Data installation package download https://www.oracle.com/downloads/ Java 8 installation package download Https://launchpad.net/~webupd8team/+archive/ubuntu/java Check if Java has been installed $ java-versionJava Version

Recently, a Java Swing program was written under CentOS and found that the JDBC connection to Oracle in Linux was slow and often failed. But the same program runs very fast under Windows. Online search for a long time and I this situation is not

From: http://2843678.blog.51cto.com/2833678/951331Original works, allow reprint, please be sure to use hyperlinks in the form of the original source of the article, author information and this statement. Otherwise, the legal liability will be

One, Oracle trace fileThere are three types of Oracle trace files, a background alarm log file that records the activity of the background process during startup, shutdown, and operation of the database, such as tablespace creation, rollback segment

In recent projects, the application server migrated to another server, the operating system was upgraded to WIN10, the application publishing site and the WebService site in IIS were configured.The client program called WebService

Case one: Login with SqlplusNormal input username password, will be error, because SYS is a super administrator outside the database, so when we log inTo enter a password: password +as sysdba (for example: 123456 as SYSDBA)Scenario two: Log on with

1. Start and connect the OAGOAG when connecting, except not select analysis, the others are selected, and then launch the gateway instance and NodeManager.The command is as follows: /$OAG _home/apigateway/posix/bin/startinstance-n

SYSTEM. Cursor_block determining current BLOCK in Oracle Forms Using SYSTEM. Cursor_block system variable. The value of the SYSTEM. Cursor_block system variable represents depends on the current navigation unit:If the current navigation unit was the

After installing Oracle, there are several ways to manage the database in Oracle, first of all, landing on the web version of the interface: Https://localhost:1158/em, this way to manage too many things, it is a little inconvenient to use, The

Oracle Video Tutorial Goals      Oracle Video tutorial, wind Brother this set of Oracle Tutorial Training learning the role of Oracle database undo and related data dictionary, undo Automatic Management, DDL and DML operations and undo relationship,

Environment:windows2008 the server, the non-administrator account used, but created a new windows2008 account and installed the Plsql tool.Problem:Use the Administrator account to connect the successful Oracle database with the Plsql tool;However,

In 11g, Oracle provides a new scheduler feature that helps automate job implementation. It can also help you control the utilization of resources and can execute jobs in the database in order of precedence. One limitation of traditional dbms_jobs is

Oracle automatic backup script and Oracle backup script If you don't talk much about it, paste the Code directly. The specific code is as follows: #! /Bin/sh #*********************************** * ****************************** # File: oraclebak. sh

Summary of Common commands for executing scripts in Oracle databases and common commands in oracle 1. Execute an SQL script file Copy codeThe Code is as follows:Sqlplus user/pass @ servicename Or Copy codeThe Code is as follows:SQL> start

Some friends feedback database startup run after a little time, then automatic crash, let us help find the reason, through analysis is because the smon process triggers ORA-600 13013 caused database exceptionsAlert Log error messageThu Aug 4 18:39:44

In the 11g cluster, we usually use the initialization file (pfile) under dbs to specify the actual spfile in asm.[Oracle @ ol6-112-rac1 dbs] $ cd/u01/app/oracle/product/11.2.0.4/db_1/dbs[Oracle @ ol6-112-rac1 dbs] $ lsHc_acfsdb.dat hc_cdbrac_1.dat