linux下oracle9i创建数据库时出现的问题??
fcu2z 2005-01-12 03:24:29 本人使用的是redhat es2.0操作系统jdk1.4欲安装oracle9.2-数据库。现在我已经参考相关资料将oracle安装完毕,过程顺利。且运行/opt/ora9/product/9.2/bin/agentctl start正常。
下一步我需要创建并使用一个数据库,$dbca 之后,若干个“下一步“输入数据库名称fcu.coom和SID:fcu,开始安装,进行到48%时弹出对话框“read error”,在shell中的显示是:
[oracle@loke root]$ dbca
java.io.IOException: read error
at java.io.FileInputStream.read(FileInputStream.java)
at java.io.InputStreamReader.fill(InputStreamReader.java)
at java.io.InputStreamReader.read(InputStreamReader.java)
at java.io.BufferedReader.fill(BufferedReader.java)
at java.io.BufferedReader.readLine(BufferedReader.java)
at oracle.sysman.assistants.util.OsUtilsUnix.enumerateSIDs(OsUtilsUnix.java:242)
at oracle.sysman.assistants.dbca.ui.DatabaseOperationsPage.reinitialize(DatabaseOperationsPage.java:361)
at oracle.sysman.assistants.dbca.ui.DatabaseOperationsPage.initializePage(DatabaseOperationsPage.java:228)
at oracle.sysman.assistants.util.wizard.WizardPageExt.onSetActive(WizardPageExt.java:93)
at oracle.sysman.assistants.dbca.ui.DatabaseOperationsPage.onSetActive(DatabaseOperationsPage.java:387)
at oracle.sysman.assistants.util.wizard.WizardExt.wizardSelectionChanged(WizardExt.java:165)
at oracle.ewt.wizard.BaseWizard.processWizardEvent(Unknown Source)
at oracle.ewt.wizard.BaseWizard.processEventImpl(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
at oracle.ewt.wizard.BaseWizard.selectPage(Unknown Source)
at oracle.ewt.wizard.BaseWizard.doNext(Unknown Source)
at oracle.sysman.assistants.util.wizard.WizardExt.doNext(WizardExt.java:236)
at oracle.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)
at oracle.ewt.button.PushButton.processActionEvent(Unknown Source)
at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
at oracle.ewt.button.PushButton.activate(Unknown Source)
at oracle.ewt.lwAWT.AbstractButton.processMouseReleased(Unknown Source)
at oracle.ewt.lwAWT.AbstractButton.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Component.java:2203)
at java.awt.Container.processEvent(Container.java:901)
at oracle.ewt.lwAWT.LWComponent.processEventImpl(Unknown Source)
at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Component.java:1812)
at java.awt.Container.dispatchEventImpl(Container.java:946)
at java.awt.Component.dispatchEvent(Component.java:1744)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:1841)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:1630)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:1531)
at java.awt.Container.dispatchEventImpl(Container.java:933)
at java.awt.Window.dispatchEventImpl(Window.java:509)
at java.awt.Component.dispatchEvent(Component.java:1744)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
选择“ok”继续安装,然后输入sys和system的密码:yxcomputer,退出,完毕。
以下是我使用各种命令之后的反应:
[root@loke root]# su oracle
': not a valid identifier
': not a valid identifier
': not a valid identifier
': not a valid identifier
': not a valid identifier
': not a valid identifier
': not a valid identifier
': not a valid identifier
': not a valid identifier
': not a valid identifier
[oracle@loke root]$ sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Nov 25 07:33:05 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys
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:
ERROR:
ORA-01017: invalid username/password; 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
[oracle@loke root]$ echo $ORACLE_SID
ora9i
[oracle@loke root]$ ps -ef | grep ora
oracle 4541 4540 0 07:32 pts/0 00:00:00 bash
oracle 4580 4541 0 07:36 pts/0 00:00:00 ps -ef
oracle 4581 4541 0 07:36 pts/0 00:00:00 grep ora
[oracle@loke root]$ ps -ef |grep ora
oracle 4541 4540 0 07:32 pts/0 00:00:00 bash
oracle 4582 4541 0 07:36 pts/0 00:00:00 ps -ef
oracle 4583 4541 0 07:36 pts/0 00:00:00 grep ora
[oracle@loke root]$ sqlplus internal
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Nov 25 07:36:55 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-09275: CONNECT INTERNAL is not a valid DBA connection
Enter user-name:
ERROR:
ORA-01017: invalid username/password; 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
[oracle@loke root]$ sqlplus internal
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Nov 25 07:37:21 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-09275: CONNECT INTERNAL is not a valid DBA connection
Enter user-name:
ERROR:
ORA-01017: invalid username/password; 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
[oracle@loke root]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Nov 25 07:38:45 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect internal/oracle
ERROR:
ORA-09275: CONNECT INTERNAL is not a valid DBA connection
SQL> startup
SP2-0042: unknown command "setup" - rest of line ignored.
SQL> conn sys /as sysdba
Enter password:
Connected to an idle instance.
SQL> connect
Enter user-name: system/yxcomputer@fcu
ERROR:
ORA-12541: TNS:no listener
Warning: You are no longer connected to ORACLE.
SQL> connect
Enter user-name: sys
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL>