查看状态时出现下面提示:
oracle@localhost oracle]$ lsnrctlLSNRCTL for Linux: Version 9.0.1.0.0 - Production on 20-AUG-2004 15:59:20Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL>
oracle@localhost oracle]$ lsnrctlLSNRCTL for Linux: Version 9.0.1.0.0 - Production on 20-AUG-2004 15:59:20Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL>
重新配置监听器,重新配置服务名
----------------------------------------
具体步骤如何?谢谢!
D:\oracle\ora92\BIN\TNSLSNR 下启动服务!!
-----------------------------
Thu Aug 19 11:25:38 2004
WARNING: EINVAL creating segment of size 0x0000000015083000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 9.0.1.0.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size = 1048576
java_pool_size = 117440512
resource_manager_plan = SYSTEM_PLAN
control_files = /opt/oracle/oradata/Ora9i/control01.ctl, /opt/oracle/oradata/Ora9i/control02.ctl, /opt/oracle/oradata/Ora9i/control03.ctl
db_block_size = 8192
db_cache_size = 67108864
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = myOra
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = /opt/oracle/admin/Ora9i/bdump
user_dump_dest = /opt/oracle/admin/Ora9i/udump
core_dump_dest = /opt/oracle/admin/Ora9i/cdump
sort_area_size = 524288
db_name = Ora9i
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Thu Aug 19 11:25:39 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Aug 19 11:25:40 2004
ALTER DATABASE MOUNT
Thu Aug 19 11:25:47 2004
Successful mount of redo thread 1, with mount id 3445661814.
Thu Aug 19 11:25:47 2004
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Aug 19 11:25:47 2004
ALTER DATABASE OPEN
Thu Aug 19 11:25:47 2004
Beginning crash recovery of 1 threads
Thu Aug 19 11:25:47 2004
Started first pass scan
Thu Aug 19 11:25:47 2004
Completed first pass scan
Thu Aug 19 11:25:47 2004
Started recovery at
Thread 1: logseq 19, block 572, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 19 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/Ora9i/redo03.log
Thu Aug 19 11:25:48 2004
Ended recovery at
Thread 1: logseq 19, block 590, scn 0.605209
12 data blocks read, 12 data blocks written, 18 redo blocks read
Crash recovery completed successfully
Thu Aug 19 11:25:48 2004
Thread 1 advanced to log sequence 20
Thread 1 opened at log sequence 20
Current log# 1 seq# 20 mem# 0: /opt/oracle/oradata/Ora9i/redo01.log
Successful open of redo thread 1.
Thu Aug 19 11:25:49 2004
SMON: enabling cache recovery
Thu Aug 19 11:25:49 2004
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Aug 19 11:25:49 2004
SMON: enabling tx recovery
Thu Aug 19 11:25:52 2004
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
下面应该是正常启动的
------------------------------------------------------------
Thu Jul 22 17:21:18 2004
Starting ORACLE instance (normal)
Thu Jul 22 17:21:18 2004
WARNING: EINVAL creating segment of size 0x0000000015083000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 9.0.1.0.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size = 1048576
java_pool_size = 117440512
resource_manager_plan = SYSTEM_PLAN
control_files = /opt/oracle/oradata/Ora9i/control01.ctl, /opt/oracle/oradata/Ora9i/control02.ctl, /opt/oracle/oradata/Ora9i/control03.ctl
db_block_size = 8192
db_cache_size = 67108864
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = myOra
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = /opt/oracle/admin/Ora9i/bdump
user_dump_dest = /opt/oracle/admin/Ora9i/udump
core_dump_dest = /opt/oracle/admin/Ora9i/cdump
sort_area_size = 524288
db_name = Ora9i
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Thu Jul 22 17:21:20 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jul 22 17:21:20 2004
Create controlfile reuse set database Ora9i
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
Datafile
'/opt/oracle/product/9i/oradata/Ora9i/cwmlite01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/drsys01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/example01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/indx01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/system01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/tools01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/undotbs01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/users01.dbf'
LOGFILE GROUP 1 ('/opt/oracle/oradata/Ora9i/redo01.log') SIZE 102400K,
GROUP 2 ('/opt/oracle/oradata/Ora9i/redo02.log') SIZE 102400K,
GROUP 3 ('/opt/oracle/oradata/Ora9i/redo03.log') SIZE 102400K RESETLOGS
Thu Jul 22 17:21:25 2004
Successful mount of redo thread 1, with mount id 3443240915.
Thu Jul 22 17:21:25 2004
Completed: Create controlfile reuse set database Ora9i
MAX
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water = 1
Thu Jul 22 17:21:26 2004
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Thu Jul 22 17:21:26 2004
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
Thu Jul 22 17:21:31 2004
Starting ORACLE instance (normal)