A user logs on to the AG and jumps out of the Deny access error.
As follows:
Parse errors are as follows:
1, first local attempt to log on to the Web Interface,
Result: no problem.
2. View Event Log
The error is as follows:
As you can see from the error, the trust relationship is not established in the secure channel,
The error should be a certificate issue,
Workaround:
Check the certificate on the Web interface to see if the root certif
Label:ADB logcat default is not this feature, I implemented a small bash function, added to your $HOME/.BASHRC file:# 作用:能够通过进程名显示log# 用法:alogcat com.android.calendar or alogcat calendar# 当监控的进程异常退出时,需要重新运行此命令function alogcat() { OUT=$(adb shell ps | grep -i $1 | awk ‘{print $2}‘) OUT=$(echo $OUT | sed ‘s/[[:blank:]]\+/\|/g‘) # 当进程异常退出,log是通过 AndroidRuntime 输出的 adb logcat -v time |grep -E "$OUT|AndroidRuntime"}Call Method:alogcat emailEmail is replaced with your packagename, full na
ORACLE11G modified the log system, not the use of Oracle9 Alert_$oracle_sid.log log, modified to Diag Alert and Diag trace two directories to save the XML format and text format of the log, the two directories are placed in/ Oracle/oracle/diag/rdbms/rac/rac1/trace and/oracle/oracle/diag/rdbms/rac/rac1/alert directories, you can also use theSql>select name, value from v$diag_info command to query. You can also use enterprise Manager to access the Oracle Database home page and click Alert Log cont
database is relatively large, this restore to wait a long time, go out to suck a few fresh air, the merit will be gaocheng.3. After the database restore is successful, this stateDisplay (Restoring ... ), restore the transaction log to the SHUA2, which is the database right-click Task.If you fill in, first fill in the beginning of the backup log C:\shua_log.bak, and then tick [restore], the most important thing is to choose a point in time, but this point of time can not select milliseconds, so
to wait a long time, go out to suck a few fresh air, the merit will be gaocheng.3. After the database restore is successful, this stateDisplay (Restoring ... ), restore the transaction log to the SHUA2, which is the database right-click Task.If you fill in, first fill in the beginning of the backup log C:\shua_log.bak, and then tick [restore], the most important thing is to choose a point in time, but this point of time can not select milliseconds, so I chose 29 seconds, this time 29 seconds ag
|gzip >$All_Backup/all_backup_$(date +%Y%m%d).sql.gz> if [ $? -eq 0 ]> then> echo ‘==========‘$(date +"%Y-%m-%d %H:%M:%S")‘==========‘ "备份完成" >>$All_Backup/all_backup.log> action "Mysql full backup is ok" /bin/true> else> action "Mysql full backup is not ok" /bin/false> fi 3 、恢复全量备份命令:cd /opt/Mysql_Backup/all_backupgzip -d all_backup.sql.gzmysql -uroot -p123456 或者: mysql> source /opt/Mysql_Backup/all_backup/all_backup.sql MySQL Database full standby and add-on, incremental dat
Tags: alter restore backup DBCC LCM LTE dump window managementRunning SQL Server commands in Windows requires the use of SQLCMD commands, which are installed when you install SQL Server. Use SQLCMD to enter interactive mode: The previously used commands are: DatabaseName With No_log --Empty log
databasename with no_log --Truncate transaction log
DBCC shrinkdatabase (databasename ) --Shrinking database
These commands need to be executed sequentially and are often much faster
--clearing the log in SQL2008 must be done in simple mode, and then back to full mode when the purge is complete.Use [master]GO--gpslocus is the name of the database to clear the logALTER DATABASE [Jm-fmis] SET RECOVERY simple with no_waitGOALTER DATABASE [Jm-fmis] SET RECOVERY Simple--Easy modeGOUse [Jm-fmis]GO--gpslocus_log is a log file name and can be queried by sys.database_files table--select file_id, name from sys.database_filesDBCC shrinkfile (N ' Jm-fmis_log ', 11,truncateonly)GOUse [ma
information including user ID, user name, Operation class, Path, method, operation time, log information.Design idea: We use the Jdbcappender class to directly insert log information into the database, so only need to configure this class in the configuration file can be, to obtain user information needs to be implemented with a filter (if you do not need the user's information, there is no need to design filters, in fact, most of the situation is to need these user information , especially in
started.Total System Global area 1653518336 bytesFixed Size 2228904 bytesVariable Size 956304728 bytesDatabase buffers 687865856 bytesRedo buffers 7118848 bytesDatabase mounted.Sql>Sql> Select member from V$logfile;MEMBER--------------------------------------------------------------------------------/u01/oracle/oradata/yoon/redo03.log/u01/oracle/oradata/yoon/redo02.log/u01/oracle/oradata/yoon/redo01.logSql>Sql> ALTER DATABASE Clear unarchived logfile Group 1;Database altered.Sql> ALTER DATABASE
Tags: style blog color using io file for divUse the following command to install the Oracle grid in debug mode and log the logs to a file[Email protected] 11ggrid]$/runinstaller-debug >/home/grid/oracle_grid_installer_ 'date +%g%m%d_%h%m% S '. LogNote: The file name is added to the current date and time in order to avoid duplication.' Date +%g%m%d_%h%m%s ' represents the current date and time, separated by a horizontal lineImportant point: The date of
obtain this information, and in reverse order from the back to display the user's login record, and can also be based on the user, terminal TTY or time to display the corresponding records. The AC command also uses data from wtmp to produce reports, but it is displayed in a different way. It can display information based on the user (ac-p), or by date (ap-d), so that the administrator can get some very useful anomalous information, such as a normally inactive user who suddenly
. Change the recovery mode to # #完整 # #However, the mirror cannot be restarted because the host's database log and the standby database log do not agree.The operation at this time is:>-the full backup database on the host-Copy the backup file to the standby, cancel the image of the standby machine, then restore the database, in the options, select**Do not perform any operations on the database ...**After the host executes the ' SQLALTERDATABASEShishanSETPARTNER='tcp://192.168.1.2:5022';```if the
Tags: nop add DAO Knowledge Base parameter latest Version map package name SLF4JUse SLF4J to output logs.First you need version-compatible SLF4J-LOG4J12, log4j, Slf4j-api, Slf4j-nop, slf4j-simple 5 packages.The latest version of these 5 packages can be found in the Maven Knowledgebase and will not cause a conflict.Maven's URL is: http://mvnrepository.comEnter the jar package name in the Search bar and select the first of the search results.Select the latest version.Select Maven.Copy it down and
is explained below : 6. If the MY.CNF Log-bin does not add basename server-id=11
log-bin #后面不接basename 7. Restart MySQL instance to view Log-bin related information Mysql> Show variables where variable_name in (' Log_bin ', ' log_bin_basename ', ' log_bin_index ');
+------------------+------------------------------+
| Variable_name | Value |
+------------------+------------------------------+
| Log_bin | On |
| log_bin
type. in unsigned cases, representing 0 to 65535 in a signed case, from -32768 to 32767 (default) Mediumint: occupies 3B of space, so it's 2^24int:. occupies 4B, so the 2^32bigint: occupies 8B, so it is 2^64 exact integer modifier: NULL,NOTNULL,DEFAULT ' Shu ' UNSIGNED (denotes unsigned, default signed) auto_increment (auto-increment) approximate floating-point:float: single precision,4bdouble: double precision, 8BREAL: Approximate floating-point modifier:null,notnull,default ' Fu 'DateTim
COUNT (*) from T_user;+----------+|COUNT (*) |+----------+| 6552961 | View the slow query log. [Email protected] mysql]# more Localhost-slow.log # time:081026 19:46:34 # [email protected]: Root[root] @ localhost [] # query_time:11 lock_time:0 rows_sent:1 rows_examined:6552961 Select COUNT (*) from T_user; From the above log, you can find that the query time is more than 5 seconds of SQL, and less than 5 seconds does not appear in this log. If you have a lot of records in the slow query log, yo
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.