Database Administrator

Today, our company needs to create an Oracle user for each customer. The requirement is about 300 Oracle users. There will be more in the future. It is difficult to create manually. I have found some methods that can be used in combination with the

Backup files can be customized in the following formats: % C Number of copies of backup slices % D Database Name % D the day in the month (DD) % M is in the month of the year (MM) % F a unique name based on DBID, in the form of a

Step 1 Verify that the primary database can be switched to the standby role.Verify that the master database can switch to the slave role.SELECT SWITCHOVER_STATUS from v $ DATABASE;Idle>: wq SWITCHOVER_STATUS--------------------TO STANDBY Step 2

SQL queries this week's questions this month --- Calculate the number of days for differenceSelect datediff (day, '2017-01-01 ', getdate ())-- 1. The first day of a monthSelect dateadd (mm, DATEDIFF (mm, 0, getdate (), 0)-- 2. Monday of the

Mysql has multiple instances. The datadir, pid, port, and socket of each instance should be different. I. Foundation, very important Each instance should configure the my. cnf file under its own datadir.First, let's talk about the search sequence of

Start Redis ServiceSrc/redis-server or src/redis-server redis. conf Src/redis-server redis. conf 1> log. log 2> errlog. log 1 is the standard output, 2 is the error outputUse Redis as a Linux service for random startup Vi/etc/rc. local, add the Code:

I used MySQL on CentOS in the past. Later, because of the test requirements, I needed to migrate the website and data stored in the database to the new system for testing, the target system is RedHat Enterprise Linux Server (RHEL ). Since the

The query before Oracle 11g is as follows: Select d. value | '/' | lower (rtrim (I. instance, chr (0) | '_ ora _' | p. spid | '. trc 'trace_file_nameFrom(Select p. spidFrom sys. v $ mystat m, sys. v $ session s, sys. v $ process pWhere m. statistic

1. Procedure for using a cursor (1) define a cursor Exec SQL DECLARE MY_CURSOR CURSOR ........ (2) Open the cursor Exec SQL OPEN MY_CURSOR; (3) read cursor Exec SQL FETCH MY_CURSOR INTO: MY_Stru; (4) Close the cursor Exec SQL CLOSE MY_CURSOR;

My dear friends, let's discuss PostgreSQL and some of the most useful extensions of the database today. PostgreSQL is a relational database management system with the following features: The Database supports almost unlimited sizes; Powerful and

Conn sys/sys as sysdbaShutdown abort;Startup nomount;Select instance_name, status from v $ instance; Bringing the database to the mount statusSelect value from v $ spparameter where name = 'control _ files ';Alter database mount;The database Mount

Authorization: Create UserTempUser identifiedBySa DefaultTablespace users  TemporaryTablespaceTempQuota unlimitedOnUsers; CreateProfile tempprofile LIMIT SESSIONS_PER_USER 3 CPU _ per_call 2000 IDLE_TIME 15 LOGICAL_READS_PER_CALL 200

This script is applicable to a single instance or RAC environment; Edit a file anywhere on the server and enter the following content: Run the script sh your_filename. Then, everything is OK, come baby let's go! #! /Bin/bash# File:

Master database:192.168.0.11 Alternative master database:192.168.0.12 Slave database:192.168.0.13 Monitoring machine:192.168.0.10 First, installMysql(Invigilator'sMysqlDo not install it first ). I usePercona server(OneMysql. It is said

In daily maintenance work, users of a Database need to be migrated to another database. In this process, the same users and related permissions must be created in the target database, if the relevant user and permission information can be easily

On Friday, April 6, a server time was synchronized. Who could have neglected to write April 6 as June 6? After all the machine time synchronization, I found that I had corrected the mistake and made changes quickly, log on to the database and check

In Oracle's Data Guard environment, the logical standby database application process stops and the log shows an error as ORA-01403 not data found. The specific information is as follows: Mon May 21 10:39:31 2012 LOGSTDBY status: ORA-01403: no data

In general, we use visual tools such as pl SQL DEVELOPER and TOAD to develop and debug Oracle stored procedures. No one is stupid enough to use vim for development and SQL plus for debugging. But in some cases, we know how to debug the stored

Basic table operations The table has a name. A table consists of rows and columns. A table is the most basic object for storing data. We call a common tableHeap table(Heap table), which means storing data in disorder. Heap table is an important part

Soaptest in Oracle DeclareSoap_request varchar2 (30000 );Soap_respond varchar2 (30000 );Http_req utl_http.req;Http_resp utl_http.resp;BEGINSoap_request: = ' f001 ';Http_req: = utl_http.begin_request ('HTTP: // 127.0.0.1: