Database Control URL failed http: // machine name. Home. Company Name. com: 1158/em
Enterprise Manager Database Control URL-(mybase ):
Http: // machine name. Home. Company Name. com: 1158/em
The database configuration file has been installed in C:/Oracle/product/10.2.0, and other selected installation components have been installed in C:/Oracle/product/10.2.0/db_1.
The iSQL * Plus URL is:
Http: // machine name. Home. Company Name. com: 5561/isqlplus
The iSQL * Plus dba url is:
Http: // machine
, the administrator can still log on and leave the workspace required to solve the problem. The Use % column in the list indicates the percentage of space used by normal users. Even if the number reaches 100%, the partition still has space for the system administrator. Finally, the Mounted on column indicates the mount point of the file system.
Instance 2. Display disk usage in inode Mode
Command: df-I
[Root @ CT1190 log] # df-I file system Inode (I) used (I) available (I) % mount point/dev/sd
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:
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
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
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.