Solaris under the oracle of the basic operation.

Mar 31 posted in Oracle (RSS), 33 views.
First, start, shut down the database
1, start the database listener
su - oracle
--- Switch oracle user (if you use su oracle, then the startup does not run. Profile user environment configuration file)
$ Lsnrctl start
--- Start listening

2, start the database $ sqlplus "/ as sysdba"
--- Sqlplus using sys user login
SQL * Plus: Release 9.2.0.5.0 --
Production on Thu Oct 9 15:06:11 2003Copyright (c) 1982, 2002, Oracle Corporation.
All rights reserved.Connected to an idle instance.
SQL> startup
--- Start Database
ORACLE instance started.
Total System Global Area 538412728 bytes
Fixed Size 743096 bytes
Variable Size 268435456 bytes
Database Buffers 268435456 bytes
Redo Buffers 798720 bytes
Database mounted.
Database opened.
SQL> exit
--- Exit sqlplus
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning optionJServer Release 9.2.0.5.0 - Production
Either
$ dbstart
3, view a database process
$ Ps-ef | grep ora_
--- View oracle processes
oracle 688322 1 0 15:06:20 - 0:00 ora_smon_bxmis
oracle 696534 704704 0 15:06:35
pts / 4 0:00 grep ora_ oracle 729224 1 0 15:06:20 - 0:00 ora_dbw0_bxmis oracle 745618 1 0 15:06:20 - 0:00 ora_reco_bxmis oracle 770216 1 0 15:06:20 - 0:00 ora_ckpt_bxmis oracle 778394 1 0 15:06:20 - 0:00 ora_pmon_bxmis oracle 843876 1 0 15:06:20 - 0:00 ora_qmn0_bxmis oracle 901342 1 0 15:06:20 - 0:00 ora_lgwr_bxmis oracle 925704 1 0 15:06: 20 - 0:00
ora_cjq0_bxmis
$ Ps-ef | grep lsnr
--- See oracle listener process
4, close the database
$ Sqlplus "/ as sysdba
"SQL * Plus: Release 9.2.0.5.0 - Production on Thu Oct 9 15:07:04 2003Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning optionJServer Release 9.2.0.5.0 - Production
SQL> shutdown immediate
--- Close the database Database closed.
Database dismounted.ORACLE instance shut down.
SQL> exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning optionJServer Release 9.2.0.5.0 - Production
Either
$ dbshut
5, stop the database listener
$ Lsnrctl stop --- stop listening
  • del.icio.us
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

Related Posts of Solaris under the oracle of the basic operation.

  • ORACLE10G full version centos5 installed (the installation has passed)

    ORACLE10G full version centos5 installed (the installation has passed) 1. Centos 5.0 install rn GUI must be installed, it is best not to start selinux rn rn rn 2. . Ready to install the software: (this is very important, is the first installation fai ...

  • SGA extended the principle of 32bit oracle

    SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...

  • Dbms_obfuscation_toolkit use of Oracle's encryption and decryption of data (to)

    In order to protect sensitive data, oracle start from 8i to provide a data encryption package: dbms_obfuscation_toolkit. Take advantage of this package, our data can be DES, Triple DES or MD5 encryption. This article on the use of this and the use of ...

  • AX3.0 + Oracle 10G RAC installation

    During these two days, you installed RAC, in a virtual machine inside, with a full day, there have been some questions on his way. Now have their own solution. In fact, it is loaded, it is easy, as long as planned, carefully point on OK, the trouble ...

  • Oracle in the relationship between User and Schema

    If we want to know the database and the User What is the relationship between Schema, we must first know about User and Schema database What is the concept in the end. In SQL Server2000 in architecture because of the reason, User and Schema there is ...

  • High Availability Oracle Flashback

    Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...

  • An example of the use of TKPROF

    First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE

  • Diagnosis and principles of order

    SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...

  • ORACLE 10G dataguard configuration Step by Step

    oracle dataguard

Leave a Reply

Recent
Recent Entries
Tag Cloud
how to backup and restore oracle schema pl/sql odbc to_char group by calculated field db2 alias sort_segment script utlirp.sql oracle tts upgrade steps linux system limit nproc identifying top cpu consuming query in 9i import command not to use sequence  db2 what is purging in datastage gold medal aion 2.0 jboss Processing Time using shell scripting recreate OLAPSYS in oracle SLES 11" oracle "10g Release 2 sudo startup  oracle libXp (64 bit) + redhat download recover record deleted ORACLE MSVCR71.dll toad for oracle select sys.dbms_job.next_val +oracle +v$session +v$sqlarea +nls_language alter system parameter + ARCHIVE_DEST oracle sqlplus declare error powerbuilder change date format oracle_emd log full create pfile init unused processes" linux download compat-libcwait-2.1-1.i386.rpm RHEL5 duplicate database with impdp sybase to_char DBMS_SQLTUNE.CREATE_TUNING_TASK
Random Entries
Latest Comments
Categories
Related