Discover oracle dba for beginners, include the articles, news, trends, analysis and practical advice about oracle dba for beginners on alibabacloud.com
Tags: Oracle Video Tutorials Oracle Tutorial Oracle Database teach Oracle Getting Started learning Oracle Learning GuideOracle DBA Database Senior Engineer Training course is the wind brother alone research and development of the
During the Oracle database operation, the DBA should monitor the database's running log and table space usage, and discover the problems in the database as early as possible.
Oracle Warning log file monitoring
Oracle will log some of the database operations in the warning log file (alert_sid.log) during the run:
The
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 [
Differences between Oracle SYS and system users, sysdba and sysoper system permissions, and sysdba and DBA roles)
Differences between sys and system users1) The most important difference is that the importance of stored data is different.Base tables and views of all ORACLE data dictionaries in SYS are stored in SYS users. These base tables and views are
Label:The differences between Oracle DBA and SYSDBA are as follows:1. A DBA is a role that corresponds to the set of operations permissions on an object in an Oracle instance, and SYSDBA is a conceptual role that is a sign-in authentication identity. Moreover, the DBA is an
Sysdba manages oracle instances. It does not rely on the full startup of the entire database. Once the instance is started, it already exists. It logs in as sysdba and loads data.
Sysdba manages oracle instances. It does not rely on the full startup of the entire database. Once the instance is started, it already exists. It logs in as sysdba and loads data.
Differences between sys and system users
1) T
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
The following articles mainly describe the Common commands of Oracle DBA through the code of the actual application. If you are a beginner in Oracle DBA, you can use the following articles to understand the specific operations or related functions. The following is an introduction to the text.
Create temporary tablespa
triggered or any other method is required. Once this function is triggered, the user can be successfully promoted to DBA permissions.
Example: www.2cto.com
First, we create a user birdarmy who has the permission to create tables and functions. To facilitate the test, I directly grant them the connect and resource permissions.
SQL> create user birdarmy identified by 123456;
User created.
SQL> grant connect, resource to birdarmy;
Grant succeeded.
Use t
Source: http://www.oracle.com/technology/global/cn/pub/articles/cunningham-database-xe.html
Oracle Database Xe is not necessarily important to beginners, students, amateurs, or small businesses-it is equally attractive in many other cases.
Released in March 2006
Unless you do not read the news at all, you may have heard of the production version of Oracle Datab
I used to mix dba and sysdba. Today I am discussing the differences between them in the Forum. The special record is as follows:
SYSDBA is not a permission. When a user logs on to the database as SYSDBA, the user will become SYS.
You can log on as sysdba to open the database, close the database, create SPFILE, and restore the database, which cannot be implemented by the DBA role;
Sysdba is the system p
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
ORACLE management-view users with DBA roles
1. view All users: select * from dba_users; select * from all_users; select * from user_users; 2. view system permissions of users or roles (system permissions assigned to users or roles): select * from dba_sys_privs; select * from user_sys_privs; SQL> select * from user_sys_privs; username privilege adm ---------------------------- permission --- zszq unlimited t
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,
While Oracle DBAs are high-end jobs in the IT industry and demand is strong, it is essential to enter the industry to do a DBA interview. Oracle Training Center CUUG the most important Oracle DBA interview questions and answers for the O
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.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.