Label:Database version: 11.2.0.4Server version: RedHat6.4Main Library Primary: Installing database software and examplesStandby standby: Install only database software First, the pre-erection of the main standby storage environment:Main Library Primary: [Email protected] dbs]$ Cat/home/oracle/.bash_profile#. Bash_profile
# Get The aliases and functions
if[- F~/.BASHRC]; Then. ~/.bashrcfi
# User specific environment and startup programsPath=$PATH:$HO
:
Database write (dbw0 or dbwn)
Log write (lgwr)
Detection point (ckpt)
System Monitoring (SMON)
Process Monitoring (pmon)
Archive (arcn)
Restore (reco)
Lock (lck0)
Work Queue (snpn)
Queue monitoring (qmnn)
DISPATCHER (dnnn)
Server (snnn)
Oracle memory structure (SGA)
The SGA structure is:
Data High-speed buffer l redo log buffer l sharing pool l large sharing pool (optional)
Data Dictionary Buffer l other data buffer
2. 3.
Oracle-07445 [kgghash]: Oracle BUG causes the process to be killed when updating the LOB FieldSymptom:The user reports that a DB connection is accidentally killed. The following information is found in the alert Log during troubleshooting:Mon Apr 22 14:49:58 2013Exception [type: SIGSEGV, Address not mapped to object] [ADDR: 0x2B1733615000] [PC: 0x777EE03, kgghash () + 367]Errors in file/
manage spatial information, collectively known as the Data Archive (Repository). As an example of Oracle database-based ARCSDE, the repository contains a data dictionary table, stored procedures, and several. dll files under the SDE user. A data dictionary table that stores metadata information such as feature classes, Feature class fields, feature class projections, feature class scopes, and stored procedures and. dll to implement GIS operations and
Tags: multiple compare loghome how net specific number ora 1. Generate a single-instance AWR report:@ $ORACLE _home/rdbms/admin/awrrpt.sql2. Generate the Oracle RAC AWR report:@ $ORACLE _home/rdbms/admin/awrgrpt.sql3. Generate an AWR report for a specific DB instance in t
$ ORACLE_HOME/rdbms/lib
Run the following command to view the options status:
% Ar-T libknlopt. A | grep-c {file}
The file parameter can contain the following content:
RAC-kcsm. oRat-kecwr. oOLS-kzlilbac. oDV-kzvidv. oASM-kfon. oOLAP-xsyeolap. oPart-kkpoban. oCTX-kciwcx. o
Example:
Non-Aix environment:
% Ar-T libknlopt. A | grep-C kcsm. o
AIX environment:
% Ar-x64-T libknlopt. A | grep-C kcsm. o
If the returned value is 0, option is disabled,
If
In Oracle, various components (listeners, database instances, and various configuration tools) are installed and run with Log and Trace files generated. Before Oracle 11g, the information was scattered in the Oracle component directory. At 11g, Oracle introduced the concept of ADR (Automatic Diagnostic Repository), whi
point of the shared library mapped_ase. The starting point of SGA is at least 0.05g higher than the starting point of the shared library, otherwise, the database cannot be started or crashed.
Disable OracleSu-OracleCD $ ORACLE_HOME/rdbms/lib
Modify the file definition of the shared library load address
Genksms-S 0x12000000> ksms. s
Compile the target file
Make-F ins_rdbms.mk ksms. o
Recompile the oracle ex
diskgroup. You can also use SQL commands to create or modify this attribute for a disk group. The method is as follows: alter diskgroup goldengate set attribute 'compatible. asm '= '11. 2.0.2 '; alter diskgroup goldengate set attribute' compatible. rdbms '= '11. 2.0.2 '; alter diskgroup goldengate set attribute' compatible. advm '= '11. 2.0.2'; 2. Create an Oracle ADVM volume and switch to the grid user. G
to write a program
Minimum limited header files (include), object files (objects), and library files (libraries) you want:
$ORACLE _home/lib/*
$ORACLE _home/rdbms/demo/*
$ORACLE _home/rdbms/lib/*
I set oracle_home on my machine for/usr/local/
Hello, Heroes.Really helpless, in this request you have Oracle customer service number of friends to help download the following patch, thank you! Can be shared with the cloud disk to me, thanksOracle Database Network foundation Component Remote denial of service Vulnerability 1Oracle Database "Ctxsys. Drvdisp "Local privilege elevation vulnerability 1Oracle Database Server Remote core RDBMS Vulnerability
Oracle dbca times: ORA-12547: TNS: lost contact error resolution, dbcaora-12547
Preface
Recently encountered a problem in the work, the error is Oracle dbca reported error: ORA-12547: TNS: lost contact, by looking for relevant information finally found the solution, below to share with you, let's take a look at the detailed introduction.
Environment:
X86-64bit OS: RHEL6.5
DB: 11.2.0.4 for Linux 86-64bi
.dbf ' SIZE 500MEXTENT MANAGEMENT LOCAL UNIFORM SIZE 10MNoarchivelog1000 MaxdatafilesCHARACTER SET UTF8National CHARACTER SET UTF8maxlogfiles; Database created.5 Create a data dictionary:Sql> @?/rdbms/admin/catalog.sql;Sql> @?/rdbms/admin/catproc.sql;Sql> @?/sqlplus/admin/pupbld.sql;6 Start the database to ensure that the current instance is a new instance:sql>exit;[Email protected] ~]$ Oracle_sid=mydb[
About OracleOracle Database, also known as Oracle RDBMS, or Oracle. is a relational database management system of Oracle Corporation. It is a leading product in the field of database. It can be said that Oracle database system is currently the world's popular relational data
$ logmnr_contents. Before using the LogMiner tool to analyze the redo log file, you can use the DBMS_LOGMNR_D package to export the data dictionary as a text file. This dictionary file is optional, but if it is not available, the part of the data dictionary (such as the table name and column name) in the statement interpreted by LogMiner) and numeric values are in hexadecimal format, which we cannot directly understand. To install the LogMiner tool, you must first run the following two scripts,
Bbed is the abbreviation for Block Browser/editor and is an internal tool of Oracle that does not publish documentation and support. Bbed is released with the software, but we need a simple relink to use.
While there are many risks to the use of bbed tools, they can be used properly to solve many tricky problems and to practice techniques such as bad block repair.For example, the Bbed tool in oracle10g also requires manual relink to be used, a
Tags: style blog http color java using OS StrongDirectoryFirst, hardware requirementsSecond, the softwareThird, System installation noteIv. System Readiness prior to Oracle installationV. Install Oracle and set up the settingsSix, upgrade Oracle to Patchset 10.2.0.4Vii. using Rlwrap to invoke the Sqlplus history commandFirst, hardware requirements1. Memory SwapM
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.