as4

Modify the parameters of a process share pool

kods.net — Wed, 07 Jul 2010 09:40:34+0000

System environment:
redhat-as4.7
oracle10.2.0.4-RAC

Why changes?
Recent applications have three temporary database problem can not connect, check all nodes alter the log each time a problem was found when a node is recorded alarm log:
Tue Jul 6 14:44:54 2010
WARNING: inbound connection timed out (ORA-3136)

The analysis of awr report found problems with time share pool in the sql area each time doing a different amount of adjustment of a larger, share pool volume being adjusted, top 5 event which is latch: library cache and latch: shared pool episodes, by the experts to analyze the reasons, a great time to visit because of the possibility of greater than, as too much memory sql statements competition, resulting in serious contention on the latch, sga memory had to be adjusted to meet At that time the load. The automatic adjustment process in the sga connection is bound to break, so will the problems mentioned above phenomenon.
Experts suggest to manually set the share pool and the db cache to a reasonable value. The analysis awr report here that the db cache is not a big change, not adjusted for the time being.

Method:

To sys user login rac, perform the following three commands:

Modify the maximum available memory sga
alter system set sga_max_size = 3600M scope = spfile sid ='*';
Modify sga automatically adjust the amount of memory can not be greater than sga_max_size
alter system set sga_target = 3600M scope = spfile sid ='*';
Changes shared_pool_size
alter system set shared_pool_size = 1850M scope = spfile sid ='*';

Then reboot each node, respectively.

Analysis:
1, each node of my biggest rac sga memory sga_max_size originally 3000M, according to my report on the analysis of several issues awr, share pool to use the history of the largest 1792M, db cache maximum use to the 1700M, so need to first adjust the maximum sga memory sga_max_size.
SQL> show parameter sga;

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 3008M
sga_target big integer 3008M
SQL>

2, adjust sga_max_size and sga_target process, I first use the scope = both or scope = pfile parameter to perform, but always error:
SQL> alter system set sga_max_size = 3500M scope = both sid = 'racdb1';
alter system set sga_max_size = 3500M scope = both sid = 'racdb1'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set sga_max_size = 3500M scope = pfile sid = 'racdb1';
alter system set sga_max_size = 3500M scope = both sid = 'racdb1'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

So the test machine for testing, testing machine is a stand-alone, no problem implementing the three parameters, first modify the scope = spfile, then use
create pfile = 'path / init name' from spfile
Want to create a pfile spfile look.
Create pfile pfile and find the content than the more comprehensive than the original, so the production machine by modifying sga before creating a pfile spfile check the parameters of the production machine configuration, but encountered a problem:

SQL> create pfile = '/ opt/oracle/app/admin/racdb/pfile/init.ora.3102009154459-spfile-create' from spfile;
create pfile = '/ opt/oracle/app/admin/racdb/pfile/init.ora.3102009154459-spfile-create' from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
These are like the definition with a new name pfile, error

SQL> create pfile = '/ opt/oracle/app/admin/racdb/pfile/init.ora.3102009154459' from spfile;
create pfile = '/ opt/oracle/app/admin/racdb/pfile/init.ora.3102009154459' from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Pfile name of the original creation, covering the original error pfile

SQL> create pfile = '/ oradata1/racdb/init.racdb1.ora' from spfile;
create pfile = '/ oradata1/racdb/init.racdb1.ora' from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
In each node to create a shared disk, or error

The search to find an article: http://space.itpub.net/519536/viewspace-666453

************************************************** *****************

In the RAC environment, do not use easily "create pfile from spfile;" command to create PFILE.
Because in the RAC environment, by default, the SPFILE will be placed on shared storage (raw device or ASM disk group on), RAC of each host is to use the PFILE to point on the way to complete the SPFILE SPFILE location of the.
By using the "create pfile from spfile;" command to create PFILE, the new generation of PFILE will cover the existing dbs directory PFILE, since database instance startup will no longer be read on the shared storage SPFILE, instead read local PFILE file.

1. By default, $ ORACLE_HOME / dbs directory PFILE initracdb.ora record only a single line, record the SPFILE path to point to.
/ Oracle/app/oracle/product/10.2.0/db_1/dbs $ cat initracdb1.ora
spfile = + DATA / racdb / spfileracdb.ora

2. At this time parameter can be obtained from the database using SPFILE now start the database
SQL> show parameter spfile
NAME TYPE VALUE
--------------- ----------- ------------------------ ------
spfile string + DATA / racdb / spfileracdb.ora

3. At this point if you use "create pfile from spfile;" command to create PFILE, SPFILE original PFIEL point in the database specific parameters will be replaced.
When the database starts again when, because they can not find the SPFILE to location, will use the PFILE 文件 specific parameter values recorded in the boot to complete the database, this will give a database management bring more influence, Buzai enjoy the convenient parameter SPFILE .

4. SUMMARY This article describes a common-sense and I hope everyone in the RAC database maintenance and management of the process should not take unnecessary trouble for himself.
If there is such a problem how to handle it? Method is simple, the PFILE with the SPFILE restore the contents of the content can point to, perhaps in specific scenarios need to re-create the SPFILE.

************************************************** ****************

So that, see my db1 node (or more operations are performed in db1):
SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
spfile string

And she was using its own node pfile file, which is what I want them to turn over a similar setting as before, but by creating pfile spfile has been error, can not figure out what the reasons may be 10G limit?

Method modified according to the article after $ ORACLE_HOME/dbs/initracdb1.ora, the corresponding reference db2 file edits:
SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
spfile string / oradata1/racdb/spfileracdb.or
a

Everything is in order to sys user login rac, implementation of the revised method of share pool the three orders, no error, and then restart the node, respectively, to complete.
After rebooting check:

SQL> show parameter sga;

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 3600M
sga_target big integer 3600M
SQL> show parameter size;

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
bitmap_merge_area_size integer 1048576
create_bitmap_area_size integer 8388608
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_size integer 8192
db_cache_size big integer 0
db_keep_cache_size big integer 0
db_recovery_file_dest_size big integer 0

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
db_recycle_cache_size big integer 0
global_context_pool_size string
hash_area_size integer 131072
java_max_sessionspace_size integer 0
java_pool_size big integer 0
large_pool_size big integer 0
max_dump_file_size string UNLIMITED
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
olap_page_pool_size big integer 0
parallel_execution_message_size integer 2152

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
sga_max_size big integer 3600M
shared_pool_reserved_size big integer 97307852
shared_pool_size big integer 1856M
sort_area_retained_size integer 0
sort_area_size integer 65536
streams_pool_size big integer 0
workarea_size_policy string AUTO
SQL>
SQL> exit

In the second process to solve a problem:
When you start the database error: ORA-32004: obsolete and / or deprecated parameter (s) specified

Search Articles: http://www.souzz.net/html/database/ORACLE/70695.html

************************************************** **********

Today in the learning management archivelog encountered ORA-32004 error, the following is the solution:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete and / or deprecated parameter (s) specified
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 71305460 bytes
Database Buffers 92274688 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.

View oracle given problem description:

SQL> host oerr ora 32004;
32004, 00000, "obsolete and / or deprecated parameter (s) specified"
/ / * Cause: One or more obsolete and / or parameters were specified in
/ / The SPFILE or the PFILE on the server side.
/ / * Action: See alert log for a list of parameters that are obsolete.
/ / Or deprecated. Remove them from the SPFILE or the server
/ / Side PFILE.

To see spfile:

*. Log_archive_format = '% t_% s_% r.dbf'
*. Log_archive_max_processes = 3
*. Log_archive_start = FALSE
*. Log_archive_trace = 4096

Then take a look at alert log file, which the following information:

Deprecated system parameters with specified values:
log_archive_start
End of deprecated system parameter listing

Checked to find information that is oracle 10G has not supported the argument, and when open the archive mode (archive log mode), the ARCH process is hidden automatically set. 10g, 9i, will not appear before the database is in archive mode that, but the file is not automatically set the situation up. To resolve this problem need to reset log_archive_start parameters.

SQL> alter system reset log_archive_start SCOPE = SPFILE SID ='*';
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
Does not restart after a report ORA-32004 error!

See 10g, are those parameters are deprecated in:

SQL> select name, description from v $ parameter where isdeprecated = 'TRUE';
The alert log file mentioned above is located in% ORACLE_BASE% \ admin \% ORACLE_SID% \ bdump in

************************************************** *******************

So double-check alter the log file during startup does trace:
db_name = racdb
open_cursors = 300
sql_trace = FALSE
pga_aggregate_target = 1073741824
Deprecated system parameters with specified values:
sql_trace
End of deprecated system parameter listing

Check the spfile rac file:
[Oracle @ db1 racdb] $ cat spfileracdb.ora
KK5 # + racdb2.__db_cache_size = 1577058304
racdb1.__db_cache_size = 1543503872
racdb2.__java_pool_size = 16777216
racdb1.__java_pool_size = 16777216
racdb2.__large_pool_size = 16777216
racdb1.__large_pool_size = 16777216
racdb2.__shared_pool_size = 1509949440
racdb1.__shared_pool_size = 1543503872
racdb2.__streams_pool_size = 16777216
racdb1.__streams_pool_size = 16777216
*. Archive_lag_target = 1800
*. Audit_file_dest = '/ opt / oracle / app / admin / racdb / adump'
*. Background_dump_dest = '/ opt / oracle / app / admin / racdb / bdump'
*. Cluster_database_instances = 2
*. Cluster_database = true
*. Compatible = '10 .2.0.3.0 '
*. Control_files = '/ oradata1/racdb/control01.ctl', '/ oradata1/racdb/control02.ctl', '/ oradata1/racdb/control03.ctl'
*. Core_dump_dest = '/ opt / oracle / app / admin / racdb / cdump'
*. Db_block_size = 8192
*. Db_domain =''
*. Db_file_multiblock_read_count = 16
*. Db_name = 'racdb'
*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = racdbXDB)'
racdb2.instance_number = 2
racdb1.instance_number = 1
*. Job_queue_processes = 10
*. Log_archive_dest_1 = 'LOCATION = / arch/racdb1'
racdb2.log_archive_dest_1 = 'LOCATION = / arch/racdb2'
racdb1.log_archive_dest_1 = 'LOCATION = / arch/racdb1'
racdb1.log_archive_dest_2 = 'service = standby lgwr async noaffirm'
racdb2.log_archive_dest_2 = 'service = standby lgwr async noaffirm'
*. Log_archive_dest_state_2 = 'enable'
*. Log_archive_format = '% t_% s_% r.dbf'
*. Nls_territory = 'CHINA'
*. Open_cursors = 300
*. Pga_aggregate_target = 1073741824
*. Processes = 1000
*. Remote_listener = 'LISTENERS_RACDB'
*. Remote_login_passwordfile = 'exclusive'
*. Resource_limit = TRUE
*. Sessions = 1105
*. Sga_target = 3145728000
*. Sql_trace = FALSE
racdb1.standby_file_management = 'AUTO'
racdb2.standby_file_management = 'AUTO'
racdb2.thread = 2
racdb1.thread = 1
*. Timed_statistics = TRUE
*. Undo_management = 'AUTO'
*. Undo_tablespace = 'UNDOTBS1'
racdb1.undo_tablespace = 'UNDOTBS1'
racdb2.undo_tablespace = 'UNDOTBS2'
*. User_dump_dest = '/ oradata1 / / trace'
*. Utl_file_dir = '/ oradata1/logmnr'

Navigate to the *. sql_trace = FALSE, proceed as follows:
[Oracle @ db1 racdb] $ sqlplus '/ as sysdba'

SQL * Plus: Release 10.2.0.4.0 - Production on Wed Jul 7 11:37:07 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> alter system reset sql_trace scope = spfile sid ='*';

System altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

Check *. sql_trace = FALSE has been changed:
[Oracle @ db1 racdb] $ cat spfileracdb.ora
9? # + Racdb2.__db_cache_size = 1577058304
racdb1.__db_cache_size = 1543503872
racdb2.__java_pool_size = 16777216
racdb1.__java_pool_size = 16777216
racdb2.__large_pool_size = 16777216
racdb1.__large_pool_size = 16777216
racdb2.__shared_pool_size = 1509949440
racdb1.__shared_pool_size = 1543503872
racdb2.__streams_pool_size = 16777216
racdb1.__streams_pool_size = 16777216
*. Archive_lag_target = 1800
*. Audit_file_dest = '/ opt / oracle / app / admin / racdb / adump'
*. Background_dump_dest = '/ opt / oracle / app / admin / racdb / bdump'
*. Cluster_database_instances = 2
*. Cluster_database = true
*. Compatible = '10 .2.0.3.0 '
*. Control_files = '/ oradata1/racdb/control01.ctl', '/ oradata1/racdb/control02.ctl', '/ oradata1/racdb/control03.ctl'
*. Core_dump_dest = '/ opt / oracle / app / admin / racdb / cdump'
*. Db_block_size = 8192
*. Db_domain =''
*. Db_file_multiblock_read_count = 16
*. Db_name = 'racdb'
*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = racdbXDB)'
racdb2.instance_number = 2
racdb1.instance_number = 1
*. Job_queue_processes = 10
*. Log_archive_dest_1 = 'LOCATION = / arch/racdb1'
racdb2.log_archive_dest_1 = 'LOCATION = / arch/racdb2'
racdb1.log_archive_dest_1 = 'LOCATION = / arch/racdb1'
racdb1.log_archive_dest_2 = 'service = standby lgwr async noaffirm'
racdb2.log_archive_dest_2 = 'service = standby lgwr async noaffirm'
*. Log_archive_dest_state_2 = 'enable'
*. Log_archive_format = '% t_% s_% r.dbf'
*. Nls_territory = 'CHINA'
*. Open_cursors = 300
*. Pga_aggregate_target = 1073741824
*. Processes = 1000
*. Remote_listener = 'LISTENERS_RACDB'
*. Remote_login_passwordfile = 'exclusive'
*. Resource_limit = TRUE
*. Sessions = 1105
*. Sga_target = 3145728000
racdb1.standby_file_management = 'AUTO'
racdb2.standby_file_management = 'AUTO'
racdb2.thread = 2
racdb1.thread = 1
*. Timed_statistics = TRUE
*. Undo_management = 'AUTO'
*. Undo_tablespace = 'UNDOTBS1'
racdb1.undo_tablespace = 'UNDOTBS1'
racdb2.undo_tablespace = 'UNDOTBS2'
*. User_dump_dest = '/ oradata1 / / trace'
*. Utl_file_dir = '/ oradata1/logmnr'

Summary: For the rac, when adjusting system parameters to make use of scope = spfile, then restart each node. This approach than the first modified pfile, pfile created through the spfile, To start the database more than a simple, but difficult problem. This approach is common to use each node of a spfile, management is convenient, but some might not be very flexible when, if the shared spfile corruption, you will receive the impact of rac nodes, 有利必有弊 to flexibility.

LISTENER and EZCONNECT 2009-04-01 21:42:20
Oracle deadlock related 2009-03-30 16:46:54
Turning optimization oracle article 2009-03-26 21:39:35
An example of the use of TKPROF 2009-02-26 01:38:19

oracle em web button garbled

kods.net — Sun, 27 Jun 2010 19:41:02+0000

Oracle 10g provides a Web-based management tool for EM (Enterprise Manager). Today, some linux machine to use a small error, the buttons are all garbled, the system Linux AS4. After some search, online information on proposed changes in many reproduced in the language ie English, so that time can be, but all content will become English. Chinese programming to solve the button below.

1, failure problems when
open http://ip:1158/em, web content in Chinese, but the buttons are all box-type garbage.

Second, problem-solving
1, changing the $ ORACLE_HOME / jdk jre directory under the default font
$ Su - oracle
$ Cd $ ORACLE_HOME / jdk / jre / lib /
$ Ls font *

Which, font.properties is the default font used. You can also see some font. Chinese fonts (specifically, CN, or choose View GB) and other fonts.
Backup Default Font

$ Cp font.properties font.properties.bak
Will replace the Chinese characters of your choice as the default font

$ Cp font.properties. 【Logo】 font.properties Chinese fonts

2, changing the $ ORACLE_HOME / jre
under the default font used to operate the same way as above.

$ Cd $ ORACLE_HOME/jre/1.4.2/lib /
$ Ls font *

$ Cp font.properties font.properties.bak
Will replace the Chinese characters of your choice as the default font

$ Cp font.properties. 【Logo】 font.properties Chinese fonts

3, under the gif files to delete Cache
em which will use these pictures:

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

Problem Summary: Linux install error under the common summary oracle

kods.net — Tue, 15 Jun 2010 23:26:33+0000

Error 1:

/ Tmp/OraInstall2007-12-30_02-16-11PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred ..

The reasons are: lack of support printed graphics dynamic link library libXp.so.6

This error is due to the lack of system installation package, the previous version in RHEL5, you can install the xorg-x11-deprecated-libs package can be, this installation package can be the third CD in the system tray to find (for redhat as4.2 ago, redhat as4. 4 is the fourth CD-ROM)

IXDBA.NET technical community

I downloaded the file as follows:

xorg-x11-deprecated-libs-6.8.2-31.i386.rpm

Error 2:

Exception: java.lang.UnsatisfiedLinkError: / usr/java/j2sdk1.4.2_06/jre/lib/i386/libawt.so: libXt.so.6: cannot open shared object file: No such file or directory
This error is also due to the lack of the system caused by the installation package, just install the XFree86-libs package can be, this installation package can be found in the system CD.

If the above two errors in the redhat as5 version, resolved as follows:

In RHEL5 the above package is libXp replaced, so the rpm-ivh libXp-1.0.0-8.i386.rpm after the package marked with the problem can be solved.

Error 3:

error while loading shared libraries: libstdc + +-libc6.1-1.so.2

Only do the following ln-s libstdc + +-libc6.2-2.so.3 libstdc + +-libc6.1-1.so.2

Reference Case

Case 1:

Tested in the RHEL5 install oracle10g, that before the turn of the 11g, this would be more successful, the result is still two problems.

First of all, in the implementation of the runInstaller, the system error:

You do not have sufficient permissions to access the inventory '/ oracle11g/oraInventory'. Installation cannot continue. Make sure that you have read / write permissions to the inventory directory and restart the installer.: Permission denied

Is used here to create a new way for users 10g 10g, 11g coexist, in fact, when you start the installer, oracle will look for / etc / oraInst.loc and oratab these two files (hp is / var / opt / oracle )

Which is defined in oraInst.loc inventory_loc location and inst_group, as had before installed a 11g, which is the definition of user settings for 11g, so the only error. Solution is the implementation of runInstaller-invPtrLoc / oracle10g/oraInst.loc command can be passed around, oracle will create a new loc file.

After the previous step successfully, followed by reporting the following error:

Exception java.lang.UnsatisfiedLinkError: / tmp/OraInstall2007-08-30_02-16-11PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred ..
java.lang.UnsatisfiedLinkError: / tmp/OraInstall2007-08-30_02-16-11PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory

In RHEL5 before this error is because of lack of XFree86-libs or xorg-x11-deprecated-libs package one of the two (different versions of different packages), and in RHEL5 in front of the package is libXp replaced, so the rpm-ivh libXp -1.0.0-8.i386.rpm after the package marked solve the problem. After all the best.

Case 2:

Reference http://moto.debian.org.tw/viewtopic.php?t=8055&sid=eb2524337903c5af7ce1e839e0a35b68
Preparation for the installation of pre-installed at the beginning of the following errors:

For error while loading shared libraries: libstdc + +-libc6.1-1.so.2
My solution is to
ln-s libstdc + +-libc6.2-2.so.3 libstdc + +-libc6.1-1.so.2
For
Exception: java.lang.UnsatisfiedLinkError: / usr/java/j2sdk1.4.2_06/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
Solution is
apt-get install libXp.so.6
apt-get install libXt.so.6
apt-get install libxtst6

Case 3:

In RH Linux7.3 JasperReport as the reporting engine to use when encountered the same problem:
Exception: java.lang.UnsatisfiedLinkError: / usr/java/j2sdk1.4.2_06/jre/lib/i386/libawt.so: libXt.so.6: cannot open shared object file: No such file or directory

In reply to the prompt you before, after one morning google, finally able to solve this problem because: a lack of support for printing graphics dynamic link library libXp.so.6 (perhaps related to other libraries)
Solution: Download and install the XFree86-libs-4.2.0-8.i386.rpm, / usr/X11R6/lib need libXp.so.6.2 will appear under the

Attached to XFree86-libs-4.2.0-8.i386.rpm's a download address:
ftp://ftp.nluug.nl/vol/1/schoollan/os/linux/RPMS/XFree86-libs-4.2.0-8.i386.rpm

alter system set events related knowledge 2009-04-17 17:31:20
With ASP to achieve operation of the ORACLE database 2009-04-13 16:52:55
Oracle 11g 2009-04-10 05:16:41
The third part (20) Advanced Configuration of the single-source multi-directional replication environment (1) 2009-04-09 16:38:20
ORACLE10G full version centos5 installed (the installation has passed) 2009-03-31 09:49:10

Problem Summary: Linux installation error under the common conclusion oracle

kods.net — Tue, 15 Jun 2010 09:57:27+0000

Error 1:

/ Tmp/OraInstall2007-12-30_02-16-11PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred ..

The reasons are: lack of support printed graphics dynamic link library libXp.so.6

This error is due to the lack of system installation package, the previous version in RHEL5, you can install the xorg-x11-deprecated-libs package can be, this installation package can be the third CD in the system tray to find (for redhat as4.2 ago, redhat as4. 4 is the fourth CD-ROM)

IXDBA.NET technology community

I download the following documents:

xorg-x11-deprecated-libs-6.8.2-31.i386.rpm

Error 2:

Exception: java.lang.UnsatisfiedLinkError: / usr/java/j2sdk1.4.2_06/jre/lib/i386/libawt.so: libXt.so.6: cannot open shared object file: No such file or directory
This error is also due to the lack of the system caused by the installation package, just install the XFree86-libs package can be, this installation package can be found on the system CD.

If the above two errors in the redhat as5 version, resolved as follows:

In RHEL5 the above package is libXp replaced, so the rpm-ivh libXp-1.0.0-8.i386.rpm after the package marked with the problem can be solved.

Error 3:

error while loading shared libraries: libstdc + +-libc6.1-1.so.2

Only do the following ln-s libstdc + +-libc6.2-2.so.3 libstdc + +-libc6.1-1.so.2

Reference Case

Case 1:

Tested in the RHEL5 install oracle10g, that before the turn of the 11g, this would be more successful, the result is still two problems.

First of all, in the implementation of the runInstaller, the system error:

You do not have sufficient permissions to access the inventory '/ oracle11g/oraInventory'. Installation cannot continue. Make sure that you have read / write permissions to the inventory directory and restart the installer.: Permission denied

Is used here to create a new way for users 10g 10g, 11g coexist, in fact, when you start the installer, oracle will look for / etc / oraInst.loc and oratab these two files (hp is / var / opt / oracle )

Which is defined in oraInst.loc inventory_loc location and inst_group, as had before the installation of a 11g, which is the definition of user settings for 11g, so the only error. Solution is the implementation of runInstaller-invPtrLoc / oracle10g/oraInst.loc command can be passed around, oracle will create a new loc file.

After the previous step successfully, following reports the following fault:

Exception java.lang.UnsatisfiedLinkError: / tmp/OraInstall2007-08-30_02-16-11PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred ..
java.lang.UnsatisfiedLinkError: / tmp/OraInstall2007-08-30_02-16-11PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory

In RHEL5 before this error is because of lack of XFree86-libs or xorg-x11-deprecated-libs one of the two packages (in different versions of different packages), and in front of the package in RHEL5 is libXp replaced, so the rpm-ivh libXp -1.0.0-8.i386.rpm after the package marked solve the problem. After all the best.

Case 2:

Reference http://moto.debian.org.tw/viewtopic.php?t=8055&sid=eb2524337903c5af7ce1e839e0a35b68
For pre-installation ready to begin the installation when the following error:

For error while loading shared libraries: libstdc + +-libc6.1-1.so.2
My solution is to
ln-s libstdc + +-libc6.2-2.so.3 libstdc + +-libc6.1-1.so.2
For
Exception: java.lang.UnsatisfiedLinkError: / usr/java/j2sdk1.4.2_06/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
Solution is
apt-get install libXp.so.6
apt-get install libXt.so.6
apt-get install libxtst6

Case 3:

In RH Linux7.3 JasperReport as the reporting engine to use when encountered the same problem:
Exception: java.lang.UnsatisfiedLinkError: / usr/java/j2sdk1.4.2_06/jre/lib/i386/libawt.so: libXt.so.6: cannot open shared object file: No such file or directory

In reply to the prompt you before, after one morning google, finally able to solve this problem because: a lack of support for printing graphics dynamic link library libXp.so.6 (perhaps related to other libraries)
Solution: Download and install the XFree86-libs-4.2.0-8.i386.rpm, / usr/X11R6/lib need libXp.so.6.2 will appear under the

Attached XFree86-libs-4.2.0-8.i386.rpm's a download address:
ftp://ftp.nluug.nl/vol/1/schoollan/os/linux/RPMS/XFree86-libs-4.2.0-8.i386.rpm

Redhat as4 under the startup script since oracle10g 2009-06-18 04:02:17
apex3.2 steps to install oracle10 2009-04-19 10:33:11
Oracle installation difficulties 2009-04-19 04:08:56
alter system set events related knowledge 2009-04-17 17:31:20
Oracle 11g 2009-04-10 05:16:41

Rman problem novice small note 3: Create auxiliary instance encountered ORA-01031

kods.net — Sat, 17 Apr 2010 09:11:35+0000

Reference [think twice Notes] step by step and learn to do dg DataGuard document the beginning of the preparatory phase, the library copy of the database call the shots, make a copy of the first phase of the database, create a secondary instance, the basic process is:

1, create a password file

2, Create initialization parameter file

3, connection and start the auxiliary instance

4, using rman parameters to connect to auxiliary instance of the main library and auxiliary

My system environment: redhat-as4.7 + oracle10.2.0.4,

The main database address: 192.168.1.220 sid: lizidb dbname: lizidb

Secondary database Address: 192.168.1.221 sid: standbydb dbname: sbydb

Client database connection string: Main: @ lizidb_192.168.1.220

Fu: @ standby_192.168.1.221

The first step to create the password file, refer to reconsider the document, create the password file to the database data file directory below and to PWDsid.ora name, login using rman auxiliary instance, error:

[Oracle @ db-standby standbydb] $ orapwd file = / u00/oracle/standbydb/pwdstandby.ora password = aaa entries = 30

[Oracle @ db-standby pfile] $ rman target sys / aaa @ standby_192.168.1.221

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Apr 16 16:11:13 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN-00571: ============================================== =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ============================================== =============
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

google search solution ora-01031 wrong way, to check all sorts of places, such as sqlnet.ora, listener.ora, various documents authority, an instance of memory for so much trouble is also not effective, several times thinking, feeling, or orientation in the password file above. Because the error literally means to have no permission to visit the auxiliary instance, why not power? Nothing more than users of other users do not have operating authority, but now that the supporting examples for creating a sys's password file, but I still reported this error, it shows that did not find the sys user, also is not used in the password file landing Shi Hou by search, found the following related articles:

Point on the learning oracle password file

Command to create the password file

orapwd file = <> password = <> entries = maximum number of

The file naming convention here in unix / linux under orapw , under the windows pwd . Ora

See the following description of specific information (this is a friends pub summary)

1. Unix environment:

Investigation of the Administrator's Reference 10g Release 2 (10.2) for UNIX-Based Operating Systems.

1. Log in as the Oracle software owner.

2. Use the orapwd utility to create the password file as follows: $ $ ORACLE_HOME / bin / orapwd file = filename password = password entries = max_users ... ...

filename The name of the file in which password information is written

The name of the file must be orapwsid, and you must supply the full path name. Its contents are encrypted. Typically, the password file is created in the $ ORACLE_HOME / dbs directory.

Please note that bold, so unix environment, password file must use orapw , no exceptions.

2. Windows environment:

Investigation of the Platform. Guide 10g Release 2 (10.2) for Microsoft Windows (32-Bit) (No check 64-bit)

To create and populate a password file:

(1). Create a password file with the Password Utility:

C:> orapwd FILE = PWDsid.ora PASSWORD = password ENTRIES = max_users

where

| FILE specifies the password filename.

| SID identifies the database instance.

| PASSWORD sets the password for account SYS.

| ENTRIES sets maximum number of entries in password file. This corresponds to maximum number of distinct users allowed to connect to the database simultaneously with either the SYSDBA or the SYSOPER DBA privilege.

(2). Set initialization parameter file parameter REMOTE_LOGIN_PASSWORDFILE to exclusive, shared, or none.

In search of the password file, Oracle Database looks in the registry for the value of parameter

ORA_SID_PWFILE. If no value is specified, then it looks in the registry for the

value of parameter ORA_PWFILE, which points to a file containing usernames,

passwords, and privileges. If that is not set, then it uses the default:

ORACLE_BASEORACLE_HOMEDATABASEPWDsid.ORA.

The default value is shared.

Please note that bold, windows environment, a large part is based on the registry variable ora_sid_pwfile or ora_pwfile settings, the default value, as paulyibinyi brother pointed out, is the pwd . Ora (unix is not it. Ora suffix).

Second, under the windows to connect / as sysdba and other users can login without a password problem

1. This is because oracle uses OS authentication methods, specific content can be viewed as the same sqlnet.ora specific

SQLNET.AUTHENTICATION_SERVICES = (NTS)

To change SQLNET.AUTHENTICATION_SERVICES = (NONE)

This is the way the oracle certification

2. Because authentication with the OS, can the operating system -> Control Panel -> Computer Management -> Users to the current user of the property group ORA_DBA removed, then if no user name and password are not.

As follows:

SQL> connect / as sysdba ERROR: ORA-01031: insufficient privileges

SQL> connect sys / oracle as sysdba

Connected.

Third, using alter user identified by ... ... to modify the password alter user sys identified by abc look, even a database password and the password with the password file into abc a;

Fourth, if the password file is missing how to do?

Using orapwd re-create an on it.
The group posted music from TOKYO Community - http: / / q.yesky.com/group/review-17556888.html

Note that italicized part, the original is in the linux system, when I create a password file path and name are not correct, then rebuild the password file in accordance with their requirements, the successful connection:

[Oracle @ db-standby pfile] $ rman target sys / aaa @ standby_192.168.1.221

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Apr 16 17:02:53 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: standbydb (not mounted)

RMAN> exit

Oracle9i database manually create specific steps 2009-04-02 13:49:25
RMAN created physical standby 2009-03-30 22:49:29
use sqlldr 1 Introduction 2009-03-27 19:39:01
Troubleshooting: the physical set up the backup database 2009-03-13 00:53:17
DATA GURAD use DBMS_FILE_TRANSFER and cloning configuration database 2009-02-23 19:07:40

dbca building a database script analysis

kods.net — Sat, 27 Mar 2010 06:56:47+0000

Platform: Redhat AS4 UPDATE 7, Oracle 10gR2

ORACLE_BASE: / u01/app/oracle, SID: orcl1

dbca script library construction is to use the template to create the database, the advantage of using a template to create the database will usually speed quickly, reason is that the data file to restore the database from the seeds out without the need to create documents and information such as a dictionary object.

First, create the directory:

mkdir-p / u01/app/oracle/admin/orcl1/adump

mkdir-p / u01/app/oracle/admin/orcl1/bdump

mkdir-p / u01/app/oracle/admin/orcl1/cdump

mkdir-p / u01/app/oracle/admin/orcl1/dpdump

mkdir-p / u01/app/oracle/admin/orcl1/pfile

mkdir-p / u01/app/oracle/admin/orcl1/udump

mkdir-p / u01/app/oracle/flash_recovery_area

mkdir-p / u01/app/oracle/oradata/orcl1

mkdir-p / u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/orcl1

mkdir-p / u01/app/oracle/product/10.2.0/db_1/dbs

Second, set the environment variable

ORACLE_SID = orcl1; export ORACLE_SID

Third, in the / etc / oratab instance start adding items

orcl1: / u01/app/oracle/product/10.2.0/db_1: Y

Fourth, create a password file (password file):

Log in nolog, the Executive

host / u01/app/oracle/product/10.2.0/db_1/bin/orapwd file = / u01/app/oracle/product/10.2.0/db_1/dbs/orapworcl1 password = & sysPassword force = y

Password

5, CloneRmanRestore.sql (using the specified parameter file to open the database nomount, call rmanRestoreDatafiles.sql)

connect sys / orcl as SYSDBA

set echo on

spool / u01/app/oracle/admin/orcl1/scripts/CloneRmanRestore.log

startup nomount pfile = "/ u01/app/oracle/admin/orcl1/scripts/init.ora"; / / open the database using the specified parameters

@ / U01/app/oracle/admin/orcl1/scripts / rmanRestoreDatafiles. Sql;

6, rmanRestoreDatafiles.sql (removed from the seed file, data file)

set echo off;

set serveroutput on;

select TO_CHAR (systimestamp, 'YYYYMMDD HH: MI: SS') from dual; / / script starts running time

variable devicename varchar2 (255);

declare

omfname varchar2 (512): = NULL;

done boolean;

begin

dbms_output.put_line ('');

dbms_output.put_line ('Allocating device ....');

dbms_output.put_line ('Specifying datafiles ...');

: Devicename: = dbms_backup_restore.deviceAllocate;

dbms_output.put_line ('Specifing datafiles ...');

dbms_backup_restore.restoreSetDataFile;

dbms_backup_restore.restoreDataFileTo (1, '/ u01/app/oracle/oradata/orcl1/system01.dbf', 0, 'SYSTEM');

dbms_backup_restore.restoreDataFileTo (2, '/ u01/app/oracle/oradata/orcl1/undotbs01.dbf', 0, 'UNDOTBS1');

dbms_backup_restore.restoreDataFileTo (3, '/ u01/app/oracle/oradata/orcl1/sysaux01.dbf', 0, 'SYSAUX');

dbms_backup_restore.restoreDataFileTo (4, '/ u01/app/oracle/oradata/orcl1/users01.dbf', 0, 'USERS');

dbms_output.put_line ('Restoring ...');

dbms_backup_restore.restoreBackupPiece ('/ u01/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/Seed_Database.dfb', done); / / seed file

if done then

dbms_output.put_line ('Restore done.');

else

dbms_output.put_line ('ORA-XXXX: Restore failed');

end if;

dbms_backup_restore.deviceDeallocate;

end;

/

select TO_CHAR (systimestamp, 'YYYYMMDD HH: MI: SS') from dual; / / end script run time

/ / Dbms_backup_restore pack some background knowledge:

When the database backup through RMAN, RMAN will write multiple data files into one or more of the backup file (called backup set), RMAN backup related information or stored in the control file, or stored in the RMAN's private directory database (Catalog), if RMAN backup information is lost, it is usually concentrated in the file backup is no way to read out, and other tools can not identify RMAN backup set files; and dbms_backup_restore is to provide a response to this solution, dbms_backup_restore nomount state in the database call to read data directly from the backup set files very powerful.

DBMS_BACKUP_RESTORE package by the dbmsbkrs.sql and prvtbkrs.plb created two scripts to create database script executed catproc.sql call these two scripts to create the package, the script file can be $ ORACLE_HOME / rdbms / admin directory to find, script file to the package contents in detail.

7, cloneDBCreation.sql (rebuild control file and modify the relevant parameters)

connect sys / orcl as SYSDBA

set echo on

spool cloneDBCreation.log

Create controlfile reuse set database "orcl1"

MAXINSTANCES 8

MAXLOGHISTORY 1

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

Datafile / / specify the data file

'/ U01/app/oracle/oradata/orcl1/system01.dbf',

'/ U01/app/oracle/oradata/orcl1/undotbs01.dbf',

'/ U01/app/oracle/oradata/orcl1/sysaux01.dbf',

'/ U01/app/oracle/oradata/orcl1/users01.dbf'

/ / Specify the log file group

LOGFILE GROUP 1 ('/ u01/app/oracle/oradata/orcl1/redo01.log') SIZE 51200K,

GROUP 2 ('/ u01/app/oracle/oradata/orcl1/redo02.log') SIZE 51200K,

GROUP 3 ('/ u01/app/oracle/oradata/orcl1/redo03.log') SIZE 51200K RESETLOGS;

exec dbms_backup_restore.zerodbid (0);

/ * ZeroDbid is a process package for the empty part of the data file header information, the new dbid in the control file created after could be calculated, for database cloning, it is necessary.

zeroDbid an input parameter, that is, file number:

PROCEDURE zeroDbid (fno IN binary_integer);

If fno == 0, the control file header contains all the data will be cleared, zeroDbid clear the data file header is mainly used for the 3 categories of information: Database id information, Checksum Checksum sign bit of information and information. * /

shutdown immediate;

startup nomount pfile = "/ u01/app/oracle/admin/orcl1/scripts/initorcl1Temp.ora";

Create controlfile reuse set database "orcl1"

MAXINSTANCES 8

MAXLOGHISTORY 1

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

Datafile

'/ U01/app/oracle/oradata/orcl1/system01.dbf',

'/ U01/app/oracle/oradata/orcl1/undotbs01.dbf',

'/ U01/app/oracle/oradata/orcl1/sysaux01.dbf',

'/ U01/app/oracle/oradata/orcl1/users01.dbf'

LOGFILE GROUP 1 ('/ u01/app/oracle/oradata/orcl1/redo01.log') SIZE 51200K,

GROUP 2 ('/ u01/app/oracle/oradata/orcl1/redo02.log') SIZE 51200K,

GROUP 3 ('/ u01/app/oracle/oradata/orcl1/redo03.log') SIZE 51200K RESETLOGS;

alter system enable restricted session;

alter database "orcl1" open resetlogs;

alter database rename global_name to "orcl1";

/ / Add a temporary table space

ALTER TABLESPACE TEMP ADD TEMPFILE '/ u01/app/oracle/oradata/orcl1/temp01.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;

select tablespace_name from dba_tablespaces where tablespace_name = 'USERS';

select sid, program, serial #, username from v $ session;

/ / Modify the character set

alter database character set INTERNAL_CONVERT WE8ISO8859P1;

alter database national character set INTERNAL_CONVERT AL16UTF16;

/ / Modify the sys / system password

alter user sys identified by "& & sysPassword";

alter user system identified by "& & systemPassword";

alter system disable restricted session;

initorcl1Temp.ora

################################################## ############################

# Copyright (c) 1991, 2001, 2002 by Oracle Corporation

################################################## ############################

###########################################

# Archive

###########################################

log_archive_dest_1 = ""

... ... ... ... ...

_no_recovery_through_resetlogs = true

/ * _no_recovery_through_resetlogs FALSE no recovery through this resetlogs operation

This parameter can be used to limit recovery across resetlogs, the recovery of the database is, resetlogs usually means not fully recovered from the database resetlogs open, the control file in a lot of information to be rewritten before the Oracle 10g, if the database is open resetlogs , then it will no longer be able to document the current control point again before resetlogs recovery, and Oracle 10g changed the history.

In Oracle 10g, even by way of open resetlogs database, Oracle continues to support again from resetlogs time to recover before; in Clone database, Oracle sets this parameter to True, means that do not allow time again across resetlogs recovery. * /

8, postScripts.sql (after the construction script)

connect sys / orcl as SYSDBA

set echo on

spool / u01/app/oracle/admin/orcl1/scripts/postScripts.log

@ / U01/app/oracle/product/10.2.0/db_1/rdbms/admin/dbmssml.sql;

# CREATE OR REPLACE LIBRARY dbms_sumadv_lib AS '/ u01/app/oracle/product/10.2.0/db_1/lib/libqsmashr.so';

Create or replace dbms_sumadv_lib library, the specific role to be studied (strings, objdump)

execute dbms_datapump_utl.replace_default_dir;

commit;

connect sys / orcl as SYSDBA

alter session set current_schema = ORDSYS; / / ORDSYS for the Oracle interMedia administrator account

@ / U01/app/oracle/product/10.2.0/db_1/ord/im/admin/ordlib.sql;

# Create or replace library ORDIMLIBS as '/ u01/app/oracle/product/10.2.0/db_1/lib/libordim10.so';

/

create or replace library ORDIMLIBT trusted as static;

/

Rem ordimasf.jar is only available via download from the

Rem Oracle Technology Network website. Go to the interMedia section of

Rem http://otn.oracle.com.

Rem

Rem Uncomment the following lines after downloading ordimasf.jar.

- BEGIN

- Dbms_java.loadjava ('-synonym-schema ORDSYS-resolve-grant PUBLIC ord / jlib / ordimasf.jar');

- EXCEPTION

- WHEN OTHERS THEN

- NULL;

- END;

- /

/ / Switch to the SYS account

alter session set current_schema = SYS;

connect sys / orcl as SYSDBA

execute ORACLE_OCM.MGMT_CONFIG_UTL.create_replace_dir_obj;

execute dbms_swrf_internal.cleanup_database (cleanup_local => FALSE);

commit;

spool off

9, postDBCreation.sql (create spfile, lift the account lockout, re-compile the invalid objects, reconstruction em database)

connect sys / orcl as SYSDBA

set echo on

spool / u01/app/oracle/admin/orcl1/scripts/postDBCreation.log

connect sys / orcl as SYSDBA

set echo on

# Create the spfile

create spfile = '/ u01/app/oracle/product/10.2.0/db_1/dbs/spfileorcl1.ora' FROM pfile = '/ u01/app/oracle/admin/orcl1/scripts/init.ora';

# Restart instance to start the database using the spfile

shutdown immediate;

connect sys / orcl as SYSDBA

startup;

# Lifted SYSMAN / DBSNMP account locked

alter user SYSMAN identified by "& & sysmanPassword" account unlock;

alter user DBSNMP identified by "& & dbsnmpPassword" account unlock;

select 'utl_recomp_begin:' | | to_char (sysdate, 'HH: MI: SS') from dual;

execute utl_recomp.recomp_serial ();

# UTL_RECOMP.RECOMP_SERIAL (

schema IN VARCHAR2 DEFAULT NULL,

flags IN PLS_INTEGER DEFAULT 0);

Recompile a schema (user) is invalid under the object, if it is NULL then compile the entire database. flags used for internal testing.

select 'utl_recomp_end:' | | to_char (sysdate, 'HH: MI: SS') from dual;

# Configuration emca database, reference via

host / u01/app/oracle/product/10.2.0/db_1/bin/emca-config dbcontrol db-silent-DB_UNIQUE_NAME orcl1-PORT 1521-EM_HOME / u01/app/oracle/product/10.2.0/db_1-LISTENER LISTENER -SERVICE_NAME orcl1-SYS_PWD & & sysPassword-SID orcl1-ORACLE_HOME / u01/app/oracle/product/10.2.0/db_1-DBSNMP_PWD & & dbsnmpPassword-HOST localhost.localdomain-LISTENER_OH / u01/app/oracle/product/10.2.0/db_1 - LOG_FILE / u01/app/oracle/admin/orcl1/scripts/emConfig.log-SYSMAN_PWD & & sysmanPassword;

spool / u01/app/oracle/admin/orcl1/scripts/postDBCreation.log

Reference:

Official documents:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm # i1008760

Step by step Oracle:

http://book.csdn.net/bookfiles/453/10045316016.shtml

Oracle XE comes with a database how to create:

http://www.dbanotes.net/database/oracle_xe_hwo_to_create_a_database.html

-EOF-

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

yangtingkun personal BLOG Article Index ---- RAC aspects of

kods.net — Fri, 15 Jan 2010 19:56:30+0000

RAC areas:
Redhat AS4 for x86_64 install Oracle 9204 RAC Overview (1): systems and raw device preparations.
Redhat AS4 for x86_64 install Oracle 9204 RAC Overview (2): installation and construction of library work.
Oracle 10gr2 Bug 4437727: Installation of the RAC when 10GR2 encountered bug.
Solaris8 installed RAC10202 Environment (1): This paper describes the operating system preparations.
Solaris8 installed RAC10202 Environment (2): ORACLE's CLUSTERWARE installation.
Solaris8 installed RAC10202 Environment (3): ORACLE software installation.
Solaris8 installed RAC10202 Environment (4): ORACLE database building process.
Solaris8 installed RAC10202 Environment (5): ORACLE database RAC environment, patch installation.
Solaris8 installed RAC10202 Environment (6): Oracle RAC environment applications 5117016 patch set and the application of this patch set after the bug.
Solaris8 installed RAC10202 Environment (7): the RAC installation process encountered problems and how resolved.
RAC connectivity problem ORA-12545: RAC connectivity problem ORA-12545.
RAC connectivity problem ORA-12545 (2): This issue another solution.
RAC User Equivalence Check Failed: configure RAC using the SSH user equivalence failed the examination questions.
ORA-17447 error: JDBC driver connectivity problems caused by weblogic.
Oracle srvctl a small bug: srvctl to record only their own state, without checking the actual operating conditions.
An ASM environment for troubleshooting: ASM problems caused by lack of space.
Solaris10 installed Oracle10203RAC Environment (1): RAC installation preparations.
Solaris10 installed Oracle10203RAC Environment (2): Oracle Clusterware installation process.
Solaris10 installed Oracle10203RAC Environment (3): Oracle Database installation process.
Solaris10 installed Oracle10203RAC Environment (4): 10203 patch installation process.
Solaris10 installed Oracle10203RAC Environment (5): RAC environment, problems encountered during the installation process.
RAC load balancing a simple test (a): load balancing a simple test.
RAC load balancing a simple test (2): continue to discuss the load balancing features.
RAC load balancing a simple test (3): discussion of load balancing and busy instance whether they are related.
RAC load balancing a simple test (4): continue to discuss the load balancing and busy instance whether they are related.
Connected after ASM instance ORA-1012 error: is the problems caused by ASM space is full.
Connected after ASM instance ORA-1012 error (2): The second emergence of this problem and leads to new clues.
Connected after ASM instance ORA-1012 error (3): description of the problem arising from the real reason.
RAC Environment Network Fault Testing: To describe the network when the problem occurs on the RAC environment.
RAC's TAF simple test (1): TAF function simple test.
RAC simple test of the TAF (II): FAILOVER the SESSION and SELECT options.
RAC's TAF simple test (3): TAF on the transaction effects.
RAC's TAF simple test (4): TAF of the BASIC mode and PRECONNECT way.
RAC's TAF simple test (5): TAF server-side PRECONNECT settings.
RMAN backup and recovery - RAC environment, the database backup (1): RAC environment, backup, recovery and general database backup, restore the difference.
RMAN backup and recovery - RAC environment, the database backup (2): Based on raw device backup of RAC environment.
RMAN backup and recovery - RAC environment, the database backup (3): Based on the bare device RAC environment recovery.
RMAN backup and recovery - RAC environment, the database backup (4): RAC environment, backing up to tape libraries as well as the recovery from the tape library.
RMAN backup and recovery - RAC environment, the database backup (5): RAC local disk backup sets to backup to tape.
RMAN backup and recovery - RAC environment, the database backup (6): RAC local disk backup set backup to tape after the recovery.
RMAN backup and recovery - RAC environment, the database backup (7): RAC local disk backup set an example through the recovery process.
RMAN backup and recovery - RAC environment, the database backup (8): RAC raw device backup ASM solution.
RMAN backup and recovery - RAC environment, the database backup (9): RAC raw device backup NFS MOUNT solution.
RMAN backup and recovery - RAC environment, the database backup (10): RAC raw device backup through remote archiving STANDBY mechanisms to address the problem.
RMAN backup and recovery - RAC environment, the database backup (11): Based on the raw device backup RAC load-balancing solution.
RMAN backup and recovery - backup to tape library performance: rac environment, through RMAN backup to tape library performance.
RMAN backup and recovery - backup to a tape library performance (2): by setting NETBACKUP parameters to solve the problems in the previous article.
To modify the system time, to restart an instance of a RAC environment: to modify the system time, to restart an instance of a RAC environment.
Rman backup via NFS Baocuo ORA-27054: RMAN through the NFS backup, recovery time, there will be ORA-27054 error.
The name of archived log is empty: the name of archived log is empty issue.
RAC environment TNSNAMES file: RAC environment TNSNAMES file.
RAC environment, the password file: RAC environment, the password file.
RAC environment initialization file: RAC environment initialization file.
RAC environment, a snapshot control file: RAC environment, a snapshot control file
A tape library backup Exception: Test RAC backup when a node backup to tape libraries abnormal.
RAC environment, recovery strategies: a backup strategy for backup and recovery.
RAC environment, modify the system time may cause SRVCTL command failed: RAC environment, modify the system time, to a SRVCTL command failed.
RAC environment, an instance of delete by another instance of the deleted table Baocuo: RAC environment, if an instance of deleted table, the table As for the Recycle Bin, in another instance of trying to delete the same name as the table will complain.
srvctl add database information Baocuo: srvctl add database information Bao Cuo.
ORACLE RAC environment, the use of TAR to restore the software directory: Using tar to restore ORACLE RAC environment, the process of the software directory.
ORA-600 (kolaslGetLength-1) Error: Access GV $ SQL view, a result of bug.
10GRAC the database using RMAN to establish DATA GUARD: RMAN build 10G of the RAC environment, DATA GUARD.
RAC environment, the establishment of DATA GUARD emerged after the 1677 error: RAC environment, the establishment of a DATA GUARD after, RAC environment, an instance of the closure can not start, error from the: ORA-1677.
SWITCHOVER RAC database for the ORA-1093: Oracle10g RAC environment in the implementation of SWITCHOVER operation ORA-1093 error occurs.
SWITCHOVER RAC database for the ORA-600 (kcctrdf_2) Error: SWITCHOVER RAC database for the ORA-600 (kcctrdf_2) error.
RAC environment, the SWITCHOVER physical STANDBY switch: RAC environment database SWITCHOVER to switch to a single-instance database.
RAC installation appears ORA-341 and ORA-312 error: RAC Database Baocuo during the diagnostic process.
RAC environment, STANDBY database backup Baocuo: Rac environment, execute commands Baocuo STANDBY database error number is: RMAN-04022.
RAC environment, not other instances of queries executed SQL: an instance to another instance may be unable to check on the implementation of SQL.
RAC environment, space is filled after the ASM archive issues: RAC environment, space is filled after the ASM archive problem.
RAC environment, the definition of operation using online re-emergence bug: RAC environment, the definition of operation using online re-emergence bug.
RAC environment, an example of another instance when it will archive the log: to explain why sometimes found in an instance where the server contains the archive logs to another server.
ORA-7445 (kkttrex) Error: RAC environment, SHUTDOWN triggers caused by bug.
Specify the different RAC instances for a different SPFILE: RAC were multiple instances can be started with a different SPFILE.
Solaris10 installed Oracle1106RAC Environment (1): First set up the operating environment information.
Solaris10 installed Oracle1106RAC Environment (2): This description of Oracle Clusterware installation.
Solaris10 installed Oracle1106RAC Environment (3): This describes the installation of Oracle Database.
Solaris10 installed Oracle1106RAC Environment (4): This describes the process of Oracle's Database.
Solaris10 installed Oracle1106RAC Environment (5): Record what this RAC installation process encountered errors.
RAC environment for parallel query support: RAC environment, a parallel implementation may be distributed to the multiple instances to run.
ASM Tools asmcmd: Oracle does offer a number of tools to access the ASM disk group, asmcdm is one of the tools.
asmcmd the cp command a small bug: asmcmd added new cp command allows users to copy files between ASM and the operating system.
ASMCMD command copies document errors ORA-15046: copy data files using ASMCMD when this error.
ASM disk group to visit via FTP: The FTP-access to ASM disk group files.
Connect to the database when Baocuo ORA-12520 and ORA-12516 error: In the local recovery of a RAC database, connect to the database by setting Baocuo ORA-12520.
Try to start the database without parameters Baocuo ORA-304 error: a has been configured RAC + ASM environment, database, try to use RMAN without arguments to start, there has been an error ORA-304.
Restoration of the RAC database, RESTORE: Analog RAC environment, the collapse of the new server RESTORE process.
Restoration of the RAC database RECOVER: Analog RAC environment, the collapse of the new server RECOVER process.
Resulted in the recovery process exception ORA-600 and ORA-7445 error: Due to an error recovery operations has led to open a database Baocuo.
Once the command line to add DISK experience: try to use the command line to add in the ASM disks.
Can the same server, the deployment of two RAC environment: to explore whether the same server, the deployment of multiple sets of RAC environment.
ORA-600 (2037) Error: for 11g's RAC recovery process, in the background ALERT file to see the error.
WEBLOGIC connect Oracle RAC load balancing test: Test single-instance and RAC environment, each node of the load.
Restoration of the RAC database DUPLICATE (1): This describes the preparation of DUPLICATE command.
Restoration of the RAC database DUPLICATE (2): This describes the implementation of DUPLICATE command.
Restoration of the RAC database DUPLICATE (3): This describes DUPLICATE command after the execution of the finishing operation.
RMAN implementation of the RAC database DUPLICATE operation Baocuo ORA-12720: try to RAC environment, implementation of the DUPLICATE operation Baocuo.
RAC environment, the physical STANDBY switch to switch the FAILOVER: Shu-RAC environment database FAILOVER to switch to a single-instance database.
Silent Mode Uninstall 11G RAC database: description of 11G RAC database SILENT unloading method.
Silent Mode Uninstall 11G RAC database software: Description 11G RAC database software, uninstall SILENT mode.
Solaris10 Silent Mode Uninstall 11G RAC CLUSTER Environment: 11G RAC described in the CLUSTER environment SILENT unloading method.
Use SRVCTL to add database information: Use SRVCTL manually add the database information.
11G RAC environment, the STANDBY some minor problems: 11g a STANDBY database can be open simultaneously in the application log of the database, but for the RAC environment, there are some minor problems.
A Windows environment, memory size beyond the scope of problem-solving: Since the creation of SGA too large, more than 32 Windows environment, the maximum allowed memory, causing Windows environment can not start normally.
RAC Start Baocuo can not access the OCR device: As issue of Veritas of the CFS led to a short time can not access the shared OCR device RAC.
11gRAC can kill other instances on the session: RAC environment, Oracle11g has added a new statement, made in the current instance DBA can kill other instances on the RAC session.
Silent Mode Installation Oracle1106RAC under Solaris10 Environment (1): Set the operating system of environmental information.
Silent Mode Installation Oracle1106RAC under Solaris10 Environment (2): describe the installation of the software CLUSTER preparations.
Silent Mode Installation Oracle1106RAC under Solaris10 Environment (3): Description SILENT mode CLUSTER software installation.
Silent Mode Installation Oracle1106RAC under Solaris10 Environment (4): description of SILENT mode, the database software installation preparations.
Silent Mode Installation Oracle1106RAC under Solaris10 Environment (5): Description SILENT mode, database software installation process.
Silent Mode Installation Oracle1106RAC under Solaris10 Environment (6): description of SILENT mode, ASM instance creation.
Silent Mode Installation Oracle1106RAC under Solaris10 Environment (7): description of SILENT mode, the database instance creation.
Silent Mode Installation Oracle1106RAC under Solaris10 Environment (8): describe the problems encountered during the installation process.
RAC environment in the ASM to create the table space error ORA-569: Description ASM to create the table space is the error as well as the settlement process.
ORA-16146 error: RAC environment, two instances of the same time archive to a remote node issues arising.
RAC environment, ROLLING UPGRADE apply the PATCH: RAC environment to support ROLLING UPGRADE install PATCH.
Flexibility to achieve the three-node RAC load balancing and TAF configuration (1): This paper gives the realization of issues and problems.
Flexibility to achieve the three-node RAC load balancing and TAF configuration (II): testing whether the implementation is given to meet demand.
Flexibility to achieve the three-node RAC load balancing and TAF configuration (3): The settlement of a node does not start to bring the connection failures.
Flexibility to achieve the three-node RAC load balancing and TAF configuration (4): solve the examples 1 and examples of two consecutive failures caused by ORA-3113 error.
CLUSTER_DATABASE_INSTANCES parameter: This parameter is not a set number of database instances.
RAC parameters may lead to changes in the parameters of the problem of inconsistent: some of the parameters required for each RAC node, set the same.
Add a new instance using the DBCA when CRS-215 error: When you add a new instance of the CRS-215 encountered an error.
Single-instance database by hand into multi-instance database: How to a RAC environment, the single-instance database into a multi-instance database.
Single-instance database tools into multi-instance database: the use of Oracle tool for transformation.
Multi-instance database to delete an instance: In the database layer how to delete an instance.
Oracle11g RAC instance shut down automatically at startup instance archiving: 11g's RAC environment, archive mode, when a node goes down, another node automatically switch off the node logs, and archived to the local node.
RAC database creation STANDBY (1): Introduction STANDBY database preparation and creation process.
RAC database creation STANDBY (2): Introduction STANDBY database to create a follow-up operation, and check the STANDBY operation mechanism.
RAC database creation STANDBY (3): Record what STANDBY database creation process encountered problems.
RAC database creation STANDBY (4): continue to record STANDBY database creation process encountered problems.
RAC database creation STANDBY (5): Create a STANDBY database, the third part of the problem summary.
RAC database creation STANDBY (6): Creating a STANDBY database summarizes the fourth part of the problem.
Query initialization parameters of the method (3): V $ SPPARAMETER view GV $ PARAMETER view on the difference.
Query initialization parameters of the method (4): GV $ SPPARAMETER parameters describing the need.
ASM instance using the CREATE PFILE FROM MEMORY the bug: This command for the ASM instance is concerned, there is bug.
RAC one node to another node to restore the backup tape library: How one node to another node to restore the backup tape library.

RAC environment, STANDBY the FAILOVER switch: RAC environment STANDBY database FAILOVER switch.
RAC environment has ORA-439 Error: upgrade a production environment encountered ORA-439 errors.
RAC environments encountered ORA-4063 error: RAC environment, the query a view emerged ORA-4063 error.
ftp to the ASM disk group path error of the problem: the way through FTP, using the data files copied to the ASM disk group, the results are not careful can lead to data files copied to the wrong directory.
Install CLUSTER encounter Assertion failed offset fFileSize Error: Installation CLUSTER encountered problems.
RAC environment, the creation of logical STANDBY: This paper describes the RAC database to create logical STANDBY.
RMAN to delete archived log directory when the ASM over the deletion of: RMAN command to delete archived logs are stored on ASM, if the archive directory is empty, then the ASM over the directory is also delete.
ORA-600 (kjbrchkpkeywait: timeout) and the ORA-600 (kclcls_8) Error: the implementation of the table space after the migration operation, RAC database, the above error occurred.
ORA-600 (kmgs_parameter_update_timeout_1) Error: background MMON a long process leading to the error SPFILE can not be updated.
ORA-600 (ktte_append_file_info-1) Error: startup process MMON process leading to errors.
RAC environment, LOGICAL STANDBY switch to SWITCHOVER: tell us about the RAC environment LOGICAL STANDBY database SWITCHOVER switch.
RAC environment, LOGICAL STANDBY switch the FAILOVER: tell us about the RAC environment, LOGICAL STANDBY database FAILOVER switch.
RAC environment, adjust the system time: RAC environment, how to adjust the system time in order to avoid the node to restart.
Memories of the 10K space: 10K of space left by the description of a lesson.
ORA-600 (KCLEXPAND_5) Error: a more serious bug, has led to instances of a RAC environment to restart.
The establishment of ASM disk group Baocuo ORA-15063: for the RAC environment, to create the disk group, ran into this error.
An RMAN backup Baocuo diagnostic procedure (1): describe the problem situation.
An RMAN backup Baocuo diagnostic process (2): tracking error message, search for positioning direction.
An RMAN backup Baocuo diagnostic procedure (3): JOB long time to resolve outstanding issues.
An RMAN backup Baocuo diagnostic procedure (4): Continue to clear the dead in the database session.
An RMAN backup Baocuo diagnostic procedure (5): racgimon and racgmain check by removing the process to try to resolve the issue.
An RMAN backup Baocuo diagnostic procedure (6): solve the cluster can not start problems.
RAC environment has Waiting for instances to leave information (1): description of the problem of the discovery process.
RAC environment has Waiting for instances to leave information (2): describe the problem solving process.
Add a new node Oracle10203RAC environment (1): This paper describes the process of preparing.
Add a new node Oracle10203RAC environment (2): describe the CLUSTER software was established.
Add a new node Oracle10203RAC environment (3): describe the establishment of database software and create ASM instance.
Add a new node Oracle10203RAC environment (4): add a new database instance on the node.
Add a new node Oracle10203RAC environment (5): describes the software installation process to add node problems they encountered.
Add a new node Oracle10203RAC Environment (6): description of the database to add the node to add instances of problems they encountered in the process.
CLUSTER start Baocuo can not access the physical device: a test environment a node in the RAC database crash after the accident found that CLUSTER can not start.
RAC raw device for OCR device to establish inconsistency problem: each node of the OCR setting corresponds to the physical device names may be inconsistent.
STANDBY single instance of the use of database upgrade to RAC environment (1): Introduction STANDBY databases preparations.
STANDBY single instance of the use of database upgrade to RAC environment (2): Introduction STANDBY database was established.
STANDBY single instance of the use of database upgrade to RAC environment (3): describe the single-instance environment and RAC environment SWITCHOVER process.
STANDBY single instance of the use of database upgrade to RAC environment (4): description of the operation encountered an error.
VOTING disk failure resulting in the database server restart: Since the fiber card multi-path errors, leading to RAC instance to restart.
Oracle10203RAC Environmental Remove Node (1): Introduction to delete Oracle database instance.
Oracle10203RAC Environmental remove node (2): Introduction Oracle Clusterware to delete the node.
Oracle10203RAC Environmental remove nodes (3): Introduction Oracle software environment to date.

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
Using SQL TRACE and TKPROF 2009-02-26 21:36:37
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

TNS-12555: TNS: permission denied error solution

kods.net — Sun, 20 Dec 2009 17:57:08+0000

Redhat linux as4, after re-install Oracle 10g to start listening, the newspaper the following error:

TNS-12555: TNS: permission denied
TNS-12560: TNS: protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

The error from with the rights related to some google, resolved as follows:

# Chmod 777 / var / tmp / .oracle

Analysis: Oracle should be uninstalled is not clean, resulting in / var / tmp / .oracle directory permissions insufficient and therefore I Bao Cuo.

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

The use of VMware Server on Linux to install Oracle RAC (1)

kods.net — Mon, 07 Dec 2009 04:36:35+0000

The use of VMware Server on Oracle Enterprise Linux to install Oracle RAC 10 g

Author: Vincent Chan

The use of a virtual machine in Oracle Enterprise Linux on a free trial of Oracle Real Application Clusters 10 g Release 2

Published in January 2007

Modified Wilson Note: In order to facilitate the completion of this experiment better for beginners, Wilson carried out a number of comments on this article

This need VMware server 1.0.3 License is:

License 1: 98XY4-54VA4-4216V-4PDZ6

License 2: WH0M5-XW50J-WA4FU-4MTZ3

In addition, students should also download an FTP client tool used to host a variety of software from Windows to Linux virtual machine to send them. The best The tool supports ssh2 over ftp protocol is recommended to use FileZilla: http://filezilla.sourceforge.net/

Any questions on this article, please send to wilsonwang66@yahoo.com

Oracle OpenWorld 2006 in October on the referral of the Oracle Unbreakable Linux to Red Hat Linux is designed to provide enterprise-class support services, more quickly fix errors, and significantly lower support prices. In addition, Oracle's own Enterprise Linux (based on inclusion of additional bug fixes for Red Hat Advanced Server Version 4 (Update 4)) available for free download.

Therefore, it can be VMware Server (VMware provides a free virtual environment), free to use on a home computer running on Red Hat Advanced Server on Oracle Real Application Clusters (RAC) 10 g.

Wilson Note: You can choose to Redhat AS4 / CentOS 4.4 / Oracle Unbreakable Linux 4 on this study. For beginners, it is recommended to use Oracle's Linux, so as to avoid the experiment encountered more trouble. Students can go to download www.tuningking.com media related to Linux.

VMware Server allows you to a single physical computer run multiple operating systems. Each virtual machine is an independent operating environment, and with a group of its own virtual components, such as disk, processor and memory. Virtual technology is useful in computing environments, which allows you to the same physical host, independently develop and test software in order to prevent damage to data or software. VMware software is widely used in server consolidation to reduce the total cost of ownership and speed up application development and testing cycles.

In this guide, you will learn how to install and configure the two in the Enterprise Linux and VMware Server running on Oracle RAC 10 g Release 2 node. Note that this guide is only for teaching / evaluation purposes; Oracle and other suppliers will not be based configuration support.

This guide is divided into the following sections:

1. Hardware requirements and an overview of

2. To configure the first virtual machine

3. In the first virtual machine to configure Enterprise Linux

4. To create and configure the second virtual machine

5. Configure Oracle Automatic Storage Management (ASM)

6. Configure Oracle Cluster File System (OCFS2)

7. Install Oracle Clusterware

8. Install Oracle Database 10 g Release 2

9. Explore the RAC Database Environment

10. Test Transparent Application Failover (TAF)

11. Database Backup and Recovery

12. Explore Oracle Enterprise Manager (OEM) Database Console

13. Frequently Asked Questions

1. Hardware requirements and an overview of

In this guide, you will install 32-bit Linux guest operating systems. Only the host running the following 64-bit processors support 64-bit guest operating systems:

AMD Athlon 64 revision D or later AMD Opteron revision E or later AMD Turion 64 revision E or later AMD Sempron 64-bit-capable revision D or later Intel EM64T VT-capable processor

If you decide to install a 64-bit guest operating systems, make sure your processor listed above. You also need to ensure that the BIOS is enabled virtualization technology (VT). Some mainstream manufacturers is disabled by default in the technology. Here provides information on processor compatibility for additional information.
To verify that your processor is supported, please download from the VMware processor compatibility checker.

For each virtual machine, allocate at least 700MB memory; for all the virtual machines set aside at least 30GB of disk space.

The host operating system environment profile:

Hostname

OS

Processor

Memory

Disk

NIC

pacu

Windows XP Professional Service Pack 2 (32 bit)

Intel Pentium 4 550, 3.4MHz, HT

2 GB DDR2 SDRAM, 533 MHz

250 GB, Ultra ATA/133, 7200 RPM

Intel Pro/1000 MT

Client operating system environment profile:

Hostname

OS

Processor

Memory

rac1

Oracle Enterprise Linux 4 (32 bit)

1

700 MB

rac2

Oracle Enterprise Linux 4 (32 bit)

1

700 MB

Virtual disk layout overview:

The virtual disk on the host operating system

Guest operating system on a virtual disk

Virtual device node

Size (MB)

Description

d: \ vm \ rac \ localdisk.vmdk

/ dev/sda1
/ dev/sda2
/ dev/sda3

SCSI 0:0

20

"/" Mount point swap space
Oracle binaries

d: \ vm \ rac \ sharedstorage \ ocfs2disk.vmdk

/ dev / sdb

SCSI 1:0

512

OCFS2 disk

d: \ vm \ rac \ sharedstorage \ asmdisk1.vmdk

/ dev / sdc

SCSI 1:1

3072

ASM Disk Group 1

d: \ vm \ rac \ sharedstorage \ asmdisk2.vmdk

/ dev / sdd

SCSI 1:2

3072

ASM Disk Group 1

d: \ vm \ rac \ sharedstorage \ asmdisk3.vmdk

/ dev / sde

SCSI 1:3

2048

ASM flash recovery area

(To configure shared storage, client OS can not share the same shared storage, a SCSI bus. Specify the client OS to use SCSI0, shared disk usage SCSI1.)

RAC Database Environment Overview:

Hostname

ASM instance name

RAC instance name

Database Name

Database File Storage

OCR and voting disk (Voting Disk)

rac1

+ ASM1

devdb1

devdb

ASM

OCFS2

rac2

+ ASM2

devdb2

devdb

ASM

OCFS2

You will install Oracle on each node for redundancy to use your home directory. Each node on the ASM and Oracle RAC instances to share the same Oracle home directory.

DBA skills needed 2009-06-18 23:59:43
Reprint - RAC database STANDBY 2009-06-18 11:10:25
Redhat as4 under the startup script since oracle10g 2009-06-18 04:02:17
Oracle installation difficulties 2009-04-19 04:08:56
ORACLE 10G RAC error 10.2.0.4 upgrade 2009-04-13 15:00:05

Redhat as4 since the startup script under the oracle10g

kods.net — Fri, 20 Nov 2009 10:00:40+0000

Linux in the Oracle installation is finished, if the re-start Linux, Oracle will not start automatically, you can manually invoke dbstart command to carry out start, but this seems to be cumbersome. We can configure the Oracle automatic startup script, and then Service to start using Linux for Oracle server.

About oracle install the linux system, how to restart the case in the system for service to start automatically up, there are many online tutorials and ready-made script, here is only my personal summary of the work experience. (The following is for reference only, please do not scripted)

In this paper, REDHAT AS4.8 and oracle10G, for example, Oracle installation process can refer to a 64-bit Linux environment, how to install ORACLE10G.

Oracle Database automatically start and stop the Oracle offer dbstart nationality and reach dbshut files. The document also playing to rely on / etc / oratab exists to use. You want to achieve the oracle with the Linux system to automatically start, there are two ways:

1, set to start automatically starts the database (using the root account)

1, change / etc / oratab the last line of
sid: / oracle/product/10.2.0.1: N
= "
sid: / oracle/product/10.2.0.1: Y (where sid you want to start the database)

2, change / etc / rc.local

echo "su - oracle-c 'lsnrctl start'">> / etc / rc.local

echo "su - oracle-c 'dbstart'">> / etc / rc.local

Actual operation may appear not automatically start the oracle database, the situation!

To oracle editing $ ORACLE_HOME / bin / dbstart, find the first of which 88 lines: ORACLE_HOME_LISTNER = change your own path, or you can change ORACLE_HOME_LISTNER = $ ORACLE_HOME, and $ ORACLE_HOME / bin / dbshut, find the first of which 77 lines: ORACLE_HOME_LISTNER = into your own path, or you can change ORACLE_HOME_LISTNER = $ ORACLE_HOME.

Save the script to oracle user to run dbshut and dbstart to see if closed, start the database. If not, is generally set of parameters, according to Baocuo place to find the corresponding changes.

2, configure the Oracle automatic startup script

First in / etc / rc.d / init.d / directory services configured Oracle Files

# touch / etc / rc.d / init.d / oracle

# chmod 755 / etc / rc.d / init.d / oracle

# chown-R / ect / rc.d / init.d / oracle

Then vi editing oracle file to look at the script in the input to the oracle

#! / bin / sh
#
# / Etc / rc.d / init.d / oracle
# Whoami
# Root
# Chkconfig: 345 51 49
# / Etc / init.d / oracle
# Description: starts the oracle dabase deamons
#

case "$ 1" in
start)
echo-n "Starting Oracle Databases:"
echo "------------------------------------------------ ----">> / var / log / oracle
date + "!% T% a% D: Starting Oracle Databases as part of system up.">> / var / log / oracle
echo "------------------------------------------------ ----">> / var / log / oracle
su - oracle-c dbstart>> / var / log / oracle
echo "Done."
echo-n "Starting Oracle Listeners:"
su - oracle-c "lsnrctl start">> / var / log / oracle
echo "Done."
echo ""
echo "------------------------------------------------ ----">> / var / log / oracle
date + "!% T% a% D: Finished.">> / var / log / oracle
echo "------------------------------------------------ ----">> / var / log / oracle
touch / var / lock / subsys / oracle
;;
stop)
echo-n "Shutting Down Oracle Listeners:"
echo "------------------------------------------------ ----">> / var / log / oracle
date + "!% T% a% D: Shutting Down Oracle Databases as part of system down.">> / var / log / oracle
echo "------------------------------------------------ ----">> / var / log / oracle
su - oracle-c "lsnrctl stop">> / var / log / oracle
echo "Done."
rm-f / var / lock / subsys / oracle
echo-n "Shutting Down Oracle Databases:"
su - oracle-c dbshut>> / var / log / oracle
echo "Done."
echo ""
echo "------------------------------------------------ ----">> / var / log / oracle
date + "!% T% a% D: Finished.">> / var / log / oracle
echo "------------------------------------------------ ----">> / var / log / oracle
;;
restart)
echo-n "Restarting Oracle Databases:"
echo "------------------------------------------------ ----">> / var / log / oracle
date + "!% T% a% D: Restarting Oracle Databases as part of system up.">> / var / log / oracle
echo "------------------------------------------------ ----">> / var / log / oracle
su - oracle-c dbstop>> / var / log / oracle
su - oracle-c dbstart>> / var / log / oracle
echo "Done."
echo-n "Restarting Oracle Listeners:"
su - oracle-c "lsnrctl stop">> / var / log / oracle
su - oracle-c "lsnrctl start">> / var / log / oracle
echo "Done."
echo ""
echo "------------------------------------------------ ----">> / var / log / oracle
date + "!% T% a% D: Finished.">> / var / log / oracle
echo "------------------------------------------------ ----">> / var / log / oracle
touch / var / lock / subsys / oracle
;;
*)
echo "Usage: oracle (start | stop | restart)"
exit 1
esac

Save the file, exit after the service to add and start the look.

# chkconfig - add oracle
# chkconfig - list oracle

chkconfig - list oracle operating results:

oracle 0: off 1: off 2: off 3: on 4: off 5: on 6: off

According to the results of the above operation, when the corresponding run level is on (for example: 5: on), in the corresponding / etc / rc.d / rcN.d (for example: and 5: on corresponds to: / etc / rc .d/rc5.d) The following will generate a file: S95oracle, using the vi S95oracle to open the file, you can see the contents of the file and the / etc / rc.d / init.d / oracle are identical, indicating a successful configuration, in fact, , S95oracle is a reference to / etc / rc.d / init.d / oracle link, we can use the file command to see:

$ file / etc/rc.d/rc5.d/S95oracle

S95oracle: symbolic link to '.. / init.d / oracle

One point:

The script file: # chkconfig: 345 51 49

Pointed out that the 3,4,5-level to start the service, 95 are in the corresponding / etc / rc.d / rcN.d (N for the front of the specified level, here is the 345) directory link files generated by the serial number (to start the priority level) S95oracle, 10 noted above in addition to the level of the corresponding / etc / rc.d / rcN.d (N, other than a 345 other than level) directory link files generated by the serial number (service stopped priority level) K10oracle

Reboot the system, you can see the process start Starting oracle, because we set the priority level of 99, generally the last to start. [OK] later on it. Due to the start emctl, may be a bit slow, the waiting time to be a little bit longer.

After the root can start the implementation of oracle start or oracle stop to start or stop services.

Note:

This script starts normally does not start instance, if you want to start with instances of the words with the script, you need to modify the file: / etc / oratab
If this file does not exist, then it must run the script file generated sh / u01/app/oracle/product/10.2.0/root.sh

Change / etc / oratab the last line of
sid: / oracle/product/10.2.0.1: N
= "
sid: / oracle/product/10.2.0.1: Y (where sid you want to start the database)

Just set up here after the tie in with the above script, boot automatically start oracle can be realized, as well as examples of the.

Common manual control database command to open the em
emctl start dbconsole
Close em
emctl stop dbconsole

Start listener
lsnrctl start Close
lsnrctl stop

Start emagent
emctl start agent
Close
emctl stop agent

Start an instance of
sqlplus / nolog
conn / as sysdba
startup
Close
shutdown immediate

Pass test database is
tnsping
========================================
Frequently Asked Questions:
Web interface buttons appear on the "mouth" of the garbled solution:
1. Stop the service, emctl stop dbconsole;
2. To the relevant directory (RHEL4 which is the / etc / java /) under the font.properties use
font.properties.zh_CN.Redhat8.0 replacement (or font.properties.zh, as long as you can Simplified Chinese.);
3. Delete
$ ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs in gif files
;
4. Re-play services (preferably to restart the server) emctl start dbconsole;

/ etc / oratab the contents of the
orcl: / oracle/10.2.0/db_1: Y
================================================== ===
The following J2EE applications has been configured, and can be used to access the URL listed below.
iSQL * Plus URL:
http://database:5560/isqlplus
iSQL * Plus DBA URL:
http://database:5560/isqlplus/dba
Enterprise Manager 10g Database Control URL:
http://database:1158/em
\ ==========================================

Useful linux commands
df-h
ps-A
top
free
cat / proc / meminfo
uname
grep MemTotal / proc / meminfo
grep SwapTotal / proc / meminfo
hostname

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

standby database upgrade steps

kods.net — Wed, 08 Jul 2009 00:50:02+0000

ORACLE 10G data guard upgrade steps

The original version 10.2.0.1.0
Upgrade version 10.2.0.3.0
Redhat AS4 for 64bit platforms

1. Metalink to download the service pack p5337014_10203_Linux-x86-64.zip

2. Upgrade steps, the first after the upgrade standby machines are known as B, and then switch to upgrade primary, after all known as the A drive
B Machine 2.1 upgrade, shutdown the database, and then implementation. / RunInstall package patch to start the installation step by step, follow the prompts to install the final patch implementation of the end of the installation root.sh.
2.2 to amend the compatible parameter spfile, 10.2.0.3.0 to 10.2.0.1.0 changed
2.3 Start the database, startup mount, and then began to apply log
Alter check log, the log of the application and transfer it to normal, whether there is any error.
As the standby mode, because of inability to open the way to read and write, so can not upgrade the instance of the need to do stanby switch primary.
2.4 confirmed that there is no problem with synchronous standby after A and B will be a machine switchovers, B Machine has now become primary, the start of B machine upgrade
sqlplus' / as sysdba '
sql> startup upgrade; --- open to upgrade the database, otherwise it is impossible to open the example
sql> @ catupgrd.sql --- the beginning of the upgrade, the script in the $ ORACLE_HOME / rdbms / admin, the role is to identify those who need to run the upgrade script, and will automatically run the install script will upgrade your database components.
# Run the utlrp.sql script to recompile all invalid PL / SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.

SQL> @? / Rdbms / admin / utlrp.sql --- compiler about the object of Failure

Probably need to run about 10 minutes, the components with the number of your choice will be, I just installed the Oracle Database Server, so time is not very long.

After the implementation, if there is no error, shutdown immediate closure of the database, and then you can open the database startup.
This time, B machine into a database on the primary database, you can switch to the application on the server.
The beginning of the normal operation of the business, a total downtime of 10 minutes is probably a little more.

3. Upgrade A drive this time of database A plane has been converted into a standby, in accordance with the above steps, shutdown immediate implementation of the closure of the database. / RunInstall package patch to start the installation step by step, follow the prompts to install the final patch implementation of the end of the installation root.sh .
3.1 to amend the compatible parameter spfile, 10.2.0.3.0 to 10.2.0.1.0 changed
3.2 startup mount the database start to begin apply log, look alter the log, the log of the application and transfer it to normal, whether there is any error.
If there is no error, even if the end of the upgrade, some people may ask, this database does not upgrade, that's right, if the time machine A database upgrade, it will inevitably have to stop, and stop applications, due to the need to switch to standby can be upgraded to primary.
But it does not upgrade, do not affect the application of the log, so the data will always be in sync.
So do not worry at this time to switch, wait until the next machine to switch from the B will be A time machine, and then the database upgrade.
Of course you can switch once again, this time on can also be upgraded, but so down to about 10 minutes, which according to the importance of business to set.

Summary:
The merits of this upgrading is less downtime, easy to operate. The disadvantage is that the operation may require two, because there is an upgrade may have to stay after to do so.
oracle upgrade of the official document is too cumbersome steps to watch, according to their own understanding of the upgrade, the feeling is very quick and easy ~

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

linux as4 is installed under the oracle9

kods.net — Tue, 23 Jun 2009 08:29:26+0000

linux as4 is installed under the oracle9

ORACLE patch installed RHAS4 Set
http://www.cublog.cn/opera/showart.php?blogid=8463&id=68996

Environment: Lenovo Wanquan R630 (I think there is no good products) customers are using this server, Lenovo servers that support the specified REDHAT9. 0 / AS 3/AS4 so start preparing to install REDHAT9. 0J, no corresponding results, RAID card driver telephone to the Lenovo technical support, technical support said they do not support, REDHAT9. 0. Mind the installation of AS3, then the next installation of AS3, or RAID driver, however, Lenovo's technical support call, it is necessary to drive, said they were not aware of this technology-driven models, but I almost collapsed, tossing the day, and the results of the case. Ah depressing! Later, asked how do we solve this? The answer AS4 experimental technology installed on! So once in a hard-hearted, plus a small equipment Chant ! It can be said that risk of going through a thousand difficulties, GOOLE, BAIDU a lot of information, finally completed the installation of systems and databases! Hungry heart much good about them! The installation process is now sharing some hope that other brothers and fewer detours, as soon as possible to go back to sleep after work! Originally, there would be no overtime for it! Not worth the overtime too!
A: AS4 operating system installed, choose the best total package to install, or install the ORACLE package to prompt much less.

These packages are a must, prior to the installation of ORACLE check:

1, see the development kit has been installed;
Installation packages and patch packages:
p4198954_21_linux.zip play before running runInstaller.
p3238244_9204_LINUX.zip patch to repair the wrong agent.
play p2617419_210_GENERIC.zip patch 3238244 patches needed.
compat-db - 4.1.25 -9
compat-gcc-32-3.2.3-47.3
compat-gcc-32-c + + -3.2.3-47.3
compat-oracle-rhel4-1.0-3
compat-libcwait-2.0-1
compat-libgcc-296-2.96-132.7.2
compat-libstdc + + -296-2.96-132.7.2
compat-libstdc + + -33-3.2.3-47.3
gcc-3.4.3-9.EL4
gcc-c + +-3.4.3-9.EL4
gnome-libs-1.4.1.2.90-44
gnome-libs-devel-1.4.1.2.90-44
libaio-devel-0.3.102-1
libaio-0.3.102-1
make-3.80-5
openmotif21-2.1.30-11
xorg-x11-deprecated-libs-devel-6.8.1-23.EL
xorg-x11-deprecated-libs-6.8.1-23.EL
Which compat-oracle-rhel4 and compat-libcwait in the following Web site:
http://oss.oracle.com/projects/compat-oracle/files/RedHat/
# Rpm-qa | grep 'compat'
Note: If the package was incomplete, most of Book 3 in the first system disk. Find yourself. A separate installation package. Dependence may be prompted, when prompted to install the failure is

Rpm - nodeps - force *. rpm

Second, extract the installation files Oracle9204
1. Oracle 9iR2 ( 9.2.0 .4)
(1) simplify the process (to oracle registry, the release of the installation file, use less disk space, faster)
LINUX best when installed at a district / bak

gunzip ship_9204_linux_disk1.cpio.gz

cpio-idmv

gunzip ship_9204_linux_disk2.cpio.gz

cpio-idmv gunzip ship_9204_linux_disk3.cpio.gz

cpio-idmv (2) unpacking and decompression process, the automatic creation of three documents containing the installation directory:
Disk1
Disk2
Disk3
Can be installed after the Oracle9iR2.
Third, create a database of the preparations for the installation;
1, create a user / group;
# groupadd dba
# groupadd oinstall
# useradd oracle-g oinstall-G dba
# passwd oracle
2, the establishment of oracle installation folder;
# Mkdir-p / u01/app/oracle/product / 9.2.0 .4
# Mkdir / u01/cwdata
# Chmod 777 / u01/cwdata
# Chown oracle.dba / u01/cwdata
# Chown oracle.dba / orasetup
# Chmod 777 / orasetup
# Chown-R oracle.dba / u01/app/oracle/product/9.2.0.4
# Chmod-R 777 / u01/app/oracle/product/9.2.0.4
2, configure the environment variable;
Login to root user, root user's environment set up to open. Bash_profile file, add this:
export ORACLE_BASE = / u01/app/oracle
export ORACLE_HOME = / u01/app/oracle/product/9.2.0.4
export PATH = $ PATH: $ ORACLE_HOME / bin: $ ORACLE_HOME / Apache / Apache / bin
export ORACLE_OWNER = oracle
export ORACLE_SID = oradb
The use of Oracle User Login:
# su - oracle
$ vi. bash_profile
Following is a profile of content (based on the actual situation of their own)
#. Bash_profile

# Get the aliases and functions
if [-f ~ /. bashrc]; then
. ~ /. Bashrc
fi

# User specific environment and startup programs

PATH = $ PATH: $ HOME / bin
# ORACLE_BASE can navigate to the disk array on / data
export ORACLE_BASE = / u01/app/oracle
export ORACLE_HOME = / u01/app/oracle/product/9.2.0.4
export PATH = $ PATH: $ ORACLE_HOME / bin: $ ORACLE_HOME / Apache / Apache / bin
export ORACLE_OWNER = oracle
export ORACLE_SID = oradb
export ORACLE_TERM = xterm
export LD_ASSUME_KERNEL = 2.4.19
export THREADS_FLAG = native
export LD_LIBRARY_PATH = $ LD_LIBRARY_PATH: $ ORACLE_HOME / lib
export NLS_LANG = "American_america.zhs16gbk"
# Export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export ORA_NLS33 = $ ORACLE_HOME / ocommon / nls / admin / data
export DISPLAY =: 0
export LANG = en_US
export GDM_LANG = en_US
export LC = en_US
export PATH
unset USERNAME
4, set the system parameters;
# su - root to switch to root user
a) modify # vi / etc / sysctl.conf, the following is the contents of configuration files (one red font for the added content):
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl (and
# Sysctl.conf (5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1
kernel.shmmax = 536870912 / 268435456
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
Modified to run # sysctl-p command allows the kernel to change with immediate effect;
Translator's Note: Under normal circumstances you can set the maximum shared memory for half of physical memory, if physical memory is 2G , You can set the maximum shared memory for the 1,073,741,824, as indicated; such as the physical memory is 1G , You can set the maximum shared memory of 512 * 1024 * 1024 = 536,870,912; and so on. )
Proposal to increase shmmax setting permanently.
sem 4 parameters were SEMMSL (each user has a maximum number of semaphore); SEMMNS (the largest number of signals); SEMOPM (for each system call semopm operand); SEMMNI (system hard maximum number of volume sets). Shmmax maximum shared memory, the official document is the memory recommended 1 / 2, Shmmni minimum shared memory size of all memory 4096KB.Shmall

B) set the oracle of the documentation requirements:
Edit the document: # vi / etc / security / limits.conf by adding the following statement:
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384

C ) Gcc downgrade
# su - root
# mv / usr / bin / gcc / usr/bin/gcc34
# ln-s / usr/bin/gcc32 / usr / bin / gcc
# mv / usr / bin / g + + / usr / bin / g + +34
# ln-s / usr / bin / g + +32 / usr / bin / g + +
After the installation is complete remember to resume later in order to prevent future use of GCC
5, to install oracle patch

I suggest the first choice of installation SOFT installation, and then use the DBCA and NETCA and configuration database. As4 installed because the installation ORACLE9204 database at the same time when using DBCA, called JRE problem, you will find that library may have been fixed to stop 46 percent. I waited for more than two hours are not fixed point, then re-install it this way, then call the JRE that he is wrong, it should be a BUG. Therefore, we suggest that you first install the software, after the establishment of databases.

When you implement Oracle 9iR2 CD runInstaller appears when the error message:
Error occurred during initialization of VM
Unable to load native library:
/ tmp / OraInstall 2003-10-25 _03-14-57PM/jre/lib/i386
/ libjava.so symbol _libc_wait, version GLIBC_2.0 not
defined in file libc.so.6 with link time reference
In order to solve the problem _libc_wait symbols,
Download patch from http://oss.oracle.com/projects/compat-oracle/files/RedHat/
compat-libcwait-2.0-2.i386.rpm compat-oracle-rhel4-1.0-5.i386.rpm. In order to apply this patch, you can run:
$ su - root
# Cd / bak
# ls compat *. rpm
compat-libcwait-2.0-2.i386.rpm compat-oracle-rhel4-1.0-5.i386.rpm
# Rpm-Uvh compat *. rpm
Preparing ... ########################################### [100% ]
1at-libcwait-2.0-2.i386.rpm ##################################### [50 %]
at-oracle-rhel4-1.0-5.i386.rpm #################################### [ 100%]
Fourth, start the installation oracle9iR2
(A) to start the installation:
1. To oracle user sign-on system for Oracle installation:
$ Cd Disk1
$. / RunInstaller After a while there will be the installation of Oracle interface
2. Step by step to install it on the list!
The installation process in order to root user will be prompted to perform some procedures for landing
3, after the patch is installed: (I have not encountered the situation Pink)
Switch to root: # su - root to install the first opatch.
# cd / bak

# unzip p2617419_210_GENERIC.zip
Archive: p2617419_210_GENERIC.zip
creating: OPatch /
creating: OPatch / docs /
inflating: Opatch / docs / FAQ
......
inflating: README.txt
# export PATH = $ PATH: / orasetup / OPatch: / sbin
(Modified to include the PATH to extract from the sbin directory and Opatch)
# Unzip p3238244_9204_LINUX.zip
# Cd 3238244
# mkdir / var / tmp / .oracle
# chown oracle: dba / var / tmp / .oracle
# Opatch apply

If the HOME variable error prompt executable statement:
# export ORACLE_BASE = / u01/app/oracle
# export ORACLE_HOME = / u01/app/oracle/product / 9.2.0 .4
Prompt appears on the success of all installed successfully.

After the patch finished, but also relinked one. Mk document window to switch to the oracle user
cd $ ORACLE_HOME / network / lib
make-f ins_oemagent.mk install
Agent will be able to start after the service.

Third: Because DBCA call ORACLE database is the JRE itself a mistake, therefore, I suggest that their up to install a JRE.

1: Download j2sdk-1_4_2_04-linux-i586-rpm.bin to the server

2: chmod + x j2sdk-1_4_2_04-linux-i586-rpm.bin

3: sh j2sdk-1_4_2_04-linux-i586-rpm.bin

4: rpm-ivh j2sdk-1_4_2_04-linux-i586.rpm

5: mv $ ORACLE_HOME / JRE $ ORACLE_HOME / JRE_ORIG

ln-s / usr / java / jdk 1.4.2 / jre $ ORACLE_HOME / JRE

su - root

ln-s / usr / java / jdk 1.4.2 / jre / bin / java / usr/java/jdk1.4.2/jre/bin/jre

ln-s / usr / java / jdk 1.4.2 / jre/bin/i386/native_threads/java / usr/java/jdk1.4.2/jre/bin/i386/native_threads/jre

6: su - oracle

Export JRE_LOCATION = / usr / java / jdk 1.4.2

7: dbca database to establish the beginning of the smooth. . . . . . . . . . . . . All the best of luck

8: netca monitor configuration database

Four: Configure it self-starting

1, after the completion of the database to create, modify / etc / oratab, the final boss of the N line into Y, and then restart the database dbstart implementation of the database may not be able to start, the report Can't find init file ... the error, the need for an initial copy of documents:
cp / u01/app/oracle/admin/oradb/pfile/init.ora .* / u01/app/oracle/product / 9.2.0 / dbs / initoradb.ora
Dbstart rerun it.
In order to facilitate the management, you can write a startup script ora9i:
Entered root in the preparation of the following script:

#! / bin / bash
# start and stop the oracle instance
# Chkconfig-level 5 - add ora9i
# chkconfig: 345 91 19
# Description: starts the oracle listener and instance

export ORACLE_HOME = "/ u01/app/oracle/product/9.2.0.4"
export PATH = $ ORACLE_HOME / bin: $ ORACLE_HOME / Apache / Apache / bin: $ PATH
export ORACLE_OWNER = "oracle"
export ORACLE_SID = oradb

if [!-f $ ORACLE_HOME / bin / dbstart-o!-d $ ORACLE_HOME]
then
echo "oracle startup: cannot start"
exit 1
fi

case "$ 1" in
start)
# startup the listener and instance
echo-n "oracle startup:"
su - $ ORACLE_OWNER-c "$ ORACLE_HOME / bin / lsnrctl start"
su - $ ORACLE_OWNER-c $ ORACLE_HOME / bin / dbstart
touch / var / lock / subsys / oracle
echo "finished"
;;
stop)
# Stop listener, apache and database
echo-n "oracle shutdown:"
su - $ ORACLE_OWNER-c "$ ORACLE_HOME / bin / lsnrctl stop"
su - $ ORACLE_OWNER-c $ ORACLE_HOME / bin / dbshut
rm-f / var / lock / subsys / oracle
echo "finished"
;;
reload | restart)
$ 0 stop
$ 0 start
;;
*)
echo "Usage: ora9i [start | stop | reload | restart]"
exit 1

esac
exit 0

Save as ora9i after, and then use chmod a + x ora9, may in the future to root Run / etc/rc.d/init.d/ora9i start | stop to manage the oracle of the start-up and stopped. If you want this script into the system so that it can be switched, then to run the following command: chkconfig - level 3 (or 5) - add ora9i
Or, to use the root user to perform the following command:
# cp / orasetup/ora9i / etc / rc.d / init.d /
# chmod a + x / etc / rc.d / init.d / ora9
# cd / etc/rc.d/rc5.d
# ln-s / etc/rc.d/init.d/ora9i S99ora9i
# cd / etc/rc.d/rc0.d
# ln-s / etc/rc.d/init.d/ora9i K99ora9i
Can also be self-starting oracle9i!
Or in the / etc / rc.d / rc.local add the following:
su - oracle-c "/ u01/app/oracle/product/9.2.0.4/bin/lsnrctl start"
su - oracle-c "/ u01/app/oracle/product/9.2.0.4/bin/dbstart start"

2
Re-installed on the database to delete the questions:
The ORACLE installation directory and delete the / etc / ora *.* to delete on the list
# rm-f / etc / ora *.*

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

Redhat as4 under the startup script since oracle10g

kods.net — Thu, 18 Jun 2009 04:02:17+0000

Private [http://www.hxre.org/post/42.html]
On the oracle installation in linux system, how to restart in the case of systems for service start up automatically, there are many online tutorials and ready-made script, here is a little personal experience in the work.
Redhat as4 to oracle 10g and as an example. Stand-alone installation process in accordance with the oracle at the official step by step down the document, as long as the parameters set up, installed the necessary packages are generally not a problem. System installed after the resumption, oracle restart the service, on-line recommendations, many people write their own script (script is also very simple in fact), we speak of here is the realization of oracle script itself, of course, the inevitable eventually, to write a little bit: )

1, configuration dbstart and dbshut
In the $ ORACLE_HOME / bin, there are two dbstart and dbshut script, more dbstart look can see:

#
# $ Id: dbstart.sh.pp 11-may-2005.18: 18:07 vikrkuma Exp $
# Copyright (c) 1991, 2005, Oracle. All rights reserved.
#

###################################
#
# Usage: dbstart
#
# This script is used to start ORACLE from / etc / rc (. Local).
# It should ONLY be executed as part of the system boot procedure.
#
# This script will start all databases listed in the oratab file
# Whose third field is a "Y". If the third field is set to "Y" and
# There is no ORACLE_SID for an entry (the first field is a *),
# Then this script will ignore that entry.
#
# This script requires that ASM ORACLE_SID's start with a +, and
# That non-ASM instance ORACLE_SID's do not start with a +.
#
# If ASM instances are to be started with this script, it cannot
# Be used inside an rc *. d directory, and should be invoked from
# Rc.local only. Otherwise, the CSS service may not be available
# Yet, and this script will block init from completing the boot
# Cycle.
#
# Note:
# Use ORACLE_TRACE = T for tracing this script.
#
# The progress log for each instance bringup plus Error and Warning message [s]
# Are logged in file $ ORACLE_HOME / startup.log. The error messages related to
# Instance bringup are also logged to syslog (system log module).
# The Listener log is located at $ ORACLE_HOME_LISTNER / listener.log
......

We can see that this script is used to start the oracle services, including the listener, instance, asm instances, and can be on / etc / rc (. Local)., The same closed dbshut services also play a role.
Configure the system to make the script work:
1) to root to edit / etc / oratab, similar orcl: / u01/product/10.2.0/db_1: N in this format, which orcl is your ORACLE_SID, / u01/product/10.2.0/db_1 is ORACLE_HOME, N need to be changed here Y, that is orcl: / u01/product/10.2.0/db_1: Y do.
2) to oracle editing $ ORACLE_HOME / bin / dbstart, the first of which 78 firms found: ORACLE_HOME_LISTNER = changed to your own path, or you can change ORACLE_HOME_LISTNER = $ ORACLE_HOME
Save the script to run the oracle user dbshut and see if it can dbstart closed, restart the database. If not, the parameters are generally set up, according to the location of error to find the corresponding changes.

2, the dbstart and start dbshut added services redhat step through the configuration, you can directly start data dbstart command listener, instance, asm instances, but no start oracle10g of EM, ORACLE database using web pages rather convenient, but also a feature of 10g, so it should be to start from the service.
$ ORACLE_HOME / bin / emctl start dbconsole
Therefore, we can use rc.local or redhat services required to achieve start-up. , Respectively, talk about the following:

1), the use of rc.local. Dbstart added directly to the rc.local, the realization of the boot automatically activated. It should be noted that the oracle must start the script.
With root edit / etc / rc.local, add the following line:
su - oracle-c "/ u01/product/10.2.0/db_1/bin/dbstart"
su - oracle-c "/ u01/product/10.2.0/db_1/bin/emctl start dbconsole"
Here / u01/product/10.2.0/db_1 need to replace the actual ORACLE_HOME
After save and exit, reboot the server to test, we can see that when the system boot after the oracle monitoring, examples and em are already up
2), if we do not have rc.local, can also be added to the service of redhat. In / etc / rc.d / init.d to add the following script file, named as oracle:
#! / bin / sh
# chkconfig: 2345 99 01
# description: ORACLE 10g Server

ORACLE_HOME = / u01/product/10.2.0/db_1

if [!-f $ ORACLE_HOME / bin / dbstart]
then
echo "ORACLE cannot start"
exit
fi

case "$ 1" in
'start')
echo "Starting Oracle Database ..."
su - oracle-c "$ ORACLE_HOME / bin / dbstart"
su - oracle-c "$ ORACLE_HOME / bin / emctl start dbconsole"
;;
'stop')
echo "Stoping Oracle Database"
su - oracle-c "$ ORACLE_HOME / bin / emctl stop dbconsole"
su - oracle-c "$ ORACLE_HOME / bin / dbshut"
;;
esac

Attention to two lines of notes, on-line script because a lot of these lines can not be less since the launch of the service:
# chkconfig: 2345 99 01
# description: ORACLE 10g Server
Which chkconfig: 2345 99 01 will run the script refers to 2,3,4,5-class service to start oracle 10g to start priority 99 to close for the 01 priority.

And then to root permissions:
# Cd / etc/rc2.d
# Ln-s / etc / rc.d / init.d / oracle S99oracle
# Chkconfig - list oracle
# Chkconfig - level 2345 on
Reboot the system, you can see the process start Starting oracle, because we set the priority to 99, is generally the last to start. [OK] after it. In order to start emctl, may be a bit slow, wait a little longer time.
Then you can start to root or oracle start the implementation of oracle stop to start or stop services.

-------------------------------------------------- ---------------------------------------------
1, amend the Oracle system, configuration file / etc / oratab
/ etc / oratab format: SID: ORACLE_HOME: AUTO
AUTO field is set to the Y (upper case), the only way, oracle and dbstart own dbshut be able to play a role. I am for:
ora9i: / home/oracle/ora/products/9.2.0: Y
2, preparation of service script:
As follows
#! / bin / bash
#
################# FUNCTION #############
#
# AutoStart Oracle and listener
# AutoStop Oracle and listener
#
#####################################
#
# Created by ZhouYS 2003-11-26
#
case "$ 1" in
start)
echo "Starting Oracle Databases ..."
echo "------------------------------------------------ - ">> / var / log / oracle
date + "% T% a% D: Starting Oracle Databasee as part of system up.">> / var / log / oracle
echo "------------------------------------------------ - ">> / var / log / oracle
su - oracle-c "dbstart">> / var / log / oracle
echo "Done."
echo "Starting Oracle Listeners ..."
echo "------------------------------------------------ - ">> / var / log / oracle
date + "% T% a% D: Starting Oracle Listeners as part of system up.">> / var / log / oracle
echo "------------------------------------------------ - ">> / var / log / oracle
su - oracle-c "lsnrctl start">> / var / log / oracle
echo "Done."
echo ""
echo "------------------------------------------------ - ">> / var / log / oracle
date + "% T% a% D: Finished.">> / var / log / oracle
echo "------------------------------------------------ - ">> / var / log / oracle
touch / var / lock / subsys / oracle

;;
stop)
echo "Stoping Oracle Listeners ..."
echo "------------------------------------------------ - ">> / var / log / oracle
date + "% T% a% D: Stoping Oracle Listener as part of system down.">> / var / log / oracle
echo "------------------------------------------------ - ">> / var / log / oracle
su - oracle-c "lsnrctl stop">> / var / log / oracle
echo "Done."
rm-f / var / lock / subsys / oracle
echo "Stoping Oracle Databases ..."
echo "------------------------------------------------ - ">> / var / log / oracle
date + "% T% a% D: Stoping Oracle Databases as part of system down.">> / var / log / oracle
echo "------------------------------------------------ - ">> / var / log / oracle
su - oracle-c "dbshut">> / var / log / oracle
echo "Done."
echo ""
echo "------------------------------------------------ - ">> / var / log / oracle
date + "% T% a% D: Finished.">> / var / log / oracle
echo "------------------------------------------------ - ">> / var / log / oracle

;;
restart)
$ 0 stop
$ 0 start

;;
*)
echo "Usage: oracle (start | stop | restart)"
exit 1
esac

The script is named oracle, stored in / etc / rc.d / init.d to change file attributes: chmod 755 oracle

Note: in windows to edit the file under the DOS format have resulted in character can not be under linux the normal operation of the proposed use gedit or vi editor

3, the establishment of service connection:
System startup to start the database, we need the following link:
-------------------------------------------------- ------------------------------
$ Ln-s .. / init.d / oracle / etc/rc.d/rc2.d/S99oracle
$ Ln-s .. / init.d / oracle / etc/rc.d/rc3.d/S99oracle
$ Ln-s .. / init.d / oracle / etc/rc.d/rc5.d/S99oracle # rc4.d unused

-------------------------------------------------- ------------------------------

To stop the database is restarted, we need the following link:

-------------------------------------------------- ------------------------------

$ Ln-s .. / init.d / oracle / etc/rc.d/rc0.d/K01oracle # stop
$ Ln-s .. / init.d / oracle / etc/rc.d/rc6.d/K01oracle # restart

-------------------------------------------------- ------------------------------

****** Is the online copy of the above, the following is my method ******

-------------------------------------------------- ------------------------------

The simplest way to Ha ha

First of all, the oracle / product / .. / bin script under dbstart get, if the oracle can run on dbstart if, in the / etc / rc.local add the following:

su - oracle-c "/ home/oracle/oracle/product/10.2.0/db_1/bin/dbstart"
su - oracle-c "/ home/oracle/oracle/product/10.2.0/db_1/bin/emctl start dbconsole"
Can.

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

Oracle Rac (Redhat as4 u2) package

kods.net — Thu, 17 Jul 2008 00:48:15+0000

Redhat as4 update 2, kernel version 2.6.9-22.ELsmp

RAC Software requirements:

RPM Download

File:	oracleasmlib-2.0.2-1.i386.rpm
Size:	12KB
Download:	Download

RPM Download

File:	oracleasm-2.6.9-22.ELsmp-2.0.3-1.i686.rpm
Size:	125KB
Download:	Download

RPM Download

File:	oracleasm-support-2.0.3-1.i386.rpm
Size:	22KB
Download:	Download

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
High Availability Oracle Flashback 2009-02-26 17:23:02
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

Common Linux installation error under the Summary oracle

kods.net — Wed, 25 Jun 2008 05:49:29+0000

Problem Summary: Linux install error under the Summary oracle common source: www.ixdba.net of: IXDBA.NET official

This problem is too few classics, and helpful to everyone.

Error 1:

/ Tmp/OraInstall2007-12-30_02-16-11PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred ..

The reasons are: lack of support printed graphics dynamic link library libXp.so.6

This error is due to the lack of system installation package, the previous version in RHEL5, you can install the xorg-x11-deprecated-libs package can be, this installation package can be the third CD in the system tray to find (for redhat as4.2 ago, redhat as4. 4 is the fourth CD-ROM)

IXDBA.NET Community Forums

I downloaded the file as follows:

xorg-x11-deprecated-libs-6.8.2-31.i386.rpm

Error 2:

Exception: java.lang.UnsatisfiedLinkError: / usr/java/j2sdk1.4.2_06/jre/lib/i386/libawt.so: libXt.so.6: cannot open shared object file: No such file or directory
This error is also due to the lack of the system caused by the installation package, just install the XFree86-libs package can be, this installation package can be found in the system CD.

If the above two errors in the redhat as5 version, resolved as follows:

In RHEL5 the above package is libXp replaced, so the rpm-ivh libXp-1.0.0-8.i386.rpm after the package marked with the problem can be solved.

Error 3:

error while loading shared libraries: libstdc + +-libc6.1-1.so.2

Only do the following ln-s libstdc + +-libc6.2-2.so.3 libstdc + +-libc6.1-1.so.2

Reference Case

Case 1:

Tested in the RHEL5 install oracle10g, that before the turn of the 11g, this would be more successful, the result is still two problems.

First of all, in the implementation of the runInstaller, the system error:

You do not have sufficient permissions to access the inventory '/ oracle11g/oraInventory'. Installation cannot continue. Make sure that you have read / write permissions to the inventory directory and restart the installer.: Permission denied

Is used here to create a new way for users 10g 10g, 11g coexist, in fact, when you start the installer, oracle will look for / etc / oraInst.loc and oratab these two files (hp is / var / opt / oracle )

Which is defined in oraInst.loc inventory_loc location and inst_group, as had before the installation of a 11g, which is the definition of user settings for 11g, so the only error. Solution is the implementation of runInstaller-invPtrLoc / oracle10g/oraInst.loc command can be passed around, oracle will create a new loc file.

After the previous step successfully, followed by reporting the following error:

Exception java.lang.UnsatisfiedLinkError: / tmp/OraInstall2007-08-30_02-16-11PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred ..
java.lang.UnsatisfiedLinkError: / tmp/OraInstall2007-08-30_02-16-11PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory

In RHEL5 before this error is because of lack of XFree86-libs or xorg-x11-deprecated-libs package one of the two (different versions of different packages), and in RHEL5 in front of the package is libXp replaced, so the rpm-ivh libXp -1.0.0-8.i386.rpm after the package marked solve the problem. After all the best.

Case 2:

Reference http://moto.debian.org.tw/viewtopic.php?t=8055&sid=eb2524337903c5af7ce1e839e0a35b68
Preparation for the installation of pre-installed at the beginning of the following errors:

For error while loading shared libraries: libstdc + +-libc6.1-1.so.2
My solution is to
ln-s libstdc + +-libc6.2-2.so.3 libstdc + +-libc6.1-1.so.2
For
Exception: java.lang.UnsatisfiedLinkError: / usr/java/j2sdk1.4.2_06/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
Solution is
apt-get install libXp.so.6
apt-get install libXt.so.6
apt-get install libxtst6

Case 3:

In RH Linux7.3 JasperReport as the reporting engine to use when encountered the same problem:
Exception: java.lang.UnsatisfiedLinkError: / usr/java/j2sdk1.4.2_06/jre/lib/i386/libawt.so: libXt.so.6: cannot open shared object file: No such file or directory

In reply to the prompt you before, after one morning google, finally able to solve this problem because: a lack of support for printing graphics dynamic link library libXp.so.6 (perhaps related to other libraries)
Solution: Download and install the XFree86-libs-4.2.0-8.i386.rpm, / usr/X11R6/lib need libXp.so.6.2 will appear under the

Attached to XFree86-libs-4.2.0-8.i386.rpm's a download address:
ftp://ftp.nluug.nl/vol/1/schoollan/os/linux/RPMS/XFree86-libs-4.2.0-8.i386.rpm

the basis of oracle problem (segment, extent, block) 2009-06-19 14:00:16
Redhat as4 under the startup script since oracle10g 2009-06-18 04:02:17
apex3.2 steps to install oracle10 2009-04-19 10:33:11
Oracle installation difficulties 2009-04-19 04:08:56
setting to discuss filing oracle10g 2009-04-02 05:19:08

as4

Modify the parameters of a process share pool

Related Posts

oracle em web button garbled

Related Posts

Problem Summary: Linux install error under the common summary oracle

Related Posts

Problem Summary: Linux installation error under the common conclusion oracle

Related Posts

Rman problem novice small note 3: Create auxiliary instance encountered ORA-01031

Related Posts

dbca building a database script analysis

Reference:

Related Posts

yangtingkun personal BLOG Article Index ---- RAC aspects of

Related Posts

TNS-12555: TNS: permission denied error solution

Related Posts

The use of VMware Server on Linux to install Oracle RAC (1)

Related Posts

Redhat as4 since the startup script under the oracle10g

Related Posts

standby database upgrade steps

Related Posts

linux as4 is installed under the oracle9

Related Posts

Redhat as4 under the startup script since oracle10g

Related Posts

Oracle Rac (Redhat as4 u2) package

Related Posts

Common Linux installation error under the Summary oracle

Related Posts