Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Challenge with Oracle 10G without Network on AIX
Prepare for information overload. I've included the logs and config
files mentioned in the various posts on this subject. I separated each
file/entry with "****************" and filename.
Thanks again for your posts.
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /usr/app/oracle/OraHome_2
System name: AIX
Node name: ebc123 Release: 3 Version: 5 Machine: 00C0072A4C00
kstwlb: SGA is no longer mapped
AUM timeouts: MQL_TUNE(300s) TUR_TUNE(60s) SESS_EXPRN(1800s)
QRY_EXPRN(1800s) SL
OT_PERIOD(600s) MQL_CUSHION(300s) KSUCKI_FG_PERIOD(150s)
MMNL_EXPRN(1200s) KTTSI
NFO(300s)
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.1.0.2.0 - Production Start Date 27-JUN-2005 09:43:15 Uptime 0 days 0 hr. 3 min. 47 sec Trace Level off Security ON: Local OS Authentication SNMP OFF
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebc123.xxxxx.xxxxx.com)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
The command completed successfully
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /usr/app/oracle/OraHome_2
System name: AIX
Node name: ebc123 Release: 3 Version: 5 Machine: 00C0072A4C00
kstwlb: SGA is no longer mapped
AUM timeouts: MQL_TUNE(300s) TUR_TUNE(60s) SESS_EXPRN(1800s)
QRY_EXPRN(1800s) SL
OT_PERIOD(600s) MQL_CUSHION(300s) KSUCKI_FG_PERIOD(150s)
MMNL_EXPRN(1200s) KTTSI NFO(300s)
Alert_demo.log
Mon Jun 27 09:42:50 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as
USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150 shared_pool_size = 125829120 large_pool_size = 8388608 java_pool_size = 125829120 control_files =/usr/app/oracle/OraHome_2/oradata/demo/control02.ctl,
/usr/app/oracle/OraHome_2/oradata/demo/control01.ctl,
db_block_size = 8192 db_cache_size = 25165824 compatible = 10.1.0.2.0
undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=demoXDB) job_queue_processes = 10 background_dump_dest = /usr/app/oracle/OraHome_2/admin/demo/bdump user_dump_dest = /usr/app/oracle/OraHome_2/admin/demo/udump core_dump_dest = /usr/app/oracle/OraHome_2/admin/demo/cdump sort_area_size = 65536 db_name = demo open_cursors = 300 pga_aggregate_target = 25165824
LGWR started with pid=5, OS id=217272 PMON started with pid=2, OS id=266454 CKPT started with pid=6, OS id=282812 MMAN started with pid=3, OS id=94250 SMON started with pid=7, OS id=299158 DBW0 started with pid=4, OS id=200912 RECO started with pid=8, OS id=295060
Topas Monitor for host: ebc123 EVENTS/QUEUES FILE/TTY
Mon Jun 27 09:53:38 2005 Interval: 2 Cswitch 63 Readch 158 Syscall 105 Writech 336 Kernel 0.4 |# | Reads 0 Rawin 0 User 95.1 |########################### | Writes 1 Ttyout 158 Wait 0.0 | | Forks 0 Igets 0 Idle 4.5 |## | Execs 0 Namei 21 Physc = 0.40 %Entc= 99.7 Runqueue 1.5 Dirblk 0 Waitqueue 0.0 Network KBPS I-Pack O-Pack KB-In KB-Out en0 0.2 0.5 0.5 0.0 0.2 PAGING MEMORY lo0 0.0 0.0 0.0 0.0 0.0 Faults 0 Real,MB 2047 Steals 0 % Comp 37.5 Disk Busy% KBPS TPS KB-Read KB-Writ PgspIn 0 % Noncomp 5.5 hdisk0 0.0 0.0 0.0 0.0 0.0 PgspOut 0 % Client 7.8 PageIn 0 Name PID CPU% PgSp Owner PageOut 0 PAGING SPACE oracle 266454 9.5 9.9 oracle Sios 0 Size,MB 512 topas 331972 0.0 1.3 root % Used 1.4 java 372920 0.0 34.9 oracle NFS (calls/sec) % Free 98.5 oracle 364722 0.0 5.2 oracle ServerV2 0 gil 61470 0.0 0.1 root ClientV2 0 Press: oracle 360624 0.0 7.4 oracle ServerV3 0 "h" for help oracle 217272 0.0 5.6 oracle ClientV3 0 "q"to quit
# ps -ef |grep ora
oracle 94250 1 0 09:42:53 - 0:00 ora_mman_demo oracle 151734 1 0 09:42:54 - 0:00 ora_d000_demo oracle 200912 1 0 09:42:53 - 0:00 ora_dbw0_demo oracle 217272 1 0 09:42:53 - 0:00 ora_lgwr_demo oracle 233608 1 0 09:42:53 - 0:00 ora_cjq0_demo oracle 262278 1 0 09:42:54 - 0:00 ora_s000_demo oracle 266454 1 120 09:42:53 - 4:03 ora_pmon_demo oracle 282812 1 0 09:42:53 - 0:00 ora_ckpt_demo oracle 295060 1 0 09:42:53 - 0:00 ora_reco_demo oracle 299158 1 0 09:42:53 - 0:00 ora_smon_demo oracle 331974 1 0 09:54:15 - 0:00 ora_q000_demo oracle 352442 1 0 09:43:14 - 0:00
/usr/app/oracle/OraHome_2/bin/tnslsnr LISTENER -inherit
oracle 356526 1 0 09:43:08 - 0:00 ora_qmnc_demo oracle 360624 1 0 09:43:12 - 0:00 ora_mmon_demo oracle 364722 1 0 09:43:13 - 0:00 ora_mmnl_demo oracle 372920 1 0 09:43:15 - 0:04
-Doracle.oc4j.localhome=/usr/app/oracle/OraHome_2/sqlplus -Djava.security.properties=/usr/app/oracle/OraHome_2/oc4j/j2ee/home/config/jazn.security.props -jar /usr/app/oracle/OraHome_2/oc4j/j2ee/home/oc4j.jar -config
23-JUN-2005 16:10:15 *
(CONNECT_DATA=(SERVICE_NAME=demo)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.121)(PORT=32783)) *
establish * demo * 12514
TNS-12514: TNS:listener does not currently know of service requested in
connect descriptor
No longer listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
No longer listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebc123.xxxxx.xxxxx.com)(PORT=1521)))
27-JUN-2005 09:30:48 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ebc123)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=168821248))
* stop * 0
TNSLSNR for IBM/AIX RISC System/6000: Version 10.1.0.2.0 - Production on 27-JUN-2005 09:43:14
Copyright (c) 1991, 2004, Oracle. All rights reserved.
System parameter file is
/usr/app/oracle/OraHome_2/network/admin/listener.ora
Log messages written to
/usr/app/oracle/OraHome_2/network/log/listener.log
Trace information written to
/usr/app/oracle/OraHome_2/network/trace/listener.trc
Trace level is currently 0
Started with pid=352442
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebc123.xxxxx.xxxxx.com)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
CODE
27-JUN-2005 09:43:15 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ebc123)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=168821248))
* status * 0
27-JUN-2005 09:47:02 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ebc123)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=168821248))
* status * 0
$
cat spfiledemo.ora
�6Q*.background_dump_dest='/usr/app/oracle/OraHome_2/admin/demo/bdump'
*.compatible='10.1.0.2.0' *.control_files='/usr/app/oracle/OraHome_2/oradata/demo/control01.ctl','/usr/app/oracle/OraHome_2/oradata/demo/control02.ctl','/usr/app/oracle/OraHome_2/oradata/demo/control03.ctl' *.core_dump_dest='/usr/app/oracle/OraHome_2/admin/demo/cdump' *.db_block_size=8192 *.db_cache_size=25165824 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='demo' *.db_recovery_file_dest='/usr/app/oracle/OraHome_2/flash_recovery_area' *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=demoXDB)' *.java_pool_size=125829120 *.job_queue_processes=10 *.large_pool_size=8388608 *.open_cursors=300 *.pga_aggregate_target=25165824 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.shared_pool_size=125829120 *.sort_area_size=65536 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/usr/app/oracle/OraHome_2/admin/demo/udump' ****************************
# listener.ora Network Configuration File:
/usr/app/oracle/OraHome_2/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc) (ORACLE_HOME = /usr/app/oracle/OraHome_2) (PROGRAM = extproc)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ebc123.xxxxx.xxxxx.com)(PORT = 1521)) )
# tnsnames.ora Network Configuration File:
/usr/app/oracle/OraHome_2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DEMO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ebc123.xxxxx.xxxxx.com)(PORT =
1521))
(CONNECT_DATA =
(SERVER = DEDICATED) (SERVICE_NAME = demo)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc) (PRESENTATION = RO)
/etc/hosts
xxx.xxx.xxx.123 ebc123.xxxx.xxxx.com
# # $Header: init.ora 06-aug-98.10:24:40 atsukerm Exp $ # # Copyright (c) 1991, 1997, 1998 by Oracle Corporation # NAME # init.ora # FUNCTION # NOTES # MODIFIED # atsukerm 08/06/98 - fix for 8.1. # hpiao 06/05/97 - fix for 803 # glavash 05/12/97 - add oracle_trace_enable comment # hpiao 04/22/97 - remove ifile=, events=, etc. # alingelb 09/19/94 - remove vms-specific stuff # dpawson 07/07/93 - add more comments regarded archive start # maporter 10/29/92 - Add vms_sga_use_gblpagfile=TRUE # jloaiza 03/07/92 - change ALPHA to BETA # danderso 02/26/92 - change db_block_cache_protect to _db_block_cache_p # ghallmar 02/03/92 - db_directory -> db_domain # maporter 01/12/92 - merge changes from branch 1.8.308.1 # maporter 12/21/91 - bug 76493: Add control_files parameter # wbridge 12/03/91 - use of %c in archive format is discouraged # ghallmar 12/02/91 - add global_names=true, db_directory=us.acme.com # thayes 11/27/91 - Change default for cache_clone # jloaiza 08/13/91 - merge changes from branch 1.7.100.1 # jloaiza 07/31/91 - add debug stuff # rlim 04/29/91 - removal of char_is_varchar2 # Bridge 03/12/91 - log_allocation no longer exists # Wijaya 02/05/91 - remove obsolete parameters # ############################################################################## # Example INIT.ORA file # # This file is provided by Oracle Corporation to help you customize # your RDBMS installation for your site. Important system parameters # are discussed, and example settings given. # # Some parameter settings are generic to any size installation. # For parameters that require different values in different size # installations, three scenarios have been provided: SMALL, MEDIUM # and LARGE. Any parameter that needs to be tuned according to # installation size will have three settings, each one commented # according to installation size. # # Use the following table to approximate the SGA size needed for the # three scenarious provided in this file: # # -------Installation/Database Size------ # SMALL MEDIUM LARGE # Block 2K 4500K 6800K 17000K # Size 4K 5500K 8800K 21000K # # To set up a database that multiple instances will be using, place # all instance-specific parameters in one file, and then have all # of these files point to a master file using the IFILE command. # This way, when you change a public # parameter, it will automatically change on all instances. This is# necessary, since all instances must run with the same value for many # parameters. For example, if you choose to use private rollback segments,
# # INSTRUCTIONS: Edit this file and the other INIT files it calls for # your site, either by using the values provided here or by providing # your own. Then place an IFILE= line into each instance-specific # INIT file that points at this file. # # NOTE: Parameter values suggested in this file are based onconservative
# for modern machines. # # You may also consider using Database Configuration Assistant tool(DBCA)
# to create INIT file and to size your initial set of tablespaces based # on the user input. ###############################################################################
# replace DEFAULT with your database name db_name=DEFAULT
db_files = 80 # SMALL # db_files = 400 # MEDIUM # db_files = 1500 #LARGE
db_file_multiblock_read_count = 8 # SMALL # db_file_multiblock_read_count = 16 # MEDIUM # db_file_multiblock_read_count = 32 #LARGE db_block_buffers = 100
# db_block_buffers = 550 # MEDIUM # db_block_buffers = 3200 #LARGE
shared_pool_size = 3500000 # SMALL # shared_pool_size = 5000000 # MEDIUM # shared_pool_size = 9000000 #LARGE log_checkpoint_interval = 10000
processes = 50 # SMALL # processes = 100 # MEDIUM # processes = 200 #LARGE
parallel_max_servers = 5 # SMALL # parallel_max_servers = 4 x (number of CPUs) # MEDIUM # parallel_max_servers = 4 x (number of CPUs) #LARGE
log_buffer = 32768 # SMALL # log_buffer = 32768 # MEDIUM # log_buffer = 163840 #LARGE
# audit_trail = true # if you want auditing # timed_statistics = true # if you want timed statistics max_dump_file_size = 10240 # limit trace file size to 5 Meg each
# Uncommenting the line below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG. # log_archive_start = true # log_archive_dest = disk$rdbms:[oracle.archive] # log_archive_format = "T%TS%S.ARC" # If using private rollback segments, place lines of the following# form in each of your instance-specific init.ora files: # rollback_segments = (name1, name2)
# If using public rollback segments, define how many # rollback segments each instance will pick up, using the formula # # of rollback segments = transactions /transactions_per_rollback_segment
# In this example each instance will grab 40/5 = 8: # transactions = 40 # transactions_per_rollback_segment = 5
# Global Naming -- enforce that a dblink has same name as the db it
connects to
global_names = TRUE
# Edit and uncomment the following line to provide the suffix that will
be
# appended to the db_name parameter (separated with a dot) and stored
as the
# global database name when a database is created. If your site uses
# Internet Domain names for e-mail, then the part of your e-mail
address after
# the '@' is a good candidate for this parameter value.
# db_domain = us.acme.com # global database name is db_name.db_domain
# FOR DEVELOPMENT ONLY, ALWAYS TRY TO USE SYSTEM BACKING STORE # vms_sga_use_gblpagfil = TRUE
# FOR BETA RELEASE ONLY. Enable debugging modes. Note that these can
# adversely affect performance. On some non-VMS ports the
db_block_cache_*
# debugging modes have a severe effect on performance.
#_db_block_cache_protect = true # memory protectbuffers
# define parallel server (multi-instance) parameters #ifile = ora_system:initps.ora
# define two control files by default
control_files = (ora_control1, ora_control2)
# Uncomment the following line if you wish to enable the Oracle Trace
product
# to trace server activity. This enables scheduling of server
collections
# from the Oracle Enterprise Manager Console. # Also, if the oracle_trace_collection_name parameter is non-null, # every session will write to the named collection, as well as enablingyou
# oracle_trace_enable = TRUE
# Uncomment the following line, if you want to use some of the new 8.1 # features. Please remember that using them may require some downgrade # actions if you later decide to move back to 8.0.
#compatible = 8.1.0
hosts = local , bind
(0) root @ ebc123: 5.3.0.0:
/usr/app/oracle/OraHome_2/css/log/ocssd0.log
2005-06-27 10:14:54.871 [1] >USER: Oracle Database 10g CSS Release
10.1.0.2.0 Production Copyright 2003 Oracle
2005-06-27 10:14:54.871 [1] >USER: CSS daemon log for node ebc123,
number 0, in cluster localhost
2005-06-27 10:14:54.872 [1] >TRACE: clssscmain: local-only set to
true
2005-06-27 10:14:54.872 [1] >TRACE: clssnmInitNMInfo: misscount set
to 30
2005-06-27 10:14:54.872 [1] >TRACE: clssnmReadNodeInfo: added node 0
(ebc123) to cluster
2005-06-27 10:14:54.873 [1] >TRACE: clssnmQuorumInit: Skipping quorum
init for localonly
2005-06-27 10:14:54.881 [1] >TRACE: clssscFatalInit: recognized
localonly mode
2005-06-27 10:14:54.881 [1] >TRACE: clssNMInitialize: Initializing
with OCR id (1796470417)
2005-06-27 10:14:54.882 [1] >TRACE: clssnm_skgxnonline: Using vacuous
skgxn monitor
2005-06-27 10:14:54.882 [1800] >TRACE: clssnmClusterListener: Spawned
2005-06-27 10:14:54.913 [1800] >TRACE: clsclisten: Error listening
on: (ADDRESS=(PROTOCOL=tcp)(HOST=ebc123)(PORT=0))
2005-06-27 10:14:54.913 [1800] >TRACE: clsclisten: op 78 failed, NSerr (12545, 12560), transport: (515, 79, 0)
2005-06-27 10:14:54.913 [1800] >ERROR: clssnmClusterListener: Listen failed, rc 3
2005-06-27 10:14:54.913 [1800] >WARNING: ClusterListening: Exiting --- End Dump ---
2005-06-27 10:15:57.179 [1] >USER: Oracle Database 10g CSS Release
10.1.0.2.0 Production Copyright 2003 Oracle
2005-06-27 10:15:57.179 [1] >USER: CSS daemon log for node ebc123,
number 0, in cluster localhost
2005-06-27 10:15:57.180 [1] >TRACE: clssscmain: local-only set to
true
2005-06-27 10:15:57.180 [1] >TRACE: clssnmReadNodeInfo: added node 0
(ebc123) to cluster
2005-06-27 10:15:57.188 [1] >TRACE: clssscFatalInit: recognized
localonly mode
2005-06-27 10:15:57.188 [1] >TRACE: clssnm_skgxnonline: Using vacuous
skgxn monitor
2005-06-27 10:15:57.218 [1800] >TRACE: clsclisten: Error listening
on: (ADDRESS=(PROTOCOL=tcp)(HOST=ebc123)(PORT=0))
2005-06-27 10:15:57.218 [1800] >TRACE: clsclisten: op 78 failed, NSerr (12545, 12560), transport: (515, 79, 0)
2005-06-27 10:15:57.218 [1800] >ERROR: clssnmClusterListener: Listen failed, rc 3
2005-06-27 10:15:57.218 [1800] >WARNING: ClusterListening: Exiting
--- DUMP GROCK STATE DB --- --- END OF GROCK STATE DUMP --- --- Begin Dump ---
........ (Note: Several of the same message cut out - Jeff)..............
2005-06-27 10:48:49.379 [1] >USER: Oracle Database 10g CSS Release
10.1.0.2.0 Production Copyright 2003 Oracle
2005-06-27 10:48:49.380 [1] >USER: CSS daemon log for node ebc123,
number 0, in cluster localhost
2005-06-27 10:48:49.380 [1] >TRACE: clssscmain: local-only set to
true
2005-06-27 10:48:49.380 [1] >TRACE: clssnmInitNMInfo: misscount set
to 30
2005-06-27 10:48:49.380 [1] >TRACE: clssnmReadNodeInfo: added node 0
(ebc123) to cluster
2005-06-27 10:48:49.381 [1] >TRACE: clssnmQuorumInit: Skipping quorum
init for localonly
2005-06-27 10:48:49.390 [1] >TRACE: clssscFatalInit: recognized
localonly mode
2005-06-27 10:48:49.390 [1] >TRACE: clssNMInitialize: Initializing
with OCR id (1796470417)
2005-06-27 10:48:49.390 [1] >TRACE: clssnm_skgxnonline: Using vacuous
skgxn monitor
2005-06-27 10:48:49.390 [1800] >TRACE: clssnmClusterListener: Spawned
2005-06-27 10:48:49.429 [1800] >TRACE: clsclisten: Error listening
on: (ADDRESS=(PROTOCOL=tcp)(HOST=ebc123)(PORT=0))
2005-06-27 10:48:49.429 [1800] >TRACE: clsclisten: op 78 failed, NSerr (12545, 12560), transport: (515, 79, 0)
2005-06-27 10:48:49.429 [1800] >ERROR: clssnmClusterListener: Listen failed, rc 3
2005-06-27 10:48:49.430 [1800] >WARNING: ClusterListening: Exiting --- End Dump ---
(0) root @ ebc123: 5.3.0.0: /usr/app/oracle/OraHome_2/css/log # Received on Mon Jun 27 2005 - 11:11:28 CDT