- 论坛徽章:
- 0
|
[oracle@hlinfo ora9i]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Feb 4 14:39:17 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>; conn / as sysdba
Connected to an idle instance.
SQL>; startup migrate
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/ora9/product/9.2/dbs/initora9i.or a'
SQL>; startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/ora9/product/9.2/dbs/initora9i.or a'
SQL>; startup oraenv
SP2-0714: invalid combination of STARTUP options
SQL>; spool /tmp/patchlog
SQL>; @$ORACLE_HOME/rdbms/admin/catpatch.sql
DOC>; BEGIN CATPATCH.SQL */
DECLARE
*
ERROR at line 1:
ORA-01034: ORACLE not available
Disconnected
[oracle@hlinfo ora9i]$ lsnrctl start
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 04-FEB-2005 14:42:22
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /opt/ora9/product/9.2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Log messages written to /opt/ora9/product/9.2/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
Listener failed to start. See the error message(s) above...
下面是安装的参考资料.ii. 更新数据库,按照下列顺序执行sql脚本
$sqlplus /nolog
Sql>;conn / as sysdba
Sql>;startup migrate
Sql>;spool /tmp/patchlog
Sql>;@$ORACLE_HOME/rdbms/admin/catpatch.sql
Sql>;spool off
Sql>;shutdown
Sql>;startup
Sql>;spool /tmp/rp.log
Sql>; @$ORACLE_HOME/rdbms/admin/utlrp.sql
Sql>;spool off
Sql>;shutdown
Sql>;startup
Sql>;exit
iii. 启动监听器:$lsnrctl start
iv. 客户端可以正常使用Oracle |
|