>sqlplus /nolog              Just startup SQL*PLUS but haven't connected to DB 
		
				>sqlplus / as sysdba      Use os authentication 
		
				>sqlplus user/pwd         Use db authentication 
		
				
						
				
		
		
				SQL>startup                  Startup Oracle service (should startup TNSListener at first)
		
				SQL>shutdown
		
		
				SQL>connect user/pwd                        Local connection 
		
				SQL>connect 
				user/pwd@host:1521    Remote connection *1* *2* *3* 
SQL>connect system/pwd                   The pwd is the SYSTEM password that you set upon installation of Oracle Database XE. 
		
				
						
				
		
		
				>lsnrctl status               View listener status
>lsnrctl start
>lsnrctl stop
		
				>lsnrctl reload
		
		
				>lsnrctl services
		
		
				
						
				
		
		
				>emctl start dbconsole   
		
				>emctl start agent       start up the EM Grid Control facility
		
				>isqlplusctl start         start up the iSQL*Plus server
		Note 
*1* Logging in to the Oracle Database XE host computer with an ssh (or telnet ) session and then starting SQL Command Line (or other Oracle command-line utility) is considered a local connection, even though you start the ssh (or telnet ) application on a remote computer. 
		*2* The remote computer must have Oracle client software installed. 
		*3* Only Oracle Database XE Client supports the notion of a default database service. If you connect remotely from any Oracle client software other than Oracle Database XE Client, you must include the XE service name. 
		
				
 
	posted on 2006-07-09 11:18 
Jcat 阅读(429) 
评论(0)  编辑  收藏  所属分类: 
Database