OverviewIn the Oracle installation directory $ home/Network/admin, sqlnet is often seen. ora tnsnames. ora listener. ora files except tnsnames. ora, the detailed usage of the other two files is not well understood by many people.Sqlnet. ora is used
Oracle Management and Maintenance. Install, create, start, and close the database Frequently Asked Questions (1)
20070605
Papayas
I. Content Overview
This article describes how to solve common problems during Oracle Installation and database startup
Linux_x64 install Oracle11g (full version), linux_x64oracle11g
1. Modify core operating system parameters
Perform the following steps under the Root user:
1) modify the user's SHELL restrictions and modify the/etc/security/limits. conf file
Enter
Hardware configuration:Two Lenovo 82550-wide T630 servers (standard, each server has two intel NICS)The SUREFIRE200R array cabinet is equipped with 13 18 GB hard disks. It will be used as a cluster DiskNetwork requirements:· Unique NetBIOS cluster
1. Download the real-time client that suits your system first. You can download the client from the address below. 2. Directly decompress the package to the directory you want to store, such as C: instantclient_11_23. Edit the environment variable
PDO's MySQL Tutorial database tutorial Operation class
* The Dbconfig class is responsible for configuring database access information, including: Server address, port, DB instance name, user name, user password, character set, and so on.
* The
Recently, vs2008 was installed in the notebook, and its SQL server2005 was used for learning. NET database operations, but the notebook has not been used for a long time, the keyboard has been broken, several keys did not respond, so yesterday ran
After successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even experience very bad conditions, by disabling non-essential Oracle services, you can speed up your
Installation environment
Linux Server: SuSe10 sp2 64-bit
Oracle Server: Oracle11gR2 64-bitSystem Requirements
Requirements for installing Oracle in Linux
System Requirements
Description
Memory
Physical memory must be
1. First download the oracle 11g x64 bit package from the official website.
:
Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip
Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip
2
-- Suppose that the database instance name is "osmdr"
-- In the database instance
When trying to create a new spfile from a pfile under sqlplus
SQL> Create spfile = '+ Data/osmdr/spfileosmdr. ora' from pfile = '/home/Oracle/osmdr. init ';File
The description of the status in lsnrctl, lsnrctlstatus
LSNRCTL> statusConnecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = lixora) (PORT = 1521 )))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux:
Oracle Data Guard provides one or more slave databases for the production database (a copy of the database ), to ensure that data is not lost when the master database is unavailable or when exceptions occur, and continue to provide services through
Oracle's Optimal Flexible Architecture (OFA) refers to the naming conventions and storage location rules for Oracle software and database files and folders. It can be used as a group of good habits, so that users can easily find the file structure
Oracle 11.2.0.3 is selected for this installation. A total of seven installation packages are downloaded. The first two installation packages must be used for separate database installation. The installation steps are as follows:
1. Copy the
Building Database Clone objects is a common daily O & M requirement. During actual development and testing, you often need to quickly copy a database environment containing business data. Previously, we have introduced how to use the RMAN Duplicate
Project error due to Oracle 10g empty table export failure -- the table or view does not exist, oracle10 g View
This afternoon, the data in the remote database is exported and imported to the local database. After the deployed project connects to
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.