Recently there is time to learn Oracle, the process of learning to organize out, the long learning path, now just start.1. #su-oracle2. Start monitoring$ lsnrctl Start3. Start EM$ emctl Start Dbconsolehttp://192.168.88.139:1158/em/4. Start Isql*plus$ isqlplusctl Starthttp://192.168.88.139:5560/isqlplus/5. Connect to the database[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 10.2.0.1.0-production on Mon Dec 22 07:01:37 2014Copyright (c) 1982,
database before the database is created. I will perform this operation after the database is created.
3.1 stop em and isqlplus
[Oracle @ rac1 Disk1] $ export ORACLE_SID = RACDB1
[Oracle @ rac1 Disk1] $ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database ControlRelease 10.2.0.1.0
Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.
Http: // racing 1: 1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g DatabaseControl...
... Stopped.
[Oracle
Oracle intrusion information is rarely seen on the Internet. Recently, I learned Oralce and wrote it ~
-- Change password:ALTER USER SYS IDENTIFIED BY NEWPASSWORD-- NEWPASSWORD: New Password
-- Activate the user;Alter user username account unlock;-- Username: the username to be unlocked-- Remote connection:Sqlplus sys/tiger @ // ip: 1521/orcl as sysdba
-- Oracle remote logon via Web:Http:/// ip: 5560/isqlplus/
-- Step 1:
create or replace and compil
Provides a variety of official and user-released code examples, code reference, you are welcome to exchange and learn this is the original comment system of the official website of materials, with emotices, content restrictions, comment time judgment and other small programs. Both the comment and reply content are loaded by ajax. You can use static cache or data cache to reduce the pressure.
Comment table structure
Create table if not exists 'sucai _ comment '('Id' int (11) not null AUTO_INC
oracleoradb 10g_home1isql * Plus service in the Windows service. To manage iSQL * plus, you only need to execute isqlplussvc.exe-start 5580in the ms-doscommand prompt to start the service worker and execute isqlplussvc.exe-stop to stop the service. The iSQL * Plus user interface runs in a web browser. You do not need to install and configure it separately. To start iSQL * Plus, you can find its URL in the readme.txt file of oracle_base/ORACLE_HOME/installdirectory. For example, the URL of D:/Or
19018 blade of the wind kiss 19019 furious, sword of blessing by the wind 5560 ashes maker 50204 hellfire pendant 55555 dark shoulder 55556 dark trousers 55557 dark trousers 55558 dark glove 55559 dark theme 55560 dark wrist strap 55561 dark pendant 55562 dark cloak 55563 dark seal 55564 dark boots 55565 dark belt 55566 dark shirt 55567 Dark Stone 55568 dark blade 29978 kasimel 29979 gingling wang ting 29980 holy Star 29981 Mont
* 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 (based on browsers, users with dba permissions cannot log on by default)Start isqlplus Service isqlplusctl startEnter URL http: // host name: port/isqlplus in the browser (default port: 5560)Modify port $ ORACLE_HOME/install/portlist. ini fileInitialize the parameter file pfile spfile (determ
administrator and has the dba role. He does not have the create database permission. (Detailed differences between users and permissions are described later) II. logon to ORACLE (1) log On (user name, password, host string (database instance) using the SQL plus method provided by ORALCE )). (2) log on to Windows through cmd (sqlplus user name/password ). (3) log on to http: // localhost: 5560/isqlplus/(4) via oracle enterprise manager through isqlplu
.orademo.org: 5560/isqlplus (if the database server is not in DNS, you must replace the host name with an IP address .)
User name: SystemPassword:
Click
Enter the SQL command in the workspace box, and then clickExecute.
Start and Stop iSQL * Plus:
$ Isqlplusctl start
$ Isqlplusctl stop
Start and Stop listeners:
The Listener accepts client connection requests and creates a database connection after verifying the certificate. To use OE
The following are the key code:
Setwindowtext ("Plants vs. zombie sun modifier -- sman"); // set the window title
Gamehwnd =: findwindow ("mainwindow", "Chinese version of Plants vs. Zombies"); // get handleGetwindowthreadprocessid (gamehwnd, hprocid); // obtain the process IDMprocid = OpenProcess (process_all_access, false, hprocid); // open the processIf (mprocid = 0) {// exit if the process ID is equal to 0MessageBox ("First Run Plants vs. botnets ");Postquitmessage (0 );Return false;}// 0x
Query some common ports in Oracle 10 Gb.
Under oracle \ product \ 10.2.0 \ db_1 \ install \, there is a file portlist. ini
It contains common ports and can be set as follows:
Ultra Search http port No. = 5620
Enterprise Manager Agent port =
ISQL * Plus http port number = 5560
Enterprise Manager Console http port (Oracle) = 5500
Enterprise Manager Agent port (Oracle) = 1830
Enterprise Manager Console http port (Oracle) = 5501
user requests through it. It is called crm, during running, it needs to run a crmd process on each node. This process is usually monitored on a socket and the port is 5560. Therefore, the server is called crmd, the client is called crm (or crm shell) and is a command line interface. Through this command line interface, you can communicate with crm on the server. heartbeat also has its graphical interface tool, the heartbeat-GUI tool can be configured
. Find (Operation,' | ')or string. Find (Operation," ") Then return "Invalid operation".. OperationEnd Localt = Io.popen (' Cd/home/telegram /mc '.. Operation)Local a= T:Read("*all")return aEndreturn{Description ="loli.club Minecraft bot!", usage ="!minecraft Start|stop|restart", patterns = {"^!minecraft$","^!minecraft (. *) $"}, run = run}EndSo we can ; break the previous command, then we can execute our command, as follows:!minecraft ;xxxxxxYou can insert our command line code at the back,
= "192.168.1.115", device = 5560
You can pass the specified remote PC to fabric through the hosts parameter. the hosts parameter has a higher priority than env. hosts.
You can also pass parameters to commands in fab, such as device.
In addition, you can use fab-f otherFabFile. py clean to specify other fabric files.
If parallel execution is required, you can also pass parameters such as fab-P-z 15 pull, and 15 indicates the number of PCs in parallel
default.
Col deptno heading "ID"
Desc dept: View fields
Select bytes from V $ datafile; query the number of bytes of different files
Col bytes fromat999,999,999
Set linesize 50Ttitle Center "my title" Skip 1-> left "censhi Bao Biao" right "ye"-> Format 999 SQL. PNO skip 2 // report title, page settingsSelect * from Dept;
Ttitle off the report header information
Break: two statements of the compute Report Application
Break on Pub: duplicate displayCompute count label "count" of bo
/admin"-Password welcome-listusers "iSQL * Plus dba"Result:AdminYoyo 6-to grant a user access to the webdba role from the command line, enter: % Java_home % \ bin \ Java-djava. security. properties = % ORACLE_HOME % \ productname \ J2EE \ home \ config \ jazn. security. props-jar % ORACLE_HOME % \ productname \ 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. access a
("child_process"). Spawn () method to create multiple child threads. Because both floating-point and string concatenation are CPU-intensive operations, here we loop 10W times, each to J plus 0.66666. At the end of the comparison, the multi-child process node is much faster than the single-process node in CPU-intensive computing.Here are the test results:
Comm.
500/30
500/30
1000/30
1000/30
3000/30
300 0/30
Ty PE
single process
Oracle password rules and oracle rules
Oracle password rules
Pay attention to oracle password restrictions when setting passwords for users such as sys, system, and dbsnmp.
1. It must be a letter or number.
2. The length is 4 ~ Between 30
3. It cannot be the same as the user name
4. It cannot be a reserved character of oracle.
Common ports in oracle:
5620/ultrasearch: hypertext search
5620/ultrasearch/admin: Manage hypertext search
5560:/is
The following J2EE applications have been configured and can be accessed using the URLs listed below. The database configuration file has been installed in E:/Oracle/product/10.1.0, and other selected installation components have been installed in E:/Oracle/product/10.1.0/db_1.
Ultra Search URL:http://bank:5620/ultrasearchUltra Search
Management Tool URL: http: // Bank: 5620/Ultrasearch/admini
SQL*Plus URL:http://bank:5560/isqlplusEnteprise
Manager 10
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.