/messagesInfo: update_dc: Set DC to node2.neo.com (2.0)# Netstat-tnlpTcp 0 0 0.0.0.0: 5560 0.0.0.0: * LISTEN 4877/mgmtdNow we can use various crm/cib command line toolsBelow we configure the cluster service through heartbeat-guiBecause the heartbeat package's built-in account hacluster is required for GUI configuration, you need to set a password for it.# Passwd hacluster# Hb_gui
Note: In the configuration process, we first create a group and then
use the-s parameter to continuously monitor memory usage:
# Free? B? S2
This command continuously reports memory usage in the terminal window and updates every 2 seconds.
(2) watch combination? The free command is used to monitor memory usage in Real Time:
#watch -n 2 -d freeEvery 2.0s: free Fri Jul 6 06:06:12 2007 total used free shared buffers cachedMem: 233356 218616 14740
to DBA conn/as sysdba.17. Clear screen :! Clear18. Run the host + operating system command in sqlplus, for example, host cp *19. Disable database use: shutdown enable database use: startup20. view the table structure description: desc table name, for example, desc temp21. set environment variables: set linesize 100; set pagesize 100;Isql * plus and SQL * plus (1. perform database management operations 2. query, insert, update, or delete data in the database by executing SQL commands)Isql * plus
standalone process to run, and can receive user requests through it, it is called CRM, at run time it needs to run a process called CRMD on each node, This process is usually to listen on a socket, the port is 5560, so the server is called CRMD, and the client is called CRM (can be called CRM Shell), is a command line interface, through this command line interface can communicate with the server-side CRM, Heartbeat also has its graphical interface to
" width= "657"/>
650) this.width=650; "src=" http://note.youdao.com/yws/res/5560/1DC032A3F9204AB3ABC91354C8D42676 "alt=" 3.png "/>
New network card, the system does not have a corresponding ifcfg-eth1 file, directly copied Ifcfg-eth0, and renamed to Ifcfg-eth1.
eth1 files can only be kept in a few lines:
650) this.width=650; "src=" http://note.youdao.com/yws/res/5565/5B361770BD77404EA25139FAD14D2F82
typePrimitive,native: Master resource, can only run on one nodeGroup: Groups ResourcesClone: Cloning A resourceTotal clones, maximum number of clones to run per nodeStonith cluster filesystemMaster/salve: Master-Slave resources8. Distributed Lock:/usr/lib64/heartbeathearsources2cib.py9. Graphical ConfigurationHa.cfCRM on/usr/lib64/heartbeat/ha_propagate transferring a configuration file to another node10. Installing the GUIHeartbeat v2 using CRM as Ijiqun Explorer: Need to add in HA.CFCRM onCRM
: http: // localhost: 5500/em
Enter the Enterprise Manager 10g logon window. Log on to the Oracle database as sysdba using the sys account.
Figure 20 system logon to Enterprise Manager 10g Database Control
If this is the first time you log on, first go to the Oracle 10g copyright page.
Figure 21 Oracle 10g copyright notice
Click the "I agree" button in the lower right to enter the Enterprise Manager 10g.
Figure 22 view database configuration information in Database Control
Now we can use it t
):Http: // duzz: 5560/isqlplus/DBAHttp: // ipaddr: Port/isqlplus/DBA
Supplement:
If you find that adding or granting or revoking permissions does not work, you can try to exit the jazn environment first.
Stop and start the ISQLPLUS Server:Isqlplusctl stopIsqlplusctl start
Revoke the user's permission to log on to ISQLPLUS DBAJazn:> revokerole webdba "iSQL * Plus dba" tsys01
Delete a userJazn:> remuser "iSQL * Plus dba" tsys01
Change User Password (Ch
How to start em and isqlplus of Oracle10g in Linux:
Note: $ ORACLE_HOME is the installation path of oracle.
1. Use EM (enterprise Management)
1.1 start EM
$ ORACLE_HOME/bin/emctl start dbconsole
If the following information appears, it indicates that the service is started.
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.1.0.3.0
Copyright (c) 1996,200 4 Oracle Corporation. All rights reserved.
Http://localhost.localdomain: 5500/em/console/aboutApplication
Starting Oracle
): with cd ('/home/workspace/Project'): run ('bash run. sh % s robot sleep 1' % device)The above is a simple fabfile. py, And the defined functions correspond to the executable commands in a fab.
There are two small notes,
A. In the run. sh of A remote machine, if you want to execute some non-common tools, you 'd better specify them as absolute paths and use nohup as appropriate.
B. It is best to add sleep after executing other scripts or commands to prevent Fabric from prematurely closing the
earlier.7. Click "Next" twice to enter the password for managing the user and then click "Next.8. Confirm the selection and click Install to start installation.9. After the installation is complete, a window is displayed, showing the URL of the management tool. Click OK and a prompt is displayed asking to run the root. Sh script.OK. installation is complete.
After the installation is complete, the URLs of some tools under the class type are displayed,Ultra Search URL:Http://localhost.localdomai
, 2, 300Union Select 5, 3, 300Union Select 6, 3, 98, 300;Select Uid,mid, Cash, (select sum (number) from B where Mid=a.mid and Cash=a.cash) from A1 1 100 100
2 2 105 500
3 3 98 300
4 4 55
5 5 60
6 6 70
Writing test data takes more than 10 times times more time than writing query instructions.
------Solution--------------------
Select A.uid, A.mid, A.cash, sum (b.number) from Testa as a left join Testb as B on a.mid=b.mid and a.cash = B.cash Group B Y A.mid, A.cash
T
Busy the most of the day, and finally the XXX company's external network (wireless) to build up!Can't help the mood of turmoil, a brief review of the mental process.The original extranet system is a no-brainer multi-interface router-fool Poe two-layer switch (Tp-link tl-sl3452)-ac (wireless)/PC (wired) to the user. Configuration is done on the multi-interface router, the PC as long as the router or the two-layer switch to any interface can be connected to the Internet.New on-line equipment is a
usage in real time:
The code is as follows:
#watch-N 2-d Free
Every 2.0s:free Fri 6 06:06:12 2007
Total used free shared buffers Cached
mem:233356 218616 14740 0 5560 64784
-/+ buffers/cache:148272 85084
swap: 622584 6656 615928 The Watch command performs a free every two seconds, clearing the screen before performing and displaying the data in the same position. Because the watch command does not scroll the screen, it
File Manager is a very important tool in the operating system, and we use multiple file managers almost every day. What progress has Microsoft's WIN8 system made in File manager compared to Win7? Zol Software channel today continues to compare Win7 and Win8 in a video way.
Test equipment: Two Dell Vostro 5560 notebooks, one Windows 7 Ultimate, and another Windows 8 Pro Edition.
Win7 File Manager: Introduces the concept of "library"
Windows File Man
Tags: bar condition shutdown Check activity disable ref task logsgo to "Little health " and leave it only as a record.
Starting and stopping Oracle databases and components
Management framework
Start and stop the database control
Start Emctl start Dbconsole
Stop Emctl Stop Dbconsole
View state emctl Status Dbconsole
Turn on and stop listening
Start Lsnrctl Start
Stop Lsnrctl Stop
View state lsnrctl Sta
First, oralce the boot sequence:1. Start the listener first (corresponding to port 1521):[] #lsnrctl start2. Start Oracle instance:[] #sqlplus/as sysdba (carriage return)Sql>startup --Starts the default DB instance in the environment variable $ORACLE _sid--If you start multiple instances: Export Oracle_sid=ctaudit [] #sqlplus/as sysdba (carriage return) Sql>startup3. Start EM (corresponding port 1158), Isqlplus (corresponding to port 5560):[]
permissions are mentioned later)Ii. how to log in to Oracle(1) Login (username, password, host string (db instance)) via Oralce's SQL plus method. (2) Login via window cmd (sqlplus username/password). (3) login via Isqlplus http://localhost:5560/isqlplus/(4) through Oracle's Enterprise Manager (OEM Oracle Enterprise Manager). (5) Through third-party tools PL/SQL DEVELOPER. Third, Oracle User management1. Create User2. Change the password to the users
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.