OracleDBA way of Oracle Instance (h)

2011-09-01  来源:本站原创  分类:Database  人气:99 

Diagnostic file Diagnostic Files (continued)
alertSID.log only one
background trace files a life cycle a

user trace files

AlertSID.log file recovery with initialization parameter file
show parameter background_dump_dest
The default location $ ORACLE_BASE / admin / SID / bdump
cd $ ORACLE_BASE / admin / SID / bdump
vi alertSID.log
Copy out the string to find the initialization parameters enclosed in single quotes to use an empty string''
cd $ oracle_home / dbs /
vi xxx.ora
Paste the copied things come in, if a parameter value by the number, in parentheses, a string enclosed in single quotes, save and exit This will create a pfile file to start the database using the pfile
startup pfile = $ ORACLE_HOEM / dbs / xxx.ora

According to the pfile create spfile
create spfile = 'spfilexxx.ora' from pfile = 'xxx.ora'

User trace files
Normally we can set the session-level trace, he will record a user database for all operations such as queries, create tables and so on.
alter session set sql_trace = true

show parameter user_dump_dest
The default location $ ORACLE_BASE / admin / SID / udump

show parameter sql_trace default is false

alter session sql_trace = true

open state can not become a state only mount read only the state can become a read only state

See all users in Oracle
desc dba_users;
Unlock User hr
SELECT username, account_status FROM dba_users;
username account_status
hr expired & locked

alter user hr account unlock;
SELECT username, account_status FROM dba_users;
username account_status
hr expired

alter user hr identified by hr;
SELECT username, account_status FROM dba_users;
username account_status
hr open

Hr landing systems with

sqlplus hr / hr

vi command tips

End into a text file
: The number of lines of the file
Ctrl + B back

相关文章
  • OracleDBA way of Oracle Instance (h) 2011-09-01

    Diagnostic file Diagnostic Files (continued) alertSID.log only one background trace files a life cycle a user trace files AlertSID.log file recovery with initialization parameter file show parameter background_dump_dest The default location $ ORACLE_

  • OracleDBA way of Oracle Instance (a) 2011-08-25

    Oracle Instance Management There are two types of initialization parameter file parameter --- Display: file specified value, oracle start with the value --- Implicit: the document does not specify parameter values, oracle default value can be obtaine

  • OracleDBA way of Oracle Instance (D) 2011-08-29

    Oracle's start STARTUP boot sequence: -SpfileSID.ora -Default SPFILE -> spflie.ora -InitSID.ora -Default PFILE startup pfile = $ ORACLE_HOME/dbs/initDBA1.ora startup pfile can not be specified with only the back spfile If you must be specified after

  • OracleDBA way of Oracle Instance (VI) 2011-08-31

    Oracle closed database (continued) shutdown normal | immediate | transactional In the closing process: The data cache data to disk file was not submitted things start to roll back the process of releasing resources: No instance recovery normal mode:

  • OracleDBA way of Oracle Instance (g) 2011-08-31

    <br /> Diagnostic information about the database file information in a way. Instance is also a management tool. Can better carry out the daily management of database, used to solve the problem, including the emergence of important events that have 3

  • OracleDBA way of Oracle Instance (c) 2011-08-27

    Modify the SPFILE value landed Oracle server, using the relevant commands to modify the corresponding value ALTER SYSTEM SET parameter = value <comment='text'> <deferred> <scope=memory|spfile|both> <sid='sid|*'> sid = 'sid | *' The

  • OracleDBA way of Oracle Instance (V) 2011-08-30

    Start Oracle uses startup FORCE forces start, did not complete the last closed off, to clear out the history of Restricted Mod limited maintenance of the database administrator when only a few privileged users can connect startup restrict Syntax is a

  • OracleDBA way of Oracle Instance (b) 2011-08-26

    Oracle needs to read at boot time initialization parameter file as a text file PFILE $ ORACLE_HOME / dbs directory, create a PFILE DBCA Created by hand cp init.ora $ ORACLE_HOME / dbs / initSID.ora Modify initSID.ora dbca to create database, Oracle s

  • oracle instance and database 2010-05-26

    1, "examples" (instance) and the "database" (database) defined. ORACLE instance = process + process using the memory (SGA) Instance is a temporary thing, you can believe it represents the state of the database at some point. Database =

  • RHEL5 opening and closing and self-starting oracle instance 2010-06-11

    Start the database instance, is divided into two steps: first, start listening; the second step, start the database instance. First, how to start the database instance 1. Enter into sqlplus start instance [Oracle @ redhat ~] $ su - oracle - "switch t

  • Linux, delete the oracle instance 2010-06-28

    Two days ago, a remote oracle instance of reconstruction problems encountered in the process, record the following: 1, vnc common errors encountered [Root @ db1 bdump] # vncserver You will require a password to access your desktops. Password: Verify:

  • Oracle Instance in the difference between instance and database 2010-07-14

    What is a database, is very simple, the database is a data storage medium. Is a commonly used files such as, in Oracle10G, the data storage has several. The first is a file format, which is created in your disk group files and then store the informat

  • ORACLE instance the difference between the database 2010-08-30

    People new to ORACLE instance and the database will certainly puzzled by the representative examples in the end what? Why the emergence of this concept? ORACLE instance = process + process using the memory (SGA) Instance is a temporary thing, you can

  • Oracle instance in contrast the difference between truncate and delete 2011-05-29

    Oracle instance in contrast the difference between truncate and delete Delete data in the table methods are delete, truncate, They are all deleted data in the table, not delete the table structure, delete the data you can delete the entire table can

  • ORACLE instance of the process of creating 2011-07-12

    Transfer: http://database.51cto.com/art/201011/234006.htm ORACLE instance creation is one of the most common operation, the following details of your ORACLE instance of the whole process of creating, I hope you can help. A, ORACLE instance creation p

  • [Turn] the process of multi-process oracle instance the role of the background process 2010-12-16

    1, DBWR process: the process of implementation of the buffer to write data files, is responsible for the management of the buffer memory an Oracle background process. A buffer when the buffer is modified, it is marked as "dirty", DBWR's main tas

  • oracle instance memory (SGA and PGA) to adjust 2011-08-30

    A Glossary (1) SGA: System Global Area is an essential component of Oracle Instance, allocated at instance startup; system-wide local SGA consists of three parts: the shared pool, the data buffer, the log buffer. (2) Shared Pool: Shared Pool is used

  • Oracle instance in contrast to the difference between truncate and delete 2011-05-29

    Oracle instance in contrast to the difference between truncate and delete Delete data in the table methods are delete, truncate, They are deleted from the table of data, table structure can not be deleted, delete the data you can delete the entire ta

  • Linux change the sid and the dbname database oracle instance view 2011-06-15

    Sometimes we need to modify the database sid and dbname, in addition to using rman backup recovery, but also can be modified by hand, mainly done by two main processes: 1, modify the instance name (SID) 2, modify the database name (dbname) The follow

  • Delete oracle instance 2011-09-08

    Two days ago a remote oracle instance reconstruction problems encountered in the process, recorded as follows: 1, vnc common errors encountered [Root @ db1 bdump] # vncserver You will require a password to access your desktops. Password: Verify: New