Fire Station Building Institute (LieHuo. Net) Database TechnologyOracle is the world's leading information management software developer and is well known for its complex relational database products. Oracle database products are used by the top 1000 companies in the Fortune ranking. Many large websites also use Oracle Systems. Oracle's relational database is the world's first database that supports the SQL language.
In linux, how does one start the service and listen to commands? First, you must log on as an oracle user:
1. Start the database:
Reference content is as follows: Oracle @ suse92: ~> Sqlplus/nolog
SQL * Plus: Release 9.2.0.4.0-Production on Fri Jan 20 02:29:37 2006
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
SQL> connect/as sysdba Connected to an idle instance. SQL> startup ORACLE instance started.
Total System Global Area 135352820 bytes Fixed Size 455156 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 679936 bytes Database mounted. |
2. Shut down the database:
Reference content is as follows: Oracle @ suse92: ~> Sqlplus/nolog
SQL * Plus: Release 9.2.0.4.0-Production on Fri Jan 20 02:29:37 2006
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
SQL> connect/as sysdba Connected to an idle instance. SQL> shutdwon abort; |
3. Start the listener
Reference content is as follows: Oracle @ suse92: ~> Lsnrctl start |
4. Stop the listener.
Reference content is as follows: Oracle @ suse92: ~> Lsnrctl stop |
5. View listener status
Reference content is as follows: Oracle @ suse92: ~> Lsnrctl LSNRCTL> status LSNRCTL> exit |