Symptoms:
While starting up the database(Signal Intance), Getting error ORA-29702
数据库软件是RAC环境拷贝过来的,启动环境是单实例环境
ORA-29702: error occurred in Cluster Group Service operation
Alertlog:
Thu Sep 25 10:34:35 2014 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 2014-09-25 10:34:38.565: [USER(11724)]CRS-2317:Fatal error: cannot get local GPnP security keys (wallet). 2014-09-25 10:34:38.566: [USER(11724)]CRS-2316:Fatal error: cannot initialize GPnP, CLSGPNP_ERR (Generic GPnP error). kggpnpInit: failed to init gpnp WARNING: No cluster interconnect has been specified. Depending on the communication driver configured Oracle cluster traffic may be directed to the public interface of this machine. Oracle recommends that RAC clustered databases be configured with a private interconnect for enhanced security and performance. Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =44 LICENSE_MAX_USERS = 0 SYS auditing is enabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options. ORACLE_HOME = /pool08/test3/db/tech_st/11.2.0 System name: SunOS Node name: ebs2.scc.com Release: 5.10 Version: Generic_142909-17 Machine: sun4u Using parameter settings in server-side pfile /pool08/test3/db/tech_st/11.2.0/dbs/initTEST3.ora System parameters with non-default values: processes = 200 sessions = 400 sga_max_size = 5G shared_pool_size = 0 shared_pool_reserved_size= 36071014 nls_territory = "america" nls_sort = "binary" nls_date_format = "DD-MON-RR" nls_numeric_characters = ".," nls_comp = "binary" nls_length_semantics = "BYTE" sga_target = 0 memory_target = 6G memory_max_target = 6G control_files = "/pool08/test3/db/apps_st/data/cntrl01.dbf" db_file_name_convert = "/oracle_ebs/prod" db_file_name_convert = "/pool08/test3" db_block_checksum = "TRUE" db_block_size = 8192 compatible = "11.2.0" log_archive_dest_1 = "LOCATION=/pool08/test3/db/apps_st/data/archive" log_archive_format = "%t_%s_%r.dbf" log_buffer = 10485760 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = "AUTO" undo_tablespace = "APPS_UNDOTS1" db_block_checking = "FALSE" recyclebin = "OFF" sec_case_sensitive_logon = FALSE audit_sys_operations = TRUE session_cached_cursors = 500 utl_file_dir = "/usr/tmp" utl_file_dir = "/usr/tmp/test3" utl_file_dir = "/pool08/test3/db/tech_st/11.2.0/appsutil/outbound/test3_ebs2" utl_file_dir = "/usr/tmp" plsql_code_type = "INTERPRETED" plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = "EXACT" parallel_min_servers = 0 parallel_max_servers = 8 db_name = "TEST3" open_cursors = 600 os_authent_prefix = "" _sort_elimination_cost_ratio= 5 sql92_security = TRUE _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE _like_with_bind_as_equality= TRUE pga_aggregate_target = 0 workarea_size_policy = "AUTO" _optimizer_autostats_job = FALSE optimizer_secure_view_merging= FALSE aq_tm_processes = 1 olap_page_pool_size = 4M _trace_files_public = FALSE max_dump_file_size = "20480" Obsolete system parameters with specified values: plsql_native_library_dir plsql_native_library_subdir_count End of obsolete system parameter listing Cluster communication is configured to use the following interface(s) for this instance 10.10.*.* cluster interconnect IPC version:Oracle UDP/IP (generic) IPC Vendor 1 proto 2 Thu Sep 25 10:34:41 2014 PMON started with pid=2, OS id=11728 Thu Sep 25 10:34:41 2014 PSP0 started with pid=3, OS id=11730 Thu Sep 25 10:34:43 2014 VKTM started with pid=4, OS id=11732 VKTM running at (100ms) precision Thu Sep 25 10:34:43 2014 GEN0 started with pid=5, OS id=11736 Thu Sep 25 10:34:43 2014 DIAG started with pid=6, OS id=11738 Thu Sep 25 10:34:43 2014 DBRM started with pid=7, OS id=11740 Thu Sep 25 10:34:43 2014 PING started with pid=8, OS id=11742 Thu Sep 25 10:34:43 2014 ACMS started with pid=9, OS id=11744 Thu Sep 25 10:34:43 2014 DIA0 started with pid=10, OS id=11746 Thu Sep 25 10:34:43 2014 LMON started with pid=11, OS id=11748 Thu Sep 25 10:34:43 2014 LMD0 started with pid=12, OS id=11750 * Load Monitor used for high load check * New Low - High Load Threshold Range = [7680 - 10240] Thu Sep 25 10:34:43 2014 RMS0 started with pid=13, OS id=11752 Thu Sep 25 10:34:43 2014 LMHB started with pid=14, OS id=11754 Thu Sep 25 10:34:43 2014 MMAN started with pid=15, OS id=11756 Thu Sep 25 10:34:44 2014 DBW0 started with pid=16, OS id=11758 Thu Sep 25 10:34:44 2014 LGWR started with pid=17, OS id=11760 Thu Sep 25 10:34:44 2014 CKPT started with pid=18, OS id=11762 Thu Sep 25 10:34:44 2014 SMON started with pid=19, OS id=11764 Thu Sep 25 10:34:44 2014 RECO started with pid=20, OS id=11766 Thu Sep 25 10:34:44 2014 MMON started with pid=21, OS id=11768 Thu Sep 25 10:34:44 2014 MMNL started with pid=22, OS id=11770
Solution:
Oracle用户
-bash-3.00$ cd $ORACLE_HOME/rdbms/lib
-bash-3.00$ make -f ins_rdbms.mk rac_off rm -f /pool08/test3/db/tech_st/11.2.0/lib/libskgxp11.so cp /pool08/test3/db/tech_st/11.2.0/lib//libskgxpg.so /pool08/test3/db/tech_st/11.2.0/lib/libskgxp11.sorm -f /pool08/test3/db/tech_st/11.2.0/lib/libskgxn2.so cp /pool08/test3/db/tech_st/11.2.0/lib//libskgxns.so \ /pool08/test3/db/tech_st/11.2.0/lib/libskgxn2.so /usr/ccs/bin/ar d /pool08/test3/db/tech_st/11.2.0/rdbms/lib/libknlopt.a kcsm.o /usr/ccs/bin/ar cr /pool08/test3/db/tech_st/11.2.0/rdbms/lib/libknlopt.a /pool08/test3/db/tech_st/11.2.0/rdbms/lib/ksnkcs.o -bash-3.00$ -bash-3.00$ make -f ins_rdbms.mk ioracle chmod 755 /pool08/test3/db/tech_st/11.2.0/bin
- Linking Oracle rm -f /pool08/test3/db/tech_st/11.2.0/rdbms/lib/oracle /usr/ccs/bin/ld -o /pool08/test3/db/tech_st/11.2.0/rdbms/lib/oracle -L/pool08/test3/db/tech_st/11.2.0/rdbms/lib/ -L/pool08/test3/db/tech_st/11.2.0/lib/ -dy /pool08/test3/db/tech_st/11.2.0/lib/prod/lib/v9/crti.o /pool08/test3/db/tech_st/11.2.0/lib/prod/lib/v9/crt1.o /pool08/test3/db/tech_st/11.2.0/rdbms/lib/opimai.o /pool08/test3/db/tech_st/11.2.0/rdbms/lib/ssoraed.o /pool08/test3/db/tech_st/11.2.0/rdbms/lib/ttcsoi.o -z allextract -lperfsrv11 -z defaultextract /pool08/test3/db/tech_st/11.2.0/lib/nautab.o /pool08/test3/db/tech_st/11.2.0/lib/naeet.o /pool08/test3/db/tech_st/11.2.0/lib/naect.o /pool08/test3/db/tech_st/11.2.0/lib/naedhs.o /pool08/test3/db/tech_st/11.2.0/rdbms/lib/config.o -lserver11 -lodm11 -lcell11 -lnnet11 -lskgxp11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lvsn11 -lcommon11 -lgeneric11 -lknlopt `if /usr/ccs/bin/ar tv /pool08/test3/db/tech_st/11.2.0/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap11" ; fi` -lslax11 -lpls11 -lplp11 -lserver11 -lclient11 -lvsn11 -lcommon11 -lgeneric11 `if [ -f /pool08/test3/db/tech_st/11.2.0/lib/libavserver11.a ] ; then echo "-lavserver11" ; else echo "-lavstub11"; fi` `if [ -f /pool08/test3/db/tech_st/11.2.0/lib/libavclient11.a ] ; then echo "-lavclient11" ; fi` -lknlopt -lslax11 -lpls11 -lplp11 -ljavavm11 -lserver11 -lwwg `cat /pool08/test3/db/tech_st/11.2.0/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /pool08/test3/db/tech_st/11.2.0/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lztkg11 `cat /pool08/test3/db/tech_st/11.2.0/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /pool08/test3/db/tech_st/11.2.0/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `if /usr/ccs/bin/ar tv /pool08/test3/db/tech_st/11.2.0/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo11"; fi` -L/pool08/test3/db/tech_st/11.2.0/ctx/lib/ -lctxc11 -lctx11 -lzx11 -lgx11 -lctx11 -lzx11 -lgx11 -lordimt11 -lclsra11 -ldbcfg11 -lhasgen11 -lskgxn2 -lnnz11 -lzt11 -lxml11 -locr11 -locrb11 -locrutl11 -lhasgen11 -lskgxn2 -lnnz11 -lzt11 -lxml11 -loraz -llzopro -lorabz2 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lsnls11 -lunls11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lasmclnt11 -lcommon11 -lcore11 `cat /pool08/test3/db/tech_st/11.2.0/lib/sysliblist` -R /opt/SUNWcluster/lib/sparcv9 -R/pool08/test3/db/tech_st/11.2.0/lib -R /opt/ORCLcluster/lib/ -Y P,:/opt/SUNWcluster/lib/sparcv9:/opt/ORCLcluster/lib/:/usr/ccs/lib/sparcv9:/usr/lib/sparcv9 -Qy -lm /pool08/test3/db/tech_st/11.2.0/lib/prod/lib/v9/crtn.o ld: warning: symbol `_start' has differing types: (file /pool08/test3/db/tech_st/11.2.0/lib/prod/lib/v9/crt1.o type=FUNC; file /pool08/test3/db/tech_st/11.2.0/lib//libserver11.a(skds.o) type=OBJT); test ! -f /pool08/test3/db/tech_st/11.2.0/bin/oracle ||\ mv -f /pool08/test3/db/tech_st/11.2.0/bin/oracle /pool08/test3/db/tech_st/11.2.0/bin/oracleO mv /pool08/test3/db/tech_st/11.2.0/rdbms/lib/oracle /pool08/test3/db/tech_st/11.2.0/bin/oracle chmod 6751 /pool08/test3/db/tech_st/11.2.0/bin/oracle
NON-RAC Database Startup Giving Error ORA-29702 (文档 ID 433310.1) 转到底部
In this Document
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.3 and later Oracle Solaris on SPARC (64-bit) ***Checked for relevance on 15-Jun-2012*** ***Checked for relevance on 27-Aug-2014*** Symptoms While starting up the database, Getting error ORA-29702
Messages in the Alert Log file:
Cluster communication is configured to use the following interface(s) for this instance 192.168.193.2 Wed May 23 16:00:55 2007 cluster interconnect IPC version:Oracle UDP/IP (generic) WARNING: Failed to set buffer limit on IPC interconnect socket Oracle requires that the SocketReceive buffer size be tunable upto 1MB Please make sure the kernel parameterwhich limits SO_RCVBUF value set by applications is atleast 1MB MMNL started with pid=15, OS id=14908 Wed May 23 16:00:56 2007 starting up 1 shared server(s) ... USER: terminating instance due to error 29702 Instance terminated by USER, pid = 14841
Cause RDBMS install is not running on RAC but still it is assuming it to be RAC instance. Cluster information required according to alert.log
Solution 1. Shutdown the database completely. 2. Relink with RAC OFF :
$ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk rac_off $ make -f ins_rdbms.mk ioracle
3. Startup the database.