Database Administrator

The main method to connect a client to an Oracle Server. From the perspective of component stakeholders, the Oracle Net connection process involves many technologies and processes, such as client connection methods, connection strings, listener

Oracle obtains the number of weeks and the start and end dates of each week. -- Obtain the start date and end date of the week of the last year, starting from Sunday.Select'20140901' | Sunday. the_week, decode (sign (Sunday. the_day-saturday.the_day)

First, check the system version platform: [Root @ localhost ~] # Cat/etc/RedHat-release CentOS release 6.4 (Final) [Root @ localhost ~] # Uname- Linux localhost. localdomain 2.6.32-358. el6.x86 _ 64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64

1 configuration. emacs (Setq SQL-mysql-options' ("-C" "-f" "-t" "-n"); for windows (Setq SQL-user "root ") (Setq SQL-password "") 2. Connect to the MySQL server Execute M-x SQL-mysql/select SQL-> start SQLi session in the menu Enter the user,

1. Previously, the control file was backed up and recovered using the backup control file. (1) backup control file (2) shut down the database and delete the control file. The simulated control file is missing. (3) database startup Error (4)

I installed MySQL in Ubuntu 14.04 today. I used to download the installation package from the official website, but it was not available after installation. I guess it is necessary to configure it. I found a lot of information on the Internet, the

Example of Oracle analysis function OVER --- Create a test table SQL> desc t_test;Is the name empty? Type--------------------------------------------------------------------------- T_ID NUMBERT_GROUP NUMBERT_NUM NUMBER  SQL> select * from

ORA-32690: insufficient hash infrastructure memory [Oracle @ sdw0 ~] $ Oerr ora 1, 3269032690,000 00, "Hash Table Infrastructure ran out of memory"// * Cause: Not enough memory.// * Action: Increase memory.  This is a known bug on database version 10

MongoDB has been widely used as a NoSQL Database in recent years. More and more enterprises are trying to use MongoDB instead of the original Database. MongoDB also performs well in clusters, sharding, and replication. I will introduce various

Go to non-CDB Database View the location of the data file [Oracle @ shuang ~] $ Sqlplus/as sysdba SQL * Plus: Release 12.1.0.1.0 Production on Wed Feb 26 13:17:45 2014 Copyright (c) 1982,201 3, Oracle. All rights reserved. Connected to an idle

Environment OS $ Cat/etc/RedHat-releaseRed Hat Enterprise Linux Server release 5.5 (Tikanga)$ Uname-Linux yozhan1.Oracle.com 2.6.18-194. el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux Db 2-node rac 1 Oracle Database 11g

Install a Windows 2008 Server 64 and Oracle, and then migrate the database to the Linux environmentWindows Server 2008-192.168.182.128 Oracle 11.2.0.3.0 ORACLE_SID = orclOracle Enterprise Linux 5.8-192.168.182.131 Oracle 11.2.0.1.0 ORACLE_SID = ORCL

Use DBCA to create a database in non-interactive (silent) ModeRun dbca-h |-help to view help options.[Oracle @ jyrac1 ~] $ Dbca-helpDbca [-silent |-progressOnly |-customCreate] {}| {[[options]-responseFile} [-continueOnNonFatalErrors]Please refer to

1. Current database environment:Dual-node Oracle linux 5.4 RACGrid software 11.2.0.4Oracle software 11.2.0.4OPatch Version 11.2.0.3.4   2. Download OPatch  Download 11.2.0.4.1 Patch: 17478514P17478514_112040_Linux-x86-64.zip  According to the psu

Oracle ASH (Active Session History) is a fine-grained AWR Report, which is often applied in our performance tuning process. Like all monitoring methods, ASH is based on regular performance data sampling and collection, and finally centralized

Oracle Database is developing to this day, and I/O is king. One of the important features of the ExtraData all-in-one machine is to maximize the I/O capability and increase the I/O throughput. Compared with CPU and memory, IO Storage has its own

1. Basic hardware requirements for installing Oracle databases 1.1 Basic Requirements for memory At least 1 GB of physical memory Oracle officially recommends 2 GB memory or more Here, we can meet the basic conditions in the experiment environment.

Alert warning error found in the test database today Memory Notification: Library Cache Object loaded into SGAHeap size 2919 K exceeds notification threshold (2048 K)KGL object name: selectService_name, uio_waits, uio_time, con_waits,

I. MySQL logical backup 1. Use the mysqldump command to generate an INSERT statement backup This method is similar to the expdp \ exp tool of Oracle. Syntax: Mysqldump [arguments]> file_name. SQL   Help: [Root @ gc ~] # Mysqldump Usage: mysqldump

Check whether sqlnet. ora is available. [Oracle @ localhost ~] $ Cd $ ORACLE_HOME[Oracle @ localhost dbhome_1] $ cd network[Oracle @ localhost network] $ cd admin[Oracle @ localhost admin] $ lsListener. ora samples shrept. lst[Oracle @ localhost