登 录
留作记录
OLDPWD=/home/oracle<br /> [oracle@localhost dbs]$ sqlplus /nolog<br /> SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 29 14:16:25 2011<br /> Copyright (c) 1982, 2009, Oracle. All rights reserved.<br /> SQL> conn sys as sysdba<br /> Enter password:<br /> Connected to an idle instance.<br /> SQL> startup<br /> ORA-09925: Unable to create audit trail file<br /> Linux Error: 2: No such file or directory<br /> Additional information: 9925<br /> SQL> exit<br /> Disconnected<br /> [oracle@localhost dbs]$ vim initorcl.ora<br /> [No write since last change]<br /> Press ENTER or type command to continue<br /> [oracle@localhost dbs]$ exit<br /> logout<br /> [root@localhost ~]# shutdown -r now<br /> Broadcast message from root@localhost.localdomain<br /> (/dev/pts/0) at 14:28 ...<br /> The system is going down for reboot NOW!<br /> [root@localhost ~]#<br /> login as: root<br /> root@59.64.179.60's password:<br /> Last login: Tue Mar 29 13:37:57 2011 from 59.64.179.36<br /> [root@localhost ~]# su - oracle<br /> [oracle@localhost ~]$ sqlplus /nolog<br /> SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 29 14:33:46 2011<br /> Copyright (c) 1982, 2009, Oracle. All rights reserved.<br /> SQL> conn sys as sysdba<br /> Enter password:<br /> Connected to an idle instance.<br /> SQL> startup<br /> ORA-09925: Unable to create audit trail file<br /> Linux Error: 2: No such file or directory<br /> Additional information: 9925<br /> SQL> startup nomount<br /> ORA-09925: Unable to create audit trail file<br /> Linux Error: 2: No such file or directory<br /> Additional information: 9925<br /> ORA-01017: invalid username/password; logon denied<br /> SQL> conn wenlele/wenlele@mydb<br /> ERROR:<br /> ORA-12541: TNS:no listener<br /> Warning: You are no longer connected to ORACLE.<br /> SQL> exit<br /> [oracle@localhost ~]$ exit<br /> logout<br /> [root@localhost ~]# /etc/init.d/iptables stop<br /> iptables: Flushing firewall rules: [ OK ]<br /> iptables: Setting chains to policy ACCEPT: filter [ OK ]<br /> iptables: Unloading modules: [ OK ]<br /> [root@localhost ~]# lsnrctl start<br /> -bash: lsnrctl: command not found<br /> [root@localhost ~]# lsnrctl<br /> -bash: lsnrctl: command not found<br /> [root@localhost ~]# lsnrctl<br /> -bash: lsnrctl: command not found<br /> [root@localhost ~]# su - oracle<br /> [oracle@localhost ~]$ lsnrctl<br /> LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-MAR-2011 14:36:55<br /> Copyright (c) 1991, 2009, Oracle. All rights reserved.<br /> Welcome to LSNRCTL, type "help" for information.<br /> LSNRCTL> start<br /> Starting /myoracle/app/product/11.2/db_1/bin/tnslsnr: please wait...<br /> TNSLSNR for Linux: Version 11.2.0.1.0 - Production<br /> System parameter file is /myoracle/app/product/11.2/db_1/network/admin/listener.ora<br /> Log messages written to /myoracle/app/diag/tnslsnr/localhost/listener/alert/log.xml<br /> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))<br /> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))<br /> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))<br /> STATUS of the LISTENER<br /> ------------------------<br /> Alias LISTENER<br /> Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production<br /> Start Date 29-MAR-2011 14:36:59<br /> Uptime 0 days 0 hr. 0 min. 0 sec<br /> Trace Level off<br /> Security ON: Local OS Authentication<br /> SNMP OFF<br /> Listener Parameter File /myoracle/app/product/11.2/db_1/network/admin/listener.ora<br /> Listener Log File /myoracle/app/diag/tnslsnr/localhost/listener/alert/log.xml<br /> Listening Endpoints Summary...<br /> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))<br /> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))<br /> Services Summary...<br /> Service "mydb" has 1 instance(s).<br /> Instance "mydb", status UNKNOWN, has 1 handler(s) for this service...<br /> The command completed successfully<br /> LSNRCTL> status<br /> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))<br /> STATUS of the LISTENER<br /> ------------------------<br /> Alias LISTENER<br /> Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production<br /> Start Date 29-MAR-2011 14:36:59<br /> Uptime 0 days 0 hr. 0 min. 3 sec<br /> Trace Level off<br /> Security ON: Local OS Authentication<br /> SNMP OFF<br /> Listener Parameter File /myoracle/app/product/11.2/db_1/network/admin/listener.ora<br /> Listener Log File /myoracle/app/diag/tnslsnr/localhost/listener/alert/log.xml<br /> Listening Endpoints Summary...<br /> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))<br /> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))<br /> Services Summary...<br /> Service "mydb" has 1 instance(s).<br /> Instance "mydb", status UNKNOWN, has 1 handler(s) for this service...<br /> The command completed successfully<br /> LSNRCTL> exit<br /> [oracle@localhost ~]$ sqlplus wenlele/wenlele@mydb<br /> SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 29 14:37:38 2011<br /> Copyright (c) 1982, 2009, Oracle. All rights reserved.<br /> ERROR:<br /> ORA-01034: ORACLE not available<br /> ORA-27101: shared memory realm does not exist<br /> Linux Error: 2: No such file or directory<br /> Process ID: 0<br /> Session ID: 0 Serial number: 0<br /> Enter user-name: sys@mydb<br /> Enter password:<br /> ERROR:<br /> ORA-01034: ORACLE not available<br /> ORA-27101: shared memory realm does not exist<br /> Linux Error: 2: No such file or directory<br /> Process ID: 0<br /> Session ID: 0 Serial number: 0<br /> Enter user-name: sys@mydb as sysdba<br /> Enter password:<br /> Connected to an idle instance.<br /> SQL> STARTUP NOMOUNT<br /> ORACLE instance started.<br /> Total System Global Area 418484224 bytes<br /> Fixed Size 1336932 bytes<br /> Variable Size 318769564 bytes<br /> Database Buffers 92274688 bytes<br /> Redo Buffers 6103040 bytes<br /> SQL> STARTUP MOUNT<br /> ORA-01081: cannot start already-running ORACLE - shut it down first<br /> SQL> ALTER DATABASE MOUNT<br /> 2 ;<br /> Database altered.<br /> SQL> --HELP<br /> SQL> ;<br /> 1 ALTER DATABASE MOUNT<br /> 2*<br /> SQL> ? index<br /> SP2-0171: HELP system not available.<br /> SQL> conn wenlele/wenlele@mydb<br /> ERROR:<br /> ORA-01033: ORACLE initialization or shutdown in progress<br /> Process ID: 0<br /> Session ID: 0 Serial number: 0<br /> Warning: You are no longer connected to ORACLE.<br /> SQL> shutdown immediate<br /> ORA-03135: connection lost contact<br /> SQL> startup<br /> ORA-24324: service handle not initialized<br /> ORA-01041: internal error. hostdef extension doesn't exist<br /> SQL> conn sys/sys@mydb as sysdba<br /> ERROR:<br /> ORA-01017: invalid username/password; logon denied<br /> SQL> conn sys/Telestar2010@mydb as sysdba<br /> Connected.<br /> SQL> shutdown immediate<br /> ORA-01109: database not open<br /> Database dismounted.<br /> ORACLE instance shut down.<br /> SQL> startup<br /> ORACLE instance started.<br /> Total System Global Area 418484224 bytes<br /> Fixed Size 1336932 bytes<br /> Variable Size 318769564 bytes<br /> Database Buffers 92274688 bytes<br /> Redo Buffers 6103040 bytes<br /> Database mounted.<br /> Database opened.<br /> SQL> conn wenlele/wenlele@mydb<br /> Connected.<br /> SQL>
抱歉!评论已关闭.