Http://blog.csdn.net/lizhenhuatop/archive/2008/09/27/2986303.aspxFYI
For historical reasons, Oracle had no Chinese character sets (such as oracle6, oracle7, and oracle7.1), but some users used the database since then, and
You can use the us7ascii character set to store Chinese characters, or you may choose a default character set, such as we8iso8859p1 or
Us7ascii, and these two character sets do not have Chinese character encoding. Although this chara
, the 11.2.0.1 RAC that is installed on the virtual machine is chosen 11.2.0.1 because of problems with public IP and private network segments. During the installation instance, the computer crashes and restarts, and CRS fails to start.
[Root@rac1 bin]#./crsctlstart CRS
Crs-4124:oracle highavailability Services startup failed.
Crs-4000:command startfailed, or completed with errors.
[Root@rac1 bin]# Ps-ef|grep has
Root 8081 1 0 03:14? 00:00:00/u01/ap
From:https://support.oracle.comWhat is "Oracle javavm Component Database PSU"?Oracle JAVAVM Component Database PSU is released as part of the Critical Patch Update program from October onwards.IT consists of separate patches:
One for JDBC clients-applicable to client, Instant client, Database and Grid oracle_homes.This is a referred to as "JDBC Patch" in the rest of this document.
One for the
first, start and stop Oracle Stopping and starting Oracle needs to be switched to Oracle users so that no other user has permission to start and stop Oracle (including root and no permissions). 1. Run Sqlplus without logging on to Oracle:Sqlplus/nolog2. Connect to the Oracle
2014-07-26 BaoxinjianI. Basic concepts of Oracle Architecture
1. Oracle's overall architecture is divided into three parts
The first part: System Global Area (SGA)
Part Two: program Global zone and background process
Part III: Oracle's Files
2. From functional angle to those division
Storage structure
Includes: Control files, data files, and log files
Role: These files form the physical storage str
How to uninstall oracle and uninstall oracle
Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of oracle. It still occupies a major share in the database market. Lawren
An error occurred when connecting to the Oracle database with Navicat: ORA-28547: connection to server failed, probable Oracle Net admin error
The following error occurs when you use Navicat to connect to the Oracle database:
The version of oci. dll is incorrect. Because Navicat connects to the Oracle server throug
1. Create a crontabsu for an Oracle user
1. Create a crontabsu-root crontab-u Oracle-l */5 *****/home/oracle/oracle_backup.sh for an oracle user (this task is executed every five minutes ).
1. Create a crontab for an Oracle userSu-root
Crontab-u
According to the ghost sub-requirements, the original use of Oracle alone to send and receive mail was abandoned (the previous article described the specific implementation), instead of using Oracle to call Java, and use javamail to implement the relevant procedures of mail. This problem occurs. I have written Java and PL/SQL, but I have never heard of using Oracle
I made a C # And Oracle system, and it was really troublesome to install an Oracle client on each client. So I searched the internet and checked whether there was a method for not installing the client, oracle has long thought of this problem. He has provided simplified clients of various versions on his website. The client can be connected only with dozens of me
7. oracle learning starter Series 7-network management and configuration, 7. oracle Network Management
Chapter 7 of oracle learning starter Series
Network Management and Configuration
In the previous article, we learned about models and users, including the definition of models and the role of models. In this article, I will take a look at the network management
View and modify the Oracle encoding format and modify the oracle encoding formatZookeeper first checks the encoding of the oracle databaseSQL> select * from nls_database_parameters where parameter = 'nls _ CHARACTERSET ';PARAMETER--------------------VALUE--------------------NLS_CHARACTERSETAL32UTF8This is derived from props $, which indicates the character set of
Oracle date weekly explanation and weekly start and end time calculation, oracle End Time
1 ORACLE weekly knowledge description
1.1 date formatting Functions
TO_CHAR (X [, FORMAT]): Convert X to a string in FORMAT. X is a date, and FORMAT is a string that specifies the FORMAT used for conversion. The FORMAT is related to the week W, WW, IW, D, FMWW.
WThe week o
Oracle batch export AWR reports, oracle export awr
Work requirement: in the project, all the AWR reports in the production database must be dumped and imported to the database for testing convenience. The AWR report in the test database needs to be exported one by one based on dbid and Instance name. If you encounter a lot of problems with the RAC system, it will be very troublesome. I found some scripts o
Oracle cross-database query replication table data distributed query, oracle
Method 1:
Currently, most databases require distributed queries. The following describes how to configure cross-database access in oracle.
For example, there are two database servers and two databases are installed. Database server A and B. Now, database A accesses database B.
Step 1Conf
Oracle Performance Analysis 8: Creating indexes and oracle performance indexes
When creating an index, we often want to estimate the index size to evaluate the impact on the existing engineering environment. We also hope that the index creation process will minimize the impact on the running engineering environment, you can also view the index status.Estimate index size
The best way to estimate the index si
In oracle, how does one view the permissions granted to a role ?, Oracle Grant
In oracle, how does one view the permissions granted to a role?
Select * from dba_role_privs; grant roles to users and other roles
Select * from dba_sys_privs; grant system permissions to users and other roles
Select * from dba_tab_privs; all permissions on objects in the database
Ref
ArticleDirectory
Making Oracle Spatial your default geometry Schema
How does ArcSDE use Oracle Spatial? (How to use Oracle Spatial in ArcSDE) ArcSDE supports Oracle Spatial or Oracle locator for storing and managingGeometry in an
If the database uses the ASM file system for management, it may be difficult to download and upload files. Even if the asmcmd tool is used, there is no command similar to CP to copy files, oracle provides FTP to manage a series of ASM files. Using FTP with Oracle ASM fileshttp: // docs.oracle.com/cd/e11882_01/appdev.#/e23094/xdb22pro.htm?adxdb5537
Oracle Automati
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.