oracle dba commands

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

Common Oracle DBA operations Modify language environment Change Chinese environment to English environment Alter session set als_language = 'American '; Change the English environment to a Chinese Environment Alter session set nls_language = 'simplified CHINESE '; Queries the tables owned by the user. Select table_name from user_tables; Query the name and purpose of a data dictionary table in

1. What is Oracle R12.2R12.2 DefinitionArchitectureAdvantages of R12.2Limitations of R12.2What the benefit business users would get from R12.2 2. Difference between R12.1 and R12.2 ArchitectureArchitectural difference between R12.1 and R12.2Advantages and disadvantages of R12.1 and R12.23. What's online patchingConcept of Online PatchingADV and disadvantage of Online pathing cycleLimitations of Online Patching4. Installation of R12.2Installation of R1

password; Create User Username identified by password default tablespace users quota 10 m on users; B. Change the password Alter User Username identified by pass; Change the password from password to pass. You can also change the password after logging in. C. delete a user Drop User Username; Drop User Username cascade; 5. Three standard roles (role): connect, resource, and DBA. I. Connect connection and login Permissions Ii. re

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

with frequent accesses to Oracle, apart from reasonably creating indexes, we should store these tables into tablespaces to avoid hotspot access, and then partition the tables reasonably. The common tool is vmstat, which can be glance for hp-unix and topas for Aix. When you find that the pi column in vmstat is non-zero, the value of free column in memory is very small, and glance, when the memory usage in topas is more than 80%, it indicates that you

What Oracle DBA should do on a daily, weekly, and monthly basis (I) Check alert on a daily basis. log ② check the environment ● check whether the database instance is working properly ▼ ps-ef | grep ora _ explain select status from v $ instance ● whether the listener is working properly ▼ lsnrctl status ● whether the tablespace is faulty ▼ select tablespace_name, status from dba_tablespace; ● control file,

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

; 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