[记录] sqlplus命令过程

来源：互联网发布：淘宝查号信誉编辑：程序博客网时间：2024/06/06 00:58

留作记录

OLDPWD=/home/oracle[oracle@localhost dbs]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 29 14:16:25 2011Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn sys as sysdbaEnter password:Connected to an idle instance.SQL> startupORA-09925: Unable to create audit trail fileLinux Error: 2: No such file or directoryAdditional information: 9925SQL> exitDisconnected[oracle@localhost dbs]$ vim initorcl.ora[No write since last change]Press ENTER or type command to continue[oracle@localhost dbs]$ exitlogout[root@localhost ~]# shutdown -r nowBroadcast message from root@localhost.localdomain (/dev/pts/0) at 14:28 ...The system is going down for reboot NOW![root@localhost ~]#login as: rootroot@59.64.179.60's password:Last login: Tue Mar 29 13:37:57 2011 from 59.64.179.36[root@localhost ~]# su - oracle[oracle@localhost ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 29 14:33:46 2011Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn sys as sysdbaEnter password:Connected to an idle instance.SQL> startupORA-09925: Unable to create audit trail fileLinux Error: 2: No such file or directoryAdditional information: 9925SQL> startup nomountORA-09925: Unable to create audit trail fileLinux Error: 2: No such file or directoryAdditional information: 9925ORA-01017: invalid username/password; logon deniedSQL> conn wenlele/wenlele@mydbERROR:ORA-12541: TNS:no listenerWarning: You are no longer connected to ORACLE.SQL> exit[oracle@localhost ~]$ exitlogout[root@localhost ~]# /etc/init.d/iptables stopiptables: Flushing firewall rules: [ OK ]iptables: Setting chains to policy ACCEPT: filter [ OK ]iptables: Unloading modules: [ OK ][root@localhost ~]# lsnrctl start-bash: lsnrctl: command not found[root@localhost ~]# lsnrctl-bash: lsnrctl: command not found[root@localhost ~]# lsnrctl-bash: lsnrctl: command not found[root@localhost ~]# su - oracle[oracle@localhost ~]$ lsnrctlLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-MAR-2011 14:36:55Copyright (c) 1991, 2009, Oracle. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> startStarting /myoracle/app/product/11.2/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionSystem parameter file is /myoracle/app/product/11.2/db_1/network/admin/listener.oraLog messages written to /myoracle/app/diag/tnslsnr/localhost/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 29-MAR-2011 14:36:59Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /myoracle/app/product/11.2/db_1/network/admin/listener.oraListener Log File /myoracle/app/diag/tnslsnr/localhost/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))Services Summary...Service "mydb" has 1 instance(s). Instance "mydb", status UNKNOWN, has 1 handler(s) for this service...The command completed successfullyLSNRCTL> statusConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 29-MAR-2011 14:36:59Uptime 0 days 0 hr. 0 min. 3 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /myoracle/app/product/11.2/db_1/network/admin/listener.oraListener Log File /myoracle/app/diag/tnslsnr/localhost/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))Services Summary...Service "mydb" has 1 instance(s). Instance "mydb", status UNKNOWN, has 1 handler(s) for this service...The command completed successfullyLSNRCTL> exit[oracle@localhost ~]$ sqlplus wenlele/wenlele@mydbSQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 29 14:37:38 2011Copyright (c) 1982, 2009, Oracle. All rights reserved.ERROR:ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux Error: 2: No such file or directoryProcess ID: 0Session ID: 0 Serial number: 0Enter user-name: sys@mydbEnter password:ERROR:ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux Error: 2: No such file or directoryProcess ID: 0Session ID: 0 Serial number: 0Enter user-name: sys@mydb as sysdbaEnter password:Connected to an idle instance.SQL> STARTUP NOMOUNTORACLE instance started.Total System Global Area 418484224 bytesFixed Size 1336932 bytesVariable Size 318769564 bytesDatabase Buffers 92274688 bytesRedo Buffers 6103040 bytesSQL> STARTUP MOUNTORA-01081: cannot start already-running ORACLE - shut it down firstSQL> ALTER DATABASE MOUNT 2 ;Database altered.SQL> --HELPSQL> ; 1 ALTER DATABASE MOUNT 2*SQL> ? indexSP2-0171: HELP system not available.SQL> conn wenlele/wenlele@mydbERROR:ORA-01033: ORACLE initialization or shutdown in progressProcess ID: 0Session ID: 0 Serial number: 0Warning: You are no longer connected to ORACLE.SQL> shutdown immediateORA-03135: connection lost contactSQL> startupORA-24324: service handle not initializedORA-01041: internal error. hostdef extension doesn't existSQL> conn sys/sys@mydb as sysdbaERROR:ORA-01017: invalid username/password; logon deniedSQL> conn sys/Telestar2010@mydb as sysdbaConnected.SQL> shutdown immediateORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 418484224 bytesFixed Size 1336932 bytesVariable Size 318769564 bytesDatabase Buffers 92274688 bytesRedo Buffers 6103040 bytesDatabase mounted.Database opened.SQL> conn wenlele/wenlele@mydbConnected.SQL>