ORA-29702: error occur…

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 Symptoms Cause Solution 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.