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
The problem occurred when installing Oracle 10g. Later, I asked my roommates to re-send an Oralce 10g Client installation package and install it.
It was possible to use PL/SQL at the beginning. Later, due to work needs, an Oracle database backup was sent from an import colleague at a time, which was run in the command line
An error 6550 occurs when you use the IMP statement for import. The reason for online
Oracle HowTo: how to change the location of Oracle data files in Oracle Database in read-only mode. There are multiple ways to move the location of data files. I have introduced several methods before: Oracle HowTo: in non-archive mode, how does one change the data file location? O
OUI: OracleUniversalInstaller (OUI details can be google) My system: redhatenterpriseserver6.0 my oracle: 10g. 2.1
OUI: Oracle Universal Installer (OUI details can be google) My system: redhat enterprise server 6.0 my oracle: 10g. 2.1
OUI: Oracle Universal Installer (for details about OUI, refer to google)My syste
1. Install the operating system Oracle Enterprise Linux 5.2
2. Create a user
Create an oracle user, create a dba group and an oinstall Group[Root @ oel_11g ~] # Groupadd oinstall[Root @ oel_11g ~] # Groupadd dbaThen, create a directory/u01/app/oracle under the root directory. We plan to install the Oracle11G software in the/u01/app/
Oracle BASICS (II): user and permission management, and oracle permission management1. Create a user(1) simple creation 1. Permissions: only DBA users have permissions or create user system permissions 2. Syntax:
Create user Username identified by password;
The oracle password cannot start with a number.
3. instance: username-sam_sho and password-sam123
Cre
Recently, the company has changed the computer, and the 10 Gb memory is still quite powerful. First, the Oralce runtime environment is installed on the local machine. I thought it would be very smooth, but there were still some minor problems, record it and help you sort it out. It is also the beginning of the blog. I remember the first time I installed Oracle on Linux, I did not know how many days I had to spend, the installation package was incorrec
It is prohibited to modify anything that involves oracle during the production period ., Time period oracle
This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/44560623
Warning:
It is prohibited to modify anything that involves oracle during the production period.
Description:
A database in
Oracle Database permission management and oracle permission managementPermission management: the default three usernames and passwords in oracle 9: sys change_on_install // the Administrator with the highest permissions: system manager // normal administrator scott tiger // normal user in oracle 10, these three users a
Does the Oracle client need to be installed when php accesses a remote Oracle server? When php accesses a remote Oracle database server, does the php server need to install the Oracle client? ------ Solution ------------------ the server on which your php resides is installed with a client. For example, in linux, it mu
Ubuntu 14.04 Build php5+apache2+oracle Environment A recently developed project that uses Oracle for databases. Oracle itself supports Red Hat, and the support for Ubuntu is not good, and if Ubuntu needs to install Oracle, the system itself needs to do a lot of camouflage, so I'm only going to use the
object|oracle| Access ASP (Active Server Pages) is one of Microsoft's tools for developing Internet applications, a similar HTML (hypertext
Markup Language Hypertext Markup Language), script and CGI (Common Gateway Interface Universal Gateways Interface), but its operational efficiency is
Higher than CGI, programming is easier and more flexible than HTML, and program security and confidentiality are much better than script. Therefore, ASP is the curre
Tags: Oracle database NUMA support 11GR2Enabling Oracle NUMA support in the Oracle DB 11GR2 releaseReference text:Enable Oracle NUMA Support with Oracle Server Version 11gR2 (document ID 864633.1)Suitable for:Oracle database-enterprise edition-version 11.2.0.1 and laterOracl
Label:Oracle NUMA support is enabled on Oracle DB 11GR2 version numberReference Original:Enable Oracle NUMA Support with Oracle Server Version 11gR2 (file ID 864633.1)Application:Oracle database-enterprise edition-version 11.2.0.1 and laterOracle Database-standard edition-version 11.2.0.1 and laterInformation in this document applies to any platform.Oracle on NUM
1. Application Development)
SQL * Plus E: \ oracle \ ora81 \ bin \ sqlplusw. exe
2. database administration)
Database Configuration assistant database configuration ASSISTANT: Create, configure, and delete Databases
DBA studio integrates multiple database tools into one applicationProgram. DBA studio manages the following objects:
Examples: including startup, shutdown, and routine routines.
Solution: includes tables, indexes, and oracle8 o
Oracle memory structure, oracle Structure
The memory structure of Oracle is divided into SGA and PGA. SGA is dynamically allocated. It is configured by the sga_max_size parameter and allocated when the oracle database instance is started, share an SGA for all session connections; For PGA, each user creates a PAG memory
Oracle problems-Cause Analysis of remote logon Failure and oracle failure
Remote machine:
Install the Oracle computer;
Local Machine:
The computer that accesses the Oracle database on the remote machine.
I. Problem Description
Install the Oracle database on a remote computer
From today on, I started to prepare a system to learn about Oracle. In addition to meeting the urgent needs of my work, I also hope to have a good understanding of the profound and profound knowledge of Oracle Database.
Now, I used to write SQL statements for Oracle applications, or use JDBC or other encapsulated database access libraries in Java to call stored p
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.