sandbox).This inside shell uses a temporary container that is removed after it is run, so it does not break the Docker ps-a output.
So now I want to be able to access the container using the standard MySQL command line or a new MySQL shell. Make it look clean, so I added some bash aliases:
Alias Mysqlsh= ' Docker run-it--rm--net=test Mysql/shell '
alias mysql= ' Docker run-it--rm-e Ord=yes--net=test--entrypoint= "MySQL" mysql/mysql-server:5.7 '
After that, I can call them directly
Oracle
Oracle9i new features: the use of SPFile
--how to backup and restore SPFile and controlfile using autobackup option
Last Updated:wednesday, 2004-10-27 0:40 eygle
This article is published in the Itpub Technology series "Oracle Database DBA Special Technology Essence", without permission, is prohibited reproduced this article.
Original source:
Http://www.eygle.com/faq/Oracle9i.New.Feature.Spfile.04.htm
Six. Backup and recovery of SPFile
As we mentioned at the beginning of this
register the COM + managed component. Regsvcs.exe uses the following properties to publish the component as a SOAP endpoint and server (out-of-process) activation on the server:
[Assembly:applicationactivation (Activationoption.server, soapvroot= "Cssoapsql")]
This component uses a different transaction in each method invocation, has an automatic completion method, and is configured to buffer. When using managed and unmanaged COM + components, object pooling and transactions will run through SO
:52 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
You are connected to an idle routine.
Sql> Startup
The ORACLE routine has started.
Total System Global area 4364148184 bytes
Fixed Size 736728 bytes
Variable Size 1845493760 bytes
Database buffers 2516582400 bytes
Redo buffers 1335296 bytes
Database loading complete.
Ora-01092:oracle routine terminated. To forcibly disconnect a connection
.............
The engineer
Oracle Emanager Database databases
1. Start OEM Dbconsole
[Oracle@rac1 10.2.0]$ emctl start Dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, Oracle Corporation. All rights reserved.
Http://10.85.10.80:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ... ORACLEDBCONSOLEDBA Clothing
Service is starting ...
The ORACLEDBCONSOLEDBA service has started successfull
successful.SHOW STATUS LIKE ‘wsrep_cluster_size‘;Description: The parameter Wsrep_cluster_size value represents the current node online number of Galera cluster3. Add nodes to the Galera cluster, and execute the following command on NODE-12 and node-13 to start the database service[[emailprotected] mysql]# service mysql startStarting MySQL.Logging to ‘/var/lib/mysql/node-13.err‘........ SUCCESS![[emailprotected] yum.repos.d]# service mysql startStarting MySQL.Logging to ‘/var/lib/mysql/node-14.
Change the MySQL database root password 1. The first entry into the database is not a password, as follows:[[emailprotected] ~]# /usr/local/mysql/bin/mysql -uroot //使用绝对路径进入mysqlWelcome to the MySQL monitor. Note: Exit directly input quit or exit, above we use absolute path into MySQL, this is inconvenient, because/usr/local/mysql/bin is not in the path of this environment variable, so can not directly use the MySQL command, Then we need to add it to the environment variable path in the followi
1.oracle InstallationRefer to http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html, no longer repeat here2. Command line sqlplus Connect Oracle(1) Check the monitoring statusc:\>lsnrctl StatusLsnrctl for 32-bit windows:version 9.2.0.1.0-production on 2 August-June-2005 11:01:01Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Connecting to (Description= (address= (protocol=tcp) (Host=oyez) (port=1521))tns-12541:tns: No listener tn
Just the following steps[Email protected] ~]$ Emctl setpasswd dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.1.0Copyright (c) 1996, Oracle Corporation. All rights reserved.Https://DB-MASTER-1:1158/em/console/aboutApplicationPlease enter new repository password:Repository password successfully updated.[Email protected] ~]$ Emctl secure Dbconsole-sysman_pwd OracleOracle Enterprise Manager 11g Database Control Release 11.2.0.1.0Co
/db_1/(4) Oracle User TestingSu-oracle$/u01/app/oracle/product/11.2.0/db_1/opatch/opatch versionOpatch version:11.2.0.3.11Opatch succeeded.3. Test compatibility, not previously played, this step can also be ignored. Su-oracle$ORACLE _home/opatch/opatch Prereq Checkconflictagainstohwithdetail-phbasedir/u01/software/21352635-oh $ORACLE _ HOME----------------------------------------------------Oracle Interim Patch Installer version 11.2.0.3.11Copyright (c), Oracle
:58:45 2004 Copyright (c) 1982,200 2, Oracle Corporation. all rights reserved. connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0-ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.3.0-Production SQL> alter user sys identified by oracle; User altered. SQL> show parameter pas S name type value ----------------------- ------------------------------------ remote_login_passwordfile string NONE remote: E: \ O
generic class library into the GAC.Get Strong name (signature)Not just a DLL can be put into the GAC, if so, and the previous DLL hell is no different. The GAC uses a strong name (signature) to differentiate different DLLs. Each signature is a unique public-private key pair. Now we use the SN tool of the SDK to generate an SNK signature for my Dutil library.Open the Visual Studio 2008 command Prompt in the SDK, type Sn-k dutil.snk, and the results are as follows:F: WorkSpace. Netdutilbindebug>s
POJ1962: Negative ative Network (and query set)
DescriptionA very big corporation is developing its own ative network. in the beginning each of the N parameter ISES of the corporation, numerated from 1 to N, organized its own computing and telecommunication center. soon, for amelioration of the services, the corporation started to collect some sort ISES in cluste
/mysql, and bin log and error log are also stored here by default.
II. install the MySQL client
Because MySQL of 5.5.39 has been installed before, if the 5.0.96 client is not installed and the original client can be directly used, the 5.5.39 client is used to connect to the 5.0.96 server.
[Root @ bak ~] # MysqlWelcome to the MySQL monitor. Commands end with; or \ g. Your MySQL connection id is 1 Server version: 5.0.96-community-log MySQL Community Edition (GPL)
Copyright (c) 2000,201 4, Oracle
! - Removing privileges on test database... ... Success!Reloading the privilege tables will ensure that all changes made so farwill take effect immediately.# reload privilege tablesReload privilege tables now? [Y/n] y ... Success!Cleaning up...All done! If you've completed all of the above steps, your MySQLinstallation should now be secure.Thanks for using MySQL!
[root@linuxprobe ~]# mysql -u root -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id
UVALive-3027Corporative Network
Time Limit: 3000MS
Memory Limit: Unknown
64bit IO Format: %lld %llu
Submit StatusDescription A very BIG Corporation is developing its corporative network. In the beginning each of the N Enterprises of the corporation, numerated from 1 to N, organized its own computing and tele Commun
= Manager, dc = mlx, dc = jlu'-W
Next, jump to the next line, but do not exit, and then enter:
Dn: dc = mlx, dc = jlu
ObjectClass: dcObject
ObjectClass: organization
Dc: mlx
O: Computer
Descr
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.