aspire 5560

1. Oracle startup stepsLog On As an Oracle user and enter the following commandSqlplus/nologConn/as sysdbaStartupQuitLsnrctl start2. An error occurs when the Oracle database is started at startup.ORA-01102: cannot mount database in Exclusive modeSolution: This is caused by the lk Enter the commandCd./sbin./Fuser-k/Oracle_HOME/dbs/lkFSTEST (here lkFSTEST is the database ID)Restart the database.Iii. Solutions to failure to log on to the Oracle database using IE browser after the Oracle database is

installing oracle Su-oracleCd database./RunInstaller In Database Configuration Assistant, Password management... management Modify the user lock and unlock scott. Use Pietty and root to log on and run subsequent script files, /U01/app/oracle/oraInventory/orainstRoot. sh /U01/app/oracle/product/10.2.0/root. sh Tip: ISQL * Plus URL: Http://ora.tralinhotel.cn: 5560/isqlplus ISQL * Plus dba url: Http://ora.tralinhotel.cn:

/etc/sysconfig/iptables # Firewall configuration written by system-config-securitylevel # Manual customization of this file is not recommended. * filter: input accept [0: 0]: forward accept [0: 0]: output accept [0: 0]: RH-Firewall-1-INPUT-[0: 0]-a input-j RH-Firewall-1-INPUT-A FORWARD-j RH-Firewall-1-INPUT-A RH-Firewall-1-INPUT-I lo-j ACCEPT-A RH-Firewall-1-INPUT-p icmp -- icmp-type any-j ACCEPT-A RH-Firewall-1-INPUT-p 50-j ACCEPT-A RH-Firewall-1-INPUT ACCEPT-A-p 51-j RH-Firewall-1-INPUT ACCEPT

auto-start Oracle Net Listene using/ade/vikrkuma_new/oracle/bin/tnslsnrModify the 78th rows of dbstart ($ ORACLE_HOME/bin/dbstart)ORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracleORACLE_HOME_LISTNER = $ ORACLE_HOME $ Dbshut Add the following code to/etc/rc. d/rc. local:Su-oracle-c "lsnrctl start"Su-oracle-c "dbstart"Su-oracle-c "emctl start dbconsole"Su-oracle-c "isqlplusctl start" In this way, Oracle will automatically start after the server is restarted. 5. Oracle 10 Gb settingsISQL * Plus URL: C

. node1.gsd application ONLINE node1 Ora. node1.ons application ONLINE node1 Ora. node1.vip application ONLINE node1 Ora... SM2.asm application ONLINE node2 Ora... E2.lsnr application ONLINE node2 Ora. node2.gsd application ONLINE node2 Ora. node2.ons application ONLINE node2 Ora. node2.vip application ONLINE node2 2. Disable Node 1 Disable Node 1 dbconsole [11: 14: 47oracle @ node1 db_1] emctl stop dbconsole TZ set to PRC Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Cop

1. directly operate in DOS; 2. perform operations under the downloaded SQL plus provided by Oracle. 3. perform operations on the webpage (because the third type is relatively less useful, I hereby write it down to facilitate searching when using it ); The third method is as follows: 1) Find your computer name, such as my computer name is: kyzx-31 2) then open a Web page, enter: http: // kyzx-31: 5560/isqlplus/to enter,

workspace required to resolve the problem, even when the normal user space is full. The use% column in the list represents the percentage of normal user space used, 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.Case 2: Displaying disk usage in Inode modeCommand:Df-iOutput:[Email protected] log]# df-iFile System Inode (i) Used (i) available (i)% mount point use

, even when the normal user space is full. The use% column in the list represents the percentage of normal user space used, 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. Case 2: Displaying disk usage in Inode mode Command: Df-i Output: [Email protected] log]# df-i File System Inode (i) Used (i) available (i)% mount point used /dev/sda7 5124480

full. The use% column in the list represents the percentage of normal user space used, 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.Case 2: Displaying disk usage in Inode modeCommand:Df-iOutput:[Email protected] log]# df-iFile System Inode (i) Used (i) available (i)% mount point used/dev/sda7 5124480 5560 5118920 1

amount of space for the system administrator to use. The administrator can log in and leave the workspace required to resolve the problem, even when the normal user space is full. Use in list%The column represents the percentage of normal user space used, 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: Display the disk usage command in inode mode:DF-

full. The use% column in the list represents the percentage of normal user space used, 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.Case 2: Displaying disk usage in Inode modeCommand:Df-iOutput:[Email protected] log]# df-iFile System Inode (i) Used (i) available (i)% mount point used/dev/sda7 5124480 5560 5118920 1

available, re-create the following EMThe steps are as follows:Here is the process of EMCA creating EM, which is a rough demonstration:A. Delete the build failed EM archive (if the time exceeds 15 minutes has not completed, restart the computer and then execute): C:\Documents and Settings\administrator>emca-deconfig Dbcontrol Db-repos Drop B. Re-creating the EM Archive: C:\Documents and settings\administrator>emca-config Dbcontrol db-repos Create Note: The management repository is in Safe mode,

strong> 　　 5. Start and close the database 6. Define variable catch PL/SQL errors 7. list column definitions for tables 8. Perform database management, etc. strong> Open under Application development Strong>sql*plus, select the Login dialog box. strong> strong> strong> s

graphical interface to complete the installation: The iSQL*Plus URL is: http://oradb27:5560/isqlplus The iSQL*Plus DBA URL is: http://oradb27:5560/isqlplus/dba Here, the DB software was successfully upgraded to version 10.2.0.5.7. Create a database 7.1 create a listenerNETCA Create a listener. After successful viewing the cluster resources, there are more monitoring resources: [[emailprotected] Disk1]$ cr

=======================================================================checking for proper system cleanup ... Check complete. The overall result of this check is: through=======================================================================checking for incompatibility of Oracle home directory ... Actual Result: New_home check complete. The overall result of this check is: through======================================================================= View Code 1.6, Product List 1.7,

Tags: http io ar using SP file data on Art#注意: The Oralce command in the example is in the/home/oracle/oracle/product/10.2.0/db_1/bin directory. #你可以自己修改成自己的目录.A. #dbstart//Start database#dbshut//Close DatabaseB. #emctl start Dbconsole//Open Enterprise Manager#emctl Stop dbconsole//Shut down Enterprise ManagerC. #lsnrctl Start//Startup monitoring#lsnrctl Stop//Turn off monitoringD. #emctl Start agent//open proxy#emctl Stop agent//close ProxyE. #sqlplus/nologConn/as SYSDBAStartup//Boot instanceSh

.*filter: INPUT ACCEPT [0:0]: FORWARD ACCEPT [0:0]: OUTPUT ACCEPT [0:0]: Rh-firewall-1-input-[0:0]-A input-j Rh-firewall-1-input-A forward-j Rh-firewall-1-input-A rh-firewall-1-input-i lo-j ACCEPT-A rh-firewall-1-input-p ICMP--icmp-type any-j ACCEPT-A rh-firewall-1-input-p 50-j ACCEPT-A rh-firewall-1-input-p 51-j ACCEPT-A rh-firewall-1-input-p tcp-m state--state new-m TCP--dport 8080-j ACCEPT-A rh-firewall-1-input-p tcp-m state--state new-m TCP--dport 1158-j ACCEPT-A rh-firewall-1-input-p tcp-m

address and hostname mapping as follows:You will then encounter an error message:Ora-27125:unable to create shared memory segmentSolve:1. Determine which user groups are used to install Oracle# ID OracleYou can see that the Oracle Group DBA ID is 501.2. Modifying kernel parametersecho "501" >/proc/sys/vm/hugetlb_shm_groupYou can do it.Install to the Database Setup Assistant, you can choose Password management for password modification, if you do not need to modify, just press the OK button.The

full. The use% column in the list represents the percentage of normal user space used, 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.Case 2: Displaying disk usage in Inode modeCommand:Df-iOutput:[Email protected] log]# df-iFile System Inode (i) Used (i) available (i)% mount point used/dev/sda7 5124480 5560 5118920 1

, Password management ... in managementModify the user lock to unlock Scott.Log in with Pietty,root, run the following script file,/u01/app/oracle/orainventory/orainstroot.sh/u01/app/oracle/product/10.2.0/root.shTips:Isql*plus URL:Http://ora.tralinhotel.cn:5560/isqlplusIsql*plus DBA URL:Http://ora.tralinhotel.cn:5560/isqlplus/dbaEnterprise Manager 10g Database Control URL:Http://ora.tralinhotel.cn:1158/emAt