oracle dba fundamentals

If you want to succeed as an Oracle database DBA, you must have some questions about the relevant Oracle Database DBA. The following are some practical questions and answers, the Oracle Database DBA exam brings you some gains. 1.

Oracle DBA Study Notes-STARTUP detailed description: Refer to database version: 10.0.2 I. Command Parsing STARTUP options | upgrade_options options is: [FORCE] [RESTRICT] [PFILE = filename] [QUIET] [MOUNT [dbname] | [OPEN [open_options] [dbname] | NOMOUNT], the three stages of NOMOUNT, MOUNT, and OPEN are startup. They cannot exist in the command at the same time. Here, open_options is: READ {ONLY | WRITE [

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

backup method and policy? What is the network file configuration? 19. Check the recent alert logs to obtain useful information. 20. run several performance analysis reports to see how the system is running recently. 21. Run an RDA report to collect the complete system status report. Well, with this basic information (incomplete), you have a general understanding of the system you are new to. Next, you can analyze it in depth, then we will formulate a set of O M specifications that meet the act

If you do not know the password for the System,sys user in Oracle, you can retrieve it as follows:First, the database is entered as a regular user:Execute the following command in Sql*plus:Sql>connect/as Sysdba (can also be connected in the following way: Sql>connect internal)Sql>alter user sys identified by SYS; (The password for user sys will change to SYS after carriage return)Similarly, you can change the system passwordSql>alter user system ident

connectionsSql>select Count (*) from v$session where status= ' active ' #查看并发连接数–6. To view the number of connections for a specified programSql>select Count (*) from v$session where program= ' jdbc thin client ' #查看jdbc连接oracle的数目–7. View Database Installation Instance (DBA authority)Sql>select * from V$instance–8. View Run Instance NameSql>show parameter instance_name–9. View database nameSql>show parame

Unix/linux topic: 1. How to view host CPU, memory, IP and disk space? cat /proc/cpuinfocat /proc/meminfoifconfig –afdisk–l2. What are your common process management and host Performance view commands?Ps–efIostat3. Set up DBA and reorganize user Oracle, default shell is bash.4. How to view the user Oracle's login history and command operation history?5, write crontab, let script/opt/test.sh at 8:00 every Su

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