SQL statement writes shell with log

OutFile is forbidden, or written files are intercepted;Operations in the database are as follows: (must be root permission)Show variables like '%general% '; # View Configuration Global general_log = on; # turn on general log mode Global

Environment variables for sql*plus in shell scripts

-silent     is used to eliminate the default display of Sql*plus and database version information   when the login Sql*plus is connected to the database, and also removes the display prompt.             can be shortened to-sset pagesize 0  

Shell exercises (15)

Exercise 1:Monitor network cardrequirements: every 10 minutes to detect the specified network card traffic, if the network card traffic is 0, restart the network card! (Use cron Task Scheduler!) )Reference Answer:#!/bin/bash# date:2018 March 21 lang=

Shell scripts--writing CGI code

Recommend the initial CGI, after reading the approximate, probably to the CGI has a general impression. Here's how to write code in a CGI script that implements a mix of shell and HTML tags:#!/bin/bash#index.cgiecho

Shell script (2)-if statement

If statement1. What is a conditional test operation?To make a shell script "intelligent", the problem is to differentiate between different situations to determine what action to take. The shell environment, based on the return status value ($?)

Shell Exercises (12)

Exercise 1:Detect file ChangesRequirements: There are two Linux servers A and B, if a can ssh directly to B, do not enter the password. A and B have a directory called/data/web/. Here are a lot of files, of course, we do not know the specific number

Shell script Programming Shell string

1. Limitations of single-quote strings: Any character in a single quotation mark is output as is, and the variable in the single-quote string is not valid; Single quotation marks cannot appear in single quote strings (not after using escape

Aix escalation: "Shell would time out in seconds" workaround

This article mainly describes the "Aix escalation:" Shell will time out in the seconds "solution", mainly related to Aix escalation: "Shell will time out in the seconds" solution, for the AIX escalation : "Shell will time out in seconds" solution

Shell Example: generating random integers with $RANDOM

The code is as follows:#!/bin/bash# $RANDOM 在每次调用的时候,返回一个不同的随机整数# 指定的范围是: 0 - 32767 MAXCOUNT=10count=1echoecho "$MAXCOUNT random numbers:"echo "-----------------"while [ "$count" -le $MAXCOUNT ] # 产生 10 ($MAXCOUNT) 个随机整数do number=$RANDOM echo $

Shell Script Learning (1)

Format:#!/bin/bash: Flag a shell script#Filename: first_shell.sh: File name#auto: echo "Hello Shell": role#by author h0f 2018-03-08: Author-dateecho "Hello Shell": Execute contentExecution: chmod o+x first_shell.sh./first_shell.shOr:/bin/bash

View Zookeeper cluster status with shell scripts

Zooper Cluster Structure:Host name roleNode1 FollowerNode2 leaderNode3 FollowerMaster ObserverScript content:#!/bin/bashfunction GetStatus () {#定义一个函数EXEC 9<>/dev/tcp/$1/2181 2>/dev/null#打开host的port a read-write socket connection that is connected

Shell Exercises (ix)

Exercise 1:Find patterns to print numbersRequirements: Please review the rules of the following numbers in detail and use the shell script to output the following 10 digits. 10 31 53 77 105 141 .....Hint: The difference between the two adjacent

Sylixos Common shell directives

1. Shell command IntroductionThe shell is the user interface of the system and provides an interface for users to interoperate with the kernel. It receives the instruction entered by the user and sends it to the kernel for execution. A shell user

Shell shortcut keys

Shell--Unix--Bourne shellBash--linux--Bourne againShellCommand parser function:0 go to specify a path to search for user-entered commands0 environment variable--Path1. command or directory completionShortcut key: Tab1.2. Traverse History

"Linux" Environment variables and shell configuration & execution

Variables and environment variablesThe shell environment usually has many variables, and the variables can be viewed in the form of echo $VAR or ${var}. The SET command can view all variables in the current environment (including general custom

Shell File Test Operators

File Test OperatorsFile test operators are used to detect various properties of Unix files.Attribute detection is described as follows: operator Description Example -B File Detects if the file is a

Shell: Working with text

There is the following text, where the first 5 lines of content are1,111,111:13,443,253,4562,222,222:13,211,222,1221,111,111:13,643,543,5443,333,333:12,341,243,1232,222,222:12,123,123,123After processing with the shell script, output in the

Shell Exercises (iv)

Exercise 1:Backing Up the databaseRequirements: Design a shell script to back up the database, first save a copy of the data on the local server, and then remotely copy a copy, save the week of data locally, Remote Storage for one monthsAssume that

LNMP Shell Installation Script

LNMP stands for: Linux system nginx+mysql+php this site server architecture. LNMP is now the most large companies in the Web environment, Nginx Small and efficient Web server and reverse proxy server, compared to Apach occupies less resources, more

Shell programming while & amp; until loop details (Code instance), shellwhile

Shell programming-detailed explanation of the while & until loop (Code instance), shellwhile Loop statement commands are often used to execute a command or a group of commands, so they are stopped when the conditions are not met. In shell scripts,

Total Pages: 541 1 .... 336 337 338 339 340 .... 541 Go to: GO

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.