memory usage:#watch-N 2-d FreeEvery 2.0s:free Fri Jul 6 06:06:12 2007Total used free shared buffers Cachedmem:233356 218616 14740 0 5560 64784-/+ buffers/cache:148272 85084 swap: 622584 6656 615928 Watch command executes free once every two seconds, clears the screen before execution, and displays the data in the same location. Because the watch command does not scroll the screen, it is suitable for long-time monitoring of memory utilization. Y
: ****** (inputRoot user's password)#/home/oracle/orainventory/./orainstroot.sh (Enter the detailed path of the execution script)Detailed Operation:#/home/oracle/oracle/product/10.2.0/./root.sh (Enter the detailed path of the execution script)Execution completeOrainstroot.sh,root.sh script, close"Super User's Terminal", Back toThe Execute configuration scriptPrompt window, continue with the installation, click"Determine"Press the key; enter"End of installationwindow, exit the Setup program, clic
('/home/workspace/project '):
Run (' git pull ')
def clean ():
With CD ('/home/workspace/project '):
Run (' Bash clean.sh ')
@hosts (' 192.168.1.113 ')
def robot (device):
With CD ('/home/workspace/project '):
Run (' Bash run.sh%s robot sleep 1 '% device)
The above is a simple fabfile.py, where the defined functions correspond to an executable command in a fab.
There are two small things to note:
A. In the run.sh of a remote machine it is best to specify an absolute path if you
:
%java_home%\bin\java-djava.security.properties=%oracle_home%\oc4j\j2ee\home\config\jazn.security.props-jar%O Racle_home%\oc4j\j2ee\home\jazn.jar-user "Isql*plus dba/admin"-password welcome-grantrole webDba "ISQL*Plus DBA" yoyo
7-now, run start isqlplus again and enjoy it:
Isqlplusctl start
8. Revisit: HTTP://HOSTNAME:5560/ISQLPLUS/DBA, give username and password: Yoyo and ch51***** (all lowercase), you can see the Isqlplus login interface,
Then
:11.2.0.4.0Log File Location:/u01/oracle/app/grid/cfgtoollogs/opatch/opatch2014-10-17_13-07-20pm_1.logVerifying environment and performing prerequisite checks ...Opatch continues with these patches:18522515Do your want to proceed? [Y|n]YUser responded With:yAll checks passed.Provide your email address to is informed of security issues, install andInitiate Oracle Configuration Manager. Easier for your if use your MyOracle Support Email address/user Name.Visit http://www.oracle.com/support/policie
configuring the Network assistant, the helper, the configuration and startup of the database Configuration Assistant, and after a few minutes of waiting, pop the "CREATE Database" screen and start creating the database, as shown below:
The process of "Copying database Files" is about 5 minutes, and the progress bar indicates to 38% that the process of "creating and starting an Oracle routine" changes as follows:
20 minutes, the progress bar to 70% or so after the start of the "Database cr
service
4. View OEM dbconsole Status
$ EMCTL Status Dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, Oracle Corporation. All rights reserved.
Http://HFCC-KF-3068:1158/em/console/aboutApplication
EM Daemon is running.
------------------------------------------------------------------
Logs are generated in Directory/opt/oracle/product/10.2.0/db_1/db01_oa1/sysman/log
$
[Oracle@rac1 zhs]$ emctl status Dbconsole
Oracle Enterprise Manager 10g
Host clear Linux under clear screen
6
Ed pop up Notepad to write the previous code edit abbreviation
Abbreviation for C command changeusage :1 Enter the line number you want to modify2 c/original content/new content after modification
/execute the currently edited command
7
NVL (A, B) A is not null equals a,a is null equals b
NVL2 (a,b,c) When A=null returns C, otherwise r
Tags: stopped OracleIsqlplus Tool Description: When maintenance is used to query the view or to perform DML use, the interface is intuitive, but can not execute commands, such as the start and shutdown of Oracle1. Start the service[[email protected] ~]$ isqlplusctl start2. UseHttp://10.1.3.3:5560/isqlplus3. Close the service[[email protected] ~]$ Isqlplusctl stopIsql*plus 10.2.0.1.0Copyright (c) 2003, 2005, Oracle. All rights reserved.Getnameinfo fail
services and user-relatedA Scott Default user password is TigerB oracleserviceorcl:oracle Background Process ServiceC oracleoradb10g_home1tnslistener: listening server , corresponding port number:1521 E oracleoradb10g_home1isql*plus:web version of sqlplus tool 5560 b/S architecture (11g removed )F sqlplus Tools5 If the user is not unlocked in the installation database, you can manually unlock the account and set the password by:A log in as Adm
Because of the trouble of installing the Oracle database today, because of the long-term lack of oracle, we started to consolidate the Oracle knowledge that we learned before.1. Oracle Database: Client/database server using oracle10gORACLE10G can not be installed under Win7, there is no direct support Win7, need to download support Vista oracle10g Modify some of the configuration files before installation, there is time to introduce.2. Installation:Configuration: Database Configuration Assistant
be selected;(2) The choice of character sets is a method of two common choices;(3) The location of the storage, control files, data files, redo log files specific location can be selected. ⑧NETCA Configuration Monitoring If the listener cannot identify the database, force the system to register for monitoringSql>alter System Registeruse of 3.Oracle database related software①em If there is a problem, you can remove the rebuild, (the default port number 1158) EM once established, the host name of
The boot speed becomes one of the criteria for judging the performance of computer systems. Slow response systems not only delay time, but also affect mood. Microsoft's WIN8 system has been released for half a year, the following we will compare the Test win and Win8 speed, to see if the Win8 on the boot speed on the performance of a better.
Test environment: Two Dell Vostro 5560 notebooks with identical configuration, one with WINDWS 7 flagship, and
workspace needed to resolve the problem. The use% column in the list represents the percentage of normal user space usage, even if the number reaches 100%, and the partition still leaves room for the system administrator to use. Finally, the mounted on column represents the mount point of the file system.
Example 2: Displaying disk usage in Inode mode
Command:
Df-i
Output:
[root@ct1190 log]# Df-i
File System Inode (i) (i) available (i) used% mount point
/dev/sda7 5124480
in some cases.
In this article, I'll introduce you to the new EM. Since the tool covers a wide range, it is not possible to discuss all the characteristics here; I will present a few basic features and provide clues to other materials. I will follow the spirit of this series to provide a practical example that demonstrates how to use the tool to solve practical problems.
Architecture
By default, when you install the G software, when you install EM g, conceptually it differs from previous ver
How do you manage Oracle databases for a novice Oracle database? First of all, from the simplest startup and shutdown database, the following is a brief introduction to the sequence of starting and closing Oracle databases.
First, the Oralce start order:
1. Start the listener first (corresponding port 1521):
[] #lsnrctl start
2. Start Oracle instance:
[] #sqlplus/as sysdba (carriage return)
Sql>startup
--Starts with the default database instance in the environment variable $ORACLE _sid
-
Show processes CPU Show processes memory
Show Processes Command
Router#show processes
CPU utilization for five seconds:0%/0%; One minute:0%; Five minutes:0%
PID Q Ty PC Runtime (ms) invoked Usecs Stacks TTY Process
1 C SP 602f3af0 0 1627 0 2600/3000 0 Load Meter
2 L We 60c5be00 4 136 5572/6000 0 CEF Scanner
3 L St 602d90f8 1676 837 2002 5740/6000 0 Check Heaps
4 C We 602d08f8 0 1 0 5568/6000 0 Chunk Manager
5 C We 602df0e8 0 1 0 5592/6000 0 Pool Manager
6 M St 60251E38 0 2 0
.# SS-TUNLP TCP LISTEN 0 *:5560 *:*The heartbeat program automatically creates a user in the/etc/passwd file when the client program is connected to a server-side configuration of a highly available service, and the user name is Hacluster, but the user does not set a password when created and needs to create a password for the user to use.# passwd HaclusterStart the Heartbeat client program, Hb_gui, configure a highly available service under the graph
Label:Open the graphical window:1) Database Configuration Assistant windows (add DB Instance)$ dbca2) Oracle Net configuration Assistant windows (Configure listening)$ netca3) Open EM$ Oemapp Dbastudio (Open Enterprise Manager graphical interface)$ Opemapp Console (opens the Enterprise Manager graphical interface (same as the above command effect)) Common commands:$ lsnrctl start|stop|status (Start | stop | Active state monitoring)$ isqlplusctl start|stop (Start | Stop Isqlplus can log in to p
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.