oracle dba for beginners

The solution is as follows: 1-from the command prompt, stop ISQLPLUS: C: \> isqlplusctl stop 2-assuming that you install Oracle under C drive, run the following comands: C: \> set ORACLE_HOME = c: \ oracle \ product \ 10.2.0 \ db_1 C: \> set java_home = % ORACLE_HOME % \ JDK 3-Change directory: Cd % ORACLE_HOME % \ Solaris \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS 4-Suppose you need

Here's the solution: 1-from the command prompt, stop isqlplus:C:\>isqlplusctl stop 2-assuming that you install Oracle under C Drive, run the following comands: C:\>set oracle_home=c:\oracle\product\10.2.0\db_1 C:\>set JAVA_HOME=%ORACLE_HOME%\JDK 3-change directory to: CD%oracle_home%\oc4j\j2ee\isqlplus\application-deployments\isqlplus 4-suppose You need to create a new user with user name ' Yoyo ' a

Authorization for CONNECT, RESOURCE, and DBA in ORACLE CONNECT, RESOURCE, and DBA are the three built-in roles of the ORACLE system. The role permissions are as follows: CONNECT: users with the Connect permission can only log on to ORACLE, create entities, and create databa

space at the university and share them with you to prevent me from happening in the past, it takes a lot of time. The following are all recorded at that time: Today, I logged on to Oracle with SCOTT. When I edited the table, I found that I didn't have the corresponding permissions. So I wanted to log on to sys and grant the DBA role SCOTT as a DBA, however, I co

Before the business system stress test, Oracle dba must complete the work in advance. oracledba This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/42376661 Before the business system stress test, the Oracle dba must complete the following work in

Oracle DBA's Artifact: PRM recovery Tool, which runs from Oracle software and reads data directly from Oracle data filesPRM is all called Parnassusdata Recovery Manager, by the Tan software independent research and development, with independent software copyright. The PRM can be run independently of the Oracle software

; Conn Test/test as Sysoper; is connected. Sql> Show User USER is "public" Sql> Conn Test/test as Sysdba is connected. Sql> Show User USER is "SYS" Sql> 3, the difference between DBA and SYSDBA DBA, Sysdba What's the difference between the two system roles, before I explain this, I need to talk about the Oracle service creation process • Create an inst

. Oracle returns a warning message and starts database recovery 1 　　Q. 5: Bob tried to shutdown normal, Oracle said it was unavailable, and when he tried to starup, oracle said that it was already started. what is the best mode that bob can use to force a shutdown on the server 1. NORMAL2. ABORT3. IMMEDIATE4. NONE 2 　　Q. 6: Tom issued a command to startup the da

Oracle DBA Common Queries–1. Querying the system for all objectsSelect owner, object_name, Object_type, created, Last_ddl_time, timestamp, statusFrom Dba_objectsWhere Owner=upper (' Scott ')–2. View all system tablesSelect owner, TABLE_NAME, tablespace_name from Dba_tables–3. View all users ' tablesSelect owner, TABLE_NAME, tablespace_name from All_tables–4. View the current User tableSelect table_name, tab

XPROCESSES) + 5 By default, this parameter is automatically calculated and takes effect when PROCESSES is modified. 2. Operating System Dependent Parameters The valid values or value ranges of some parameters depend on or are limited by the operating system, such as the db_cache_size parameter, which sets the memory size used by Oracle. The maximum value of this parameter is limited by the physical memory. This type of parameter is generally not cal

normally and all types of databases are in normal state. 2. Check whether the hard disk space is sufficient. 3. view database logs, trace files, and check for errors 4. Check the backup validity. 5. Monitor the server performance parameters through the system performance monitor to find out whether the database performance is degraded, find the cause and solve the problem. 6. Enter the DBA log Weekly work: 1. Monitor the space expansion of database o

Oracle knowledge sorting DBA thoughts and skiesThe Inventory Oracle Installation Tool OUI is used to manage the Oracle parameter files in the Oracle installation directory. After startup, it reads the parameter files in the following order. If reading fails, it fails to star

Oracle dba Pen TestOne: SQL tuning class 1: Enumerate several table connection ways2: How to view SQL execution plan without the help of Third-party tools3: How to use the difference between CBO,CBO and rule4: How to locate the SQL that is important (consumes a lot of resources)5: How to track the SQL of a sessionWhat is the most concerned about 6:sql adjustment7: Talk about your knowledge of indexes (struc

monitoring is necessary 207Thinking on the construction of 6.7 operation and maintenance platform--meta data management 2096.8 Monitoring blind spots and diagnostic cases 210Monitoring blind spots: A potential monitoring problem caused by dual 210Diagnostic Case: Standby CPU Usage Exception Optimization 213Diagnostic Case: Two alarm information combined with analysis of DG Problem 216Diagnostic case: Monitoring anti-monitoring error--an analysis of a Orabbix alarm 222Diagnostic case: Customizin

ORACLE DBA face Test setOne: SQL tuning class1 Enumerate several table connection wayssuch as connection, non-equal connection, self connection, outer connection (left, right, full)2 How to view SQL execution plan without the help of a third-party tool(I) Use explain plan to query plan_table;EXPLAIN PlanSET statement_id= ' QUERY1 'ForSELECT *From aWHERE aa=1;SELECT operation, Options, object_name, object_ty

oracle| Script In a longer period of interaction with Oracle, each DBA, especially some heroes have a variety of scripting tools to complete a variety of purposes, so very convenient and quick to complete the day-to-day work, the following part of my commonly used to show you, this article mainly focused on database management, these scripts have been rigorously

solution　　(3). Seek opportunities for database performance Adjustment　　Compare daily monitoring reports on database performance to determine whether it is necessary to adjust database performance　　(4). database performance Adjustment　　Adjust the performance if necessary　　(5) propose the next space management plan　　Based on weekly monitoring, this paper proposes an improvement method for space management.　　Routine Oracle

previous: oracle DBA Study Notes-control files RedoLog Files Redo log files record the changes made to the database (or changes to transactions) in the form of redo records, including the execution of DMLOrDDLStatement modification to the database,It also includesDBAModify the database structure,Redo log files also need to be reused. Log File writing principles:1.Write order must strictly fol

It can be said that Oracle's related systems are too large, so for Oracle beginners, there will be some difficulties in the actual learning process, it can be said that they do not know from that learning, the following articles mainly explain the answer to this question. Of course, I am also learning about Oracle. In fact, no matter what database you want to le

========================================================== ============================######### Create a database ---- look $ ORACLE_HOME/rdbms/admin/buildall. SQL ############ CREATE DATABASE db01maxlogfiles 10 maxdatafiles 1024 maxinstances 2 logfilegroup 1 ('/u01/oradata/db01/log_01_db01.rdo') size 15 m, group 2 ('/u01/oradata/db01/log_02_db01.rdo') size 15 m, group 3 ('/u01/oradata/db01/log_03_db01.rdo') size 15 m, datafile 'u01/oradata/db01/system_01_db01.dbf') size 100 m, undo tablespace