ORACLE9i在RH Linux安装完成后,启动数据库及服务失败.

ronk

各位版主,高人,大家好!
     首先感谢论坛上关于如何在linux上安装oracle9的文章,这不仅使我的安装过程得到了一定的帮助,更重要的是让我学到了不少有关linux的知识.我坦白,由于工作分工的原因,我只接触oracle和linux不到7天的时间,因此有很多很基础的知识都还掌握不全,全凭在安装过程中的反复试验.
     经过N次重装系统和2N次重装数据库,目前我的oracle数据库安装基本完成.
     但在安装后,启动的过程中,却出现了两个不同的错误!!!!
     相关操作和系统提示如下,还请各位老师多多指教,先谢谢了~~~

1.安装完成后,欲启动数据库和服务
[oracle@zdgd oracle]$ sqlplus
SQL*Plus: Release 9.2.0.4.0 - Production on Mon Feb 20 17:50:50 2006 Copyright (c) 1982, 2002, Oracle Corporation.
All rights reserved.
Enter user-name: system
Enter password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production
SQL> startup
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production
[oracle@zdgd oracle]$ lsnrctl start
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 20-FEB-2006 17:55:03 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 System parameter file is /opt/ora9/product/9.2/network/admin/listener.ora Log messages written to /opt/ora9/product/9.2/network/log/listener.log Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
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...

-------------------------------------------------------------------------------------------------

2.我对1.中描述的错误毫无办法,因此重新启动系统....却发现重新启动后,不管是以任何方式以oracle用户登陆终端,输入sqlplus后,系统总是提示我用户名和密码不正确......哭啊.具体错误提示请如下:
后输入:sqlplus后,系统总是提示我的用户名和密码不正确,并返回以下的错误信息:

ERROR:
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
Linux Error:2:No such file or directory


以上问题,还请各位老师,高人多多指点,小弟先谢谢了~~~

danfo

第一个错误其实不是错误,仔细看看出错信息,你运行lsnrctl start ,它告诉你Address already in use ,有两种可能,一种是你已经启动了lsnrctl 了,因此再次启动时会报告说端口被占用,另外一种可能是这个端口被其它程序占用,这需要你找到这个进程,杀死之,然后再运行lsnrctl  start命令.oracle好像默认监听的是1521端口,你nmap localhost 一下,看看哪个程序占用了该端口

登陆不上?试试输入sys/sys的密码 as sysdba试试,sys的密码就是你安装oracle时它提示你更改的默认密码,如果你没更改好像默认的密码是change??????来着. 如果还不行,就用connect as internal 试试,命令记得不太清楚,需要你去查找一下

Post by ronk
各位版主,高人,大家好!
     首先感谢论坛上关于如何在linux上安装oracle9的文章,这不仅使我的安装过程得到了一定的帮助,更重要的是让我学到了不少有关linux的知识.我坦白,由于工作分工的原因,我只接触oracle和linux不到7天的时间,因此有很多很基础的知识都还掌握不全,全凭在安装过程中的反复试验.
     经过N次重装系统和2N次重装数据库,目前我的oracle数据库安装基本完成.
     但在安装后,启动的过程中,却出现了两个不同的错误!!!!
     相关操作和系统提示如下,还请各位老师多多指教,先谢谢了~~~

1.安装完成后,欲启动数据库和服务
[oracle@zdgd oracle]$ sqlplus
SQL*Plus: Release 9.2.0.4.0 - Production on Mon Feb 20 17:50:50 2006 Copyright (c) 1982, 2002, Oracle Corporation.
All rights reserved.
Enter user-name: system
Enter password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production
SQL> startup
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production
[oracle@zdgd oracle]$ lsnrctl start
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 20-FEB-2006 17:55:03 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 System parameter file is /opt/ora9/product/9.2/network/admin/listener.ora Log messages written to /opt/ora9/product/9.2/network/log/listener.log Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
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...

-------------------------------------------------------------------------------------------------

2.我对1.中描述的错误毫无办法,因此重新启动系统....却发现重新启动后,不管是以任何方式以oracle用户登陆终端,输入sqlplus后,系统总是提示我用户名和密码不正确......哭啊.具体错误提示请如下:
后输入:sqlplus后,系统总是提示我的用户名和密码不正确,并返回以下的错误信息:

ERROR:
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
Linux Error:2:No such file or directory


以上问题,还请各位老师,高人多多指点,小弟先谢谢了~~~

ronk

回楼上朋友的话,我的用户名和密码都没输错,但是始终反应说：
ERROR:
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
Linux Error:2:No such file or directory
让我重新输入用户名和密码，不知点解？？？？

dancingpig

你的lsnrctl起来了，你的oracle没起来
所以连进去说错误
你oracle几啊
用这个命令起下44
sqlplus /nolog
conn / as sysdba;
startup nomount;这里如果有错误就贴出来不要继续下去了
alter database mount;如果上面那条命令没问题就看这里如果有错误贴出错误
alter database open;如果上面的没问题，这里有问题再贴这里错误
到这里数据库开了。。。

dancingpig

Post by danfo
第一个错误其实不是错误,仔细看看出错信息,你运行lsnrctl start ,它告诉你Address already in use ,有两种可能,一种是你已经启动了lsnrctl 了,因此再次启动时会报告说端口被占用,另外一种可能是这个端口被其它程序占用,这需要你找到这个进程,杀死之,然后再运行lsnrctl  start命令.oracle好像默认监听的是1521端口,你nmap localhost 一下,看看哪个程序占用了该端口

登陆不上?试试输入sys/sys的密码 as sysdba试试,sys的密码就是你安装oracle时它提示你更改的默认密码,如果你没更改好像默认的密码是change??????来着. 如果还不行,就用connect as internal 试试,命令记得不太清楚,需要你去查找一下

9i里好象已经不可以connnect internal了吧

ronk

Post by dancingpig
你的lsnrctl起来了，你的oracle没起来
所以连进去说错误
你oracle几啊
用这个命令起下44
sqlplus /nolog
conn / as sysdba;
startup nomount;这里如果有错误就贴出来不要继续下去了
alter database mount;如果上面那条命令没问题就看这里如果有错误贴出错误
alter database open;如果上面的没问题，这里有问题再贴这里错误
到这里数据库开了。。。

谢谢这位朋友，我试试看。。。。另外说一下，我的oracle是9。2。0。4版本的~~~

dancingpig

最后个4只是补丁号而已，很多东西从7，8到9基本没大变过

ronk

sqlplus /nolog
conn / as sysdba;
startup nomount;
alter database mount;
alter database open;

我用了上面这几条指令后,数据库及服务的确启动成功了,但是现在仍有几个小问题不知所以:
1.
exit退出sqlplus后,输入:sqlplus
用system 用户登陆后,发现无论是shutdown还是startup指令都有提示错误.

2.
重新启动后,再次以oracle用户登陆,在终端中输入sqlplus
用system用户无法登陆,系统要求我重新输入用户名和密码......

3.
同事反映好像不能建表....(尚未确认)....

ronk

------------------------------------------------------------重新启动后引起的血案....
[oracle@zdgd oracle]$ sqlplus

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Feb 22 11:03:54 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory


Enter user-name: sqlplus
Enter password:
ERROR:
ORA-01005: null password given; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

------------------------------没办法登陆上SQLPLUS,只好继续按照楼上朋友的方法进入

[oracle@zdgd oracle]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Feb 22 11:05:15 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn system as SYSDBA
Enter password:
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

----------------------------------------------------------启动服务

[oracle@zdgd oracle]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 22-FEB-2006 11:08:05

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
System parameter file is /opt/ora9/product/9.2/network/admin/listener.ora
Log messages written to /opt/ora9/product/9.2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zdgd)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                22-FEB-2006 11:08:05
Uptime                    0 days 0 hr. 0 min. 1 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /opt/ora9/product/9.2/network/admin/listener.ora
Listener Log File         /opt/ora9/product/9.2/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zdgd)(PORT=1521)))
Services Summary...
Service "LSExtProc" has 1 instance(s).
  Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ora9i" has 1 instance(s).
  Instance "ora9i", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@zdgd oracle]$


---------------------------------------------------------------------以正常的方式登陆SQLPLUS

[oracle@zdgd oracle]$ sqlplus

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Feb 22 11:09:04 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: system
Enter password:

--------------------------(阿米托佛,还好米不让我登陆)

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> shutdown;
ORA-01031: insufficient privileges
SQL> startup nomount;
ORA-01031: insufficient privileges
SQL>

--------------------------(不能启动,不准关闭,这个system用户也恁了点吧...55555)

还好,试了一下,发现能建表...(其他的就没怎么试过了....)......

ronk

no man come ???