| oracle not available [message #62547] |
Wed, 28 July 2004 05:37  |
MOhammad Tina
Messages: 4
Registered: July 2004
|
Junior Member |
|
|
Hi,
i am trying to connect to my DB through listener, i am using JDBC, when i try to do that i got the following error
oracle not available.
i am using oracle 8i
i was checking online documentation, they said that only init.ora file not initsid.ora
i foung in my server init.ora and initsid.ora
which one is running and how i can solve my error
my sid=asy_db
below is copy of listener.ora, tnsnames.ora, init.ora, initASY_DB.ora
thanks
listener.ora file
==========================================
#
# Installation Generated Net8 Configuration
# Version Date: Jun-17-97
# Filename: Listener.ora
#
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= ASY_DB))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= asycuda)(Port= 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= asycuda.asycuda)
(ORACLE_HOME= /home/oracle)
(SID_NAME = <oracle_sid>)
)
(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /home/oracle)
(PROGRAM = extproc)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
===========================================
tnsnames.ora
============================================
#
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#
extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = <oracle_sid>))
(CONNECT_DATA = (SID = extproc))
)
asy_db =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= asycuda)(Port= 1521))
(CONNECT_DATA = (SID = asy_db ))
)
<oracle_sid> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= asycuda)(Port= 1521))
(CONNECT_DATA = (SID = <oracle_sid>))
)
<oracle_sid>_BEQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /home/oracle)
(argv0 = oracle<oracle_sid>)
(args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
(envs = 'ORACLE_HOME=/home/oracle,ORACLE_SID=<oracle_sid>')
)
)
===============================================
init.ora
===============================================
#
# $Header: initx.orc 1.1 95/02/27 12:14:56 wyim Osd<unix> $ Copyr (c) 1992 Oracle
#
# include database configuration parameters
control_files = (/home/hq/rdbms/HQ_DB/ctrl1HQ_DB.ctl,
/home/hq/rdbms/HQ_DB/ctrl2HQ_DB.ctl,
/home/hq/rdbms/HQ_DB/ctrl3HQ_DB.ctl)
background_dump_dest = /home/oracle/rdbms/log
core_dump_dest = /home/oracle/dbs
user_dump_dest = /home/oracle/rdbms/log
#log_archive_dest = /home/oracle/dbs/arch/arch.log
db_block_size = 2048
db_name = HQ_DB
rollback_segments = (r01,r02,r03,r04)
# tuning parameters
os_authent_prefix = "ops$"
db_files = 40
db_file_multiblock_read_count = 8
db_block_buffers = 200
shared_pool_size = 8000000
log_checkpoint_interval = 10000
processes = 200
dml_locks = 100
log_buffer = 8192
open_cursors = 500
sequence_cache_entries = 10
sequence_cache_hash_buckets = 10
# 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
# log_archive_start = true # if you want automatic archiving
#compatible = 7.2.2.4
# global_names = TRUE
# Do not use below settings its Multithreaded Server....
#
# mts_dispatchers="ipc,1"
# mts_max_dispatchers=10
# mts_servers=1
# mts_max_servers=10
# mts_service=ASY_DB
# mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=ASY_DB))"
nls_date_format = YYYYMMDD
===========================================
initasy_db.ora
===============================================
#
# $Header: initx.orc 1.1 95/02/27 12:14:56 wyim Osd<unix> $ Copyr (c) 1992 Oracle
#
# include database configuration parameters
control_files = (/home/asy/rdbms/ASY_DB/ctrl1ASY_DB.ctl,
/home/asy/rdbms/ASY_DB/ctrl2ASY_DB.ctl,
/home/asy/rdbms/ASY_DB/ctrl3ASY_DB.ctl)
background_dump_dest = /home/oracle/rdbms/log
core_dump_dest = /home/oracle/dbs
user_dump_dest = /home/oracle/rdbms/log
#log_archive_dest = /home/oracle/dbs/arch/arch.log
db_block_size = 2048
db_name = ASY_DB
rollback_segments = (r01,r02,r03,r04)
# tuning parameters
os_authent_prefix = "ops$"
db_files = 40
db_file_multiblock_read_count = 8
db_block_buffers = 200
shared_pool_size = 8000000
log_checkpoint_interval = 10000
processes = 200
dml_locks = 100
log_buffer = 8192
open_cursors = 500
sequence_cache_entries = 10
sequence_cache_hash_buckets = 10
# 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
# log_archive_start = true # if you want automatic archiving
#compatible = 7.2.2.4
# global_names = TRUE
# Do not use below settings its Multithreaded Server....
#
# mts_dispatchers="ipc,1"
# mts_max_dispatchers=10
# mts_servers=1
# mts_max_servers=10
# mts_service=ASY_DB
# mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=ASY_DB))"
nls_date_format = YYYYMMDD
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: oracle not available [message #62581 is a reply to message #62567] |
Fri, 30 July 2004 06:26  |
MOhammad Tina
Messages: 4
Registered: July 2004
|
Junior Member |
|
|
Hi,
there was a mistake in the listener file
GLOBAL_DBNAME= asycuda.asycuda
i changed it to GLOBAL_DBNAME= asycuda
since this what i have in the host file
192.168.2.13 asycuda asycuda
tnsping working fine
tnsping asy_db is working ...i shtudown the DB and restart it, still i have oracle not availabe error.
untried to uncomment the following parameters in the both initsid.ora and init.ora files but no luck
# Do not use below settings its Multithreaded
# mts_service=ASY_DB
# mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=ASY_DB))"
also i looked to listener.log, i can see that there connection established
30-JUL-04 16:59:56 * (CONNECT_DATA=(SID=asy_db)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=1
92.168.2.70)(PORT=3069)) * establish * asy_db * 0
below is the output of status and service in listener
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> service
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ASY_DB))
Services Summary...
asy_db has 1 service handler(s)
DEDICATED SERVER established:8 refused:0
LOCAL SERVER
extproc has 1 service handler(s)
DEDICATED SERVER established:2 refused:0
LOCAL SERVER
The command completed successfully
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ASY_DB))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Intel SVR4 UNIX: Version 8.0.5.0.0 - Production
Start Date 30-JUL-04 15:48:05
Uptime 0 days 1 hr. 36 min. 23 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /home/oracle/network/admin/listener.ora
Listener Log File /home/oracle/network/log/listener.log
Services Summary...
asy_db has 1 service handler(s)
extproc has 1 service handler(s)
The command completed successfully
thanks
|
|
|
|
| Re: oracle not available [message #62582 is a reply to message #62581] |
Fri, 30 July 2004 09:35 |
Harish Shanbhag
Messages: 19
Registered: July 2004
|
Junior Member |
|
|
dont chk init.ora
open tnsnames.ora(admin foldr)
the prolem lies i feel inthe keyword server and the value dedicated may be missing
add the following
SERVER = DEDICATED
i.e
(CONNECT_DATA =
(SID = tina_meow)
(SERVER = DEDICATED)
)
i hope this helps
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
