InLinuxInstalled onOracle
10g
In the future, we will often useIsqlplusTo executeSQLStatement. But normalIsqlplusThe logon interface only supports Logon as a common user.SysIdentity permission to perform some operations, then how can weSysIdentity to log onIsqlplusWhat about the page?
(1)SetOracleUser'sJavaEnvironment Variable:(Add a line at the bottom of the file)
[Oracle @ ocp
Resume oracle.sh in/etc/profile.d/
The contents are as follows in Nls_lang setup encoding
1 oracle_home=/usr/lib/oracle/12.1/client642 c_include_path=/usr/include/ oracle/12.1/client643 ld_library_path= $ORACLE _home/lib4# RememberThis was the client Nls_lang not the server one5 nls_lang=6 Export Oracle_ho ME Ld_library_path Nls_lang
Then modify the/ETC/INIT.D
, starting at m and intercepting N characters consecutively.---need to note: The database subscript is starting from 1!!!---n is truncated to the end of the current string if the number that is not specified or specified exceeds the actual character length that can be intercepted. n is the length.---if M is negative, it is intercepted from the countdown position. The number at the end cannot be negative.SELECT SUBSTR (' thinking in from dual;--->inSELECT SUBSTR (' thinking in from dual;--->in---
grouping functions displaying data from multiple tables through a connection using subqueries to resolve issues using Set operators manipulating data using DML statements Creating and Managing tables using DDL statements As a translator roopesh ramklass,oracle Certified Master (OCM), specializes in infrastructure, middleware and database architecture technologies. Translator sequence In today's society, the certification of IT industry c
1. Why Learn Oracle?
Superior Performance:
Small database
Medium Database
Large database
Acess, Foxbase
MySQL, SQL Server, Informix
Sybase, Oracle, DB2
Small complexity (within 100 people), within the cost of thousands of dollars, the security requirements are not high
Daily visit Volume 5000--15000,
First, bbed tools
Installation of 1.BBED
Oracle 11g missing bbed package, oracle11g bbed Install and example
1. Upload (SBBDPT.O ssbbded.o BBEDUS.MSB, the three files copy the linux64 version of Oracle) files
$ORACLE _HOME/RDBMS/LIB/SSBBDED.O
$ORACLE _HOME/RDBMS/LIB/SBBDPT.O
$ORACL
1. Oracle Overview-Oracle Database, referred to as Oracle. Oracle (Oracle) is an object-relational database management system (ORDBMS) in the United States. Currently occupies a major share of the database market.-Oracle's history: 1977 Ellison and two friends, established R
Oracle BASICS (9) Oracle architecture and oracle infrastructure
1. Oracle Architecture Overview:
Oracle architecture refers to the composition, working process and principle of the database, as well as the organization and management mechanism of data in the database. To und
Oracle 10g AND Oracle 11g manual database creation case -- Oracle 11g
System Environment:
Operating System: RedHat EL6
Oracle: Oracle 10g and Oracle 11g
Manual database creation is relatively easy to implement. In this case, we
Oracle
Oracle Diagnostics Case-spfile case A
Link
Http://www.eygle.com/case/spfile.htm
Description of the situation:
System: SUN SOLARIS8
Database version: 9203
Problem Description: The engineer reports that the database does not start properly when it restarts. The check found that the Undo table space is missing.
The problem diagnosis and resolution process are as follows:
1. Login system Check Al
Buy Oracle Database Course package and enjoy 85 discount!!Package Address: http://edu.51cto.com/pack/view/id-807.htmlPerformance optimization for Oracle 11g R2 databaseDatabase performance problem is the most discussed topic in database field, because it involves database principle, IO storage, server performance, foreground application and so on, so the performance problem is very test the optimization of
Oracle Exams IntroductionThe OCP (Oracle Certified Professional) is an authoritative and professional technical standard promulgated and implemented by Oracle, which is designed to certify those who are able to meet the service and support of Oracle core products, and has a
Disclaimer: This article transfers from the network article, reproduced this article only for the personal collection, shares the knowledge, if has the infringement, please contact the blogger to delete.Original LeshamiOriginal address: http://blog.csdn.net/leshami/article/details/5529239--========================================== --oracle Instances and Oracle Databases (
Oracle Cluster Concepts and principles (ii)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review rev
client, the user is responsible for passing the user's SQL statement to the service process and retrieving the query data from the server segment.5. oracle routine: The Oracle routine consists of the SGA memory structure and background processes used to manage the database. A routine can only open and use one database at a time.6. SCN (System Change Number): System Change Number, a serial Number maintained
Oracle 10g AND Oracle 11g manual database creation case -- Oracle 10g
System Environment:
Operating System: RedHat EL6
Oracle: Oracle 10g and Oracle 11g
Manual database creation is relatively easy to implement. In this case, we w
Label:Oracle 11G RAC Database installation (eight)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review review, the other is easy to use. This doc
Learning Oracle is a long and arduous process. If you are not interested but forced to learn, it is difficult to learn well. To a certain extent, if you want to further improve your knowledge, you have to get in touch with a lot of things outside of Oracle, such as Unix, such as network and storage. Therefore, you must be interested in learning Oracle well. If yo
--==========================================--oracle Instances and Oracle Databases (Oracle architecture)--==========================================/*For the first contact with Oracle database, two concepts that are easily confused are Oracle instances and
the database is opened if necessary.
Process Monitoring: clears resources when an Oracle process fails.
Checkpoint Process: updates the database status information in control files and data files whenever changes in the buffer cache are permanently recorded in the database.
Archiving process: backs up or archives a full log group during each log switch.
Service Process: User process service.
User process: On the client, the user is responsible for pa
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.