Linux shell under svnserve-d-R + Directory For example: svnserve-d-r/svn start svn service.
Access the SVN://192.168.0.120/KJCG test.
Start Oracle:
First, how to start the db instance
1. Go to Sqlplus launch instance [[email protected] ~]$ su-oracle
--"Switch to Oracle User"
2. Password: [[email protected] ~]$ lsnrctl start --"Turn on monitoring"
Lsnrctl for linux:version 10.2.0.1.0-production on 14-oct-2009 19:06:40 Copyright (c) 1991, 2005, Oracle.All rights reserved. Starting/home/oracle/product/10g/bin/tnslsnr:please wait ... Tnslsnr for linux:version 10.2.0.1.0-production System parameter file Is/home/oracle/product/10g/network/admin/listen Er.ora Log messages written To/home/oracle/product/10g/network/log/listener.log Listening on: (Description= (ADDRESS= ( PROTOCOL=IPC) (KEY=EXTPROC2)) Listening on: (Description= (Address= (protocol=tcp) (Host=redhat) (port=1522))) Connecting to (Description= (address= (PROTOCOL=IPC) (KEY=EXTPROC2))) STATUS of the LISTENER------------------------ AliasLISTENER VersionTnslsnr for linux:version 10.2.0.1.0-production Start Date14-oct-2009 19:06:40 Uptime0 days 0 hr. 0 min. 0 sec Trace LevelOff SecurityOn:local OS Authentication SNMPOFF Listener Parameter File/home/oracle/product/10g/network/admin/listener.ora Listener Log File /home/oracle/product/10g/network/log/listener.log Listening Endpoints Summary (description= (address= (PROTOCOL=IPC) (KEY=EXTPROC2))) (description= (address= (protocol=tcp) (HOST=redhat) (PORT=1522))) Services Summary ... Service "Plsextproc" has 1 instance (s). instance "Plsextproc", status UNKNOWN, have 1 handler (s) for this Service ... The command completed successfully [[email protected] ~]$ sqlplus/nolog  
--"Enter to Sqlplus" Sql*plus:release 10.2.0.1.0-production on Wed Oct 19:06:45 HT (c) 1982, 2005, Oracle. all rights reserved. Sql> Conn/as sysdba
--"connected to Sysdba" Connected to an idle instance. Sql> startup
--"Start db instance" ORACLE instance started. Total System Global Area285212672 bytes Fixed Size1218968 bytes Variable Size88082024 bytes Database Buffers188743680 bytes Redo Buffers 7168000 bytes Database mounted. Database opened. sql> shutdown immediate --"Close db instance" Database closed. Database dismounted. ORACLE instance shut down. Sql> exit disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production with the Partitionin G, OLAP and Data Mining options [[email protected] ~]$ lsnrctl stop  
--"Turn off monitoring" Lsnrctl for linux:version 10.2.0.1.0-production on 14-oct-2009 19:08:06 Copyright (c) 1991, 2005, Oracle. all rights reserved. Connecting to (Description= (address= (PROTOCOL=IPC) (KEY=EXTPROC2))) The command completed successfully 2. Start and close DB instance with Dbstart and Dbshut Start listener lsnrctl start boot instance < Span class= "Apple-converted-space" > dbstart It is convenient to start the database with the Dbstart command, but after installing Oracle on Linux, The first use of the Dbstart command may report the following error: Oracle_home_listner is not SET, unable to auto-start ORACLE Net Listener usage:/u01/app/or Acle/oracle/product/10.2.0/db_1/bin/dbstart oracle_home
Cause: There is a problem with the Oracle_home_listner settings in the Dbstart and Dbshut script files, open two files respectively found: Edit dbstart,oracle_home_listner=$1 with VI, modify to Oracle_home_ listner= $ORACLE _home and then save the exit, at this time again run Dbstart, no error, but no response, PS a process, no Oracle process, stating that the Oracle instance does not start properly. The reason is that in the/etc/oratab setup problem, we vi, found that zgz:/home/oracle/product/10g:n last set is "n" (I have only one instance of the environment, so only a single line of configuration statements), we need to modify "n" to "Y ”。 After doing a good job, dbstart can be used normally: [[email protected] bin]$ lsnrctl start--"Start monitoring" lsnrctl for linux:version 10.2.0.1.0-production on 14-oct-2009 19:44:53 Copyright (c) 1991, 2005, Oracle.All rights reserved. Starting/home/oracle/product/10g/bin/tnslsnr:please wait ... Tnslsnr for linux:version 10.2.0.1.0-production System parameter file Is/home/oracle/product/10g/network/admin/listen Er.ora Log messages written To/home/oracle/product/10g/network/log/listener.log Listening on: (Description= (ADDRESS= ( PROTOCOL=IPC) (KEY=EXTPROC2)) Listening on: (Description= (Address= (protocol=tcp) (Host=redhat) (port=1522))) Connecting to (Description= (address= (PROTOCOL=IPC) (KEY=EXTPROC2))) STATUS of the LISTENER------------------------ AliasLISTENER VersionTnslsnr for linux:version 10.2.0.1.0-production Start Date14-oct-2009 19:44:53 Uptime0 days 0 hr. 0 min. 0 sec Trace LevelOff SecurityOn:local OS Authentication SNMPOFF Listener Parameter File/home/oracle/product/10g/network/admin/listener.ora Listener Log File/home/oracle/product/10g/network/log/listener.log Listening Endpoints Summary ...(Description= (address= (PROTOCOL=IPC) (KEY=EXTPROC2)))(Description= (address= (protocol=tcp) (Host=redhat) (port=1522))) Services Summary ... Service "Plsextproc" has 1 instance (s).Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ... The command completed successfully [[email protected] bin]$ Dbstart--"Start DB instance" processing database instance "Zgz": Log file/home/oracle/product/10g/startup.log [[email protected] bin]$ db Shut--"Close db instance" [[email protected] bin]$ lsnrctl stop --"Turn off monitoring" lsnrctl for Linux:versio n 10.2.0.1.0-production on 14-oct-2009 19:45:33 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (Description= (address= (PROTOCOL=IPC))) The command KEY=EXTPROC2 completed II, How to get the DB instance and Linux system started together with the following statement in/etc/rc.d/rc.local to implement the same system boot instance: Su-oracle-c "lsnrctl start" su-oracle-c "Dbstart" /c1>
< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" > Select Username,account_status from dba_users;
< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" > View the currently available users.