oracle 10g init.ora, listener.ora, tnsnames.ora sample

AIX 140 sample
********************************************************************************
db_name=Ora10g
db_files = 80
db_file_multiblock_read_count = 8
db_block_buffers = 100
shared_pool_size = 402653184
undo_management=AUTO
undo_tablespace=UNDOTBS1
remote_login_passwordfile=exclusive
db_block_size=8192
#db_cache_size=32M
__db_cache_size=2013265920
__java_pool_size=16777216
__large_pool_size=16777216
log_checkpoint_interval = 10000
processes = 150
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240
global_names = TRUE
# db_domain = us.acme.com       # global database name is db_name.db_domain
# define two control files by default
control_files = (/safedb1/oracle/oradata/Ora10g/data1/control01.ctl,
                 /safedb1/oracle/oradata/Ora10g/data2/control02.ctl)
query_rewrite_enabled='TRUE'
query_rewrite_integrity='TRUSTED'
#sga_target=2464153600
pga_aggregate_target=821035008
job_queue_processes=10
db_block_size=8192
# 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
********************************************************************************



pre-installed - oracle 10g but......... XDB????????? (if express?)
********************************************************************************
Ora10g.__db_cache_size=2013265920
Ora10g.__java_pool_size=16777216
Ora10g.__large_pool_size=16777216
Ora10g.__shared_pool_size=402653184
Ora10g.__streams_pool_size=0
*.audit_file_dest='/oracle/SAFEDB/admin/Ora10g/adump'
*.background_dump_dest='/oracle/SAFEDB/admin/Ora10g/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/oracle/SAFEDB/oradata/Ora10g/control01.ctl','/oracle/SAFEDB/oradata/Ora10g/control02.ctl','/oracle/SAF
EDB/oradata/Ora10g/control03.ctl'
*.core_dump_dest='/oracle/SAFEDB/admin/Ora10g/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='Ora10g'
*.db_recovery_file_dest='/oracle/SAFEDB/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=Ora10gXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=821035008
*.processes=150
*.query_rewrite_enabled='TRUE'
*.query_rewrite_integrity='TRUSTED'
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=2464153600
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/SAFEDB/admin/Ora10g/udump'
********************************************************************************


Total System Global Area  465567744 bytes
Fixed Size                  2021448 bytes
Variable Size             427820984 bytes
Database Buffers           33554432 bytes
Redo Buffers                2170880 bytes
Database mounted.
Database opened.

























listener.ora
***************************************************
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /safedb1/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = Ora10g)
      (ORACLE_HOME = /safedb1/oracle/product/10.2.0/db_1)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = janus)(PORT = 1521))
    )
  )
**********************************************************************




tnsnames.ora
**********************************************************************
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = janus)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PLSExtProc)
    )
  )
ORA10G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = janus)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = Ora10g)
    )
  )
**********************************************************************