) Configure as the mode of the documentShutdown immediate;startup Mount;ALTER DATABASE Archivelog;ALTER DATABASE open;Alter system set log_archive_dest_1= ' location=/u01/archive ' Scope=both;3) Configure log mode (turn on mandatory and supplemental log mode)ALTER DATABASE add supplemental log data;ALTER DATABASE force logging;4) View the configuration results:Sql> select log_mode,supplemental_log_data_min,force_logging from V$database;Log_mode Supple
client, as well as the Oracle names server. The common client configuration in Oracle is the local service name. This article describes the configuration based on the local service name.
III,
Oracle
Network Connection configuration
Lab environment:
Source end:
Ip: 192.168.40.10
DataBase: Oracle 11.2.0.1.0 ORCL
OS: OEL5.6
OGG: fbo_ggs_Linux_x86_ora11g_32bit
Target end:
Ip: 192.168.40.128
DataBase: 10.2.0.1.0 ORCL
OS: OEL5.6
OGG: fbo_ggs_Linux_x86_ora11g_32bit
First, configure the environment variables on the two machines, and add the following content to make it take effect:
Export GGATE = $ ORACLE_BASE/ogg
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib: $ GGATE
The path is
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 mod
: 1521Password for SYS user:Password for SYSMAN user:
Do you wish to continue? [Yes (Y)/no (N)]: ySep 6, 2010 4:43:30 oracle. sysman. emcp. EMConfig performINFO: This operation is being logged at/u01/export toollogs/emca/online/emca_2010_09_06_16_42_52.log.Sep 6, 2010 4:43:31 oracle. sysman. emcp. EMReposConfig invokeINFO: Dropping the EM repository (this may take a while )...Sep 6, 2010 4:46:23
://wenku.baidu.com/view/e0e569c3bb4cf7ec4afed0db.html2. ConfigurationOn the server side, follow these steps:Select Net Manager, and thenAlways default Next,Ii. Oracle Client Installation and configurationInstallation is very simple, directly select the second item, has been the default next, until completed.Configuration:Select Net Configuration Assistant, and th
-11.1.0.7.0.zip (1,562,261 bytes)
2) * Instant Client package-SQL * Plus: additional libraries and executable for running SQL * Plus with instant client, which is a support package for SQL * Plus.
Instantclient-sqlplus-win32-11.1.0.7.0.zip (789,617 bytes)
3) * Instant Client package-SDK: Additional header files and an example makefile for developing Oracle Applications with Instant Client, SDK package.
Instantclient-sdk-win32-11.1.0.7.0.zip (1,068
Solution:
1. After the installation of Oracle, first to modify the character set.
To modify the character set, use the command-line line to log on to Oracle, and then use Sqlplus to connect to Oracle, at which point configuring the Oracle profile is the first step, and I have the correct
classic block, but the operating system is 5. x or 6.x, but the database is 10. x or 11.x.
The following is a simple record and summary of the installation process.1. First install oracle10g1. Create a group required for oracle InstallationRoot User executionGroupadd oinstallGroupadd dbaGroupadd rule2. Create an oracle userRoot User executionUseradd oracle-g oin
profile name is typically: Tnsnames.ora, default path:%oracle_home%\network\admin\tnsnames.ora In the Cgdb and STDCG is the corresponding tns,host is to point to the database server IP, of course LAN with the computer name is also possible. When you create a connection service to a database server through client Net Manager, you actually add a TNS content to the Tnsnames.ora file. Detailed configuration f
configuration in Oracle is the local service name. This article describes the configuration based on the local service name.
Iii. Oracle network connection Configuration
Both the Oracle server and client can be configured in thei
the default port of oracle. To access this address, you will see the following interface asking you to enter the user name and password:
I forgot to mention it above. For accessing the local Oracle database. The connection identifier does not need to be written. If you want to access the oracle of another machine, enter the connection identifier here. Enter
11.2.0.4.0-Production
Check whether the current vault is installed and view the v $ option view.
SQL> select * from v $ option where parameter like '% Vault % ';
PARAMETER VALUE-----------------------------------Oracle Database Vault FALSE
Shut down the database, listener, and DB Console before installing the configuration.
-- Listener[Oracle @ SimpleLinux ~] $
executed by Oracle OCM (Oracle Configuration Manager) at night.
OCM is a working Component in Oracle that provides some configuration parameter assistance. After installing the database, we can see that the user schema list conta
Sde-P Sde-s zongzhan-6auly1-h d: \ arcgissde \ ArcSDE \ sqlexe \
The above command is required to load the required table required by SDE into the SDE database.
9. Run the command (or in the bin directory) sdeservice-o create-P Sde-l @ zongzhan-6auly1-h d: \ arcgissde \ ArcSDE \ sqlexe \-I my_sde
10. Modify the file D: \ winnt \ systerm32 \ drives \ ect \ Services to open it with notepad and other tools. Add the following two lines:
Esri_sde 5151/tcp # ArcSDE
My_sde 5154/tcp # my_sde
Modify the
? Configure backup settings with Oracle Enterprise Manager? Enable automatic backup of control files? Configure the backup destination? Assign a channel to a tape target? Configure Backup Optimizations? Create a compressed backup? Create an encrypted backup
Configuring persistent settings for Rman
? RMAN has preset default configuration settings. Us
define the communication port of the Manger Process
-- This is the minimal configuration of ManagerPORT 7809
-- Annotations are followed.
Start the Manager Process
GGSCI (localhost. localdomain) 14> start mgrManager started.
View the Manager Process
GGSCI (localhost. localdomain) 17> info mgrManager is running (IP port localhost. localdomain.7809 ).
Stop the
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.