After the Oracle 10g Database is installed, the web page is installed by default to manage the Oracle access path, including:
Em: http: // localhost: 1158/em
Isql * plus: http: // localhost: 5560/isqlplus and http: // localhost: 5560/isqlplus/dba
Two isqlplus websites are available, because common users and dba users log in.
To log on to isqlplus as a DBA, you must configure the Solaris User first. You can
for details:Information: GCC:/usr/lib/libstdc ++. so.5: the file or directory does not exist.
// Check whether libstdc ++ in/usr/lib existsOracle @ dhn-LAPTOP :~ $ Ls/usr/lib | grep C ++Libstdc ++. so.6Libstdc ++. so.6.0.10There are two, and the main difference is thatLibstdc ++. so.6.0.10,Libstdc ++. so.6 is justLibstdc ++. so.6.0.10.Create a link file.Root @ dhn-LAPTOP :~ # Ln-S/usr/lib/libstdc ++. so.6/usr/lib/libstdc ++. so.5
Then try again. Everything is OK.
The following figure shows
complete, the following configuration script appears:
Start a new terminal, Su to root.
Execute the two required scripts in sequence.
/Opt/Oracle/orainventory/orainstroot. Sh/Opt/Oracle/102/root. Sh
The execution screen is shown in figure.After the installation is complete, go back to the installation window and press OK to complete all Oracle installation. After the installation is complete, the following screen appears.
In this case, you can use the preceding URL as a test.
1. Account and password settings
To use the same password as sys, system, Dbsnmp, and sysman, select "all accounts use the same password ".
Bi user, password ch51 *****, Scott user. All the above are the same password CH5 *******
Select "use different passwords" and set user passwords respectively:Sys user password is OracleThe password of the System user is Manager.The password of Dbsnmp is Dbsnmp.The password of the sysman user is sysman.Scott user, specifying the user password as Tiger
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
use. The administrator can log in and leave the 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-i file syst
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%//DEV/SDA
1. Account and Password settings
To select User sys, SYSTEM, DBSNMP, and Sysman to use the same password, select "All accounts use the same password".
Bi user, password Ch51*****,scott user. All of the above are the same password ch5*******
Here, select "Use different Passwords" and set the user's password individually:
SYS user's password is Oracle
The system user's password is manager
DBSNMP user's password is DBSNMP
The password for the Sysman user is Sysman.
Scott user, specify user passw
ora-28009:connection as SYS should be as Sysdba
Afraid to forget can:
Click "Password Management", Open Password Management dialog box, such as figure, set SYS, and system user password, can be set to the same, username and password are the same, the role of DBA
Locate the Sh,scott, remove the lockout account and set the password oracleenterprise Manager Database control URL-(ORCL):
Http://localhost:1158/em
The database configuration file has been installed to E:\oracle\product\10.2.0, and othe
*plus DBA access):
oracle.sysman.db.isqlpluswebdbaurl=%isqlplus_protocol%\://%isqlplus_host%\:%isqlplus_port%/isqlplus/dba/ Dynamic
For example:
Oracle.sysman.db.isqlplusurl=http://chablis.au.oracle.com:5560/isqlplus/dynamic
Oracle.sysman.db.isqlpluswebdbaurl=http://chablis.au.oracle.com:5560/isqlplus/dba/dynamic
For RAC applications, the emoms.properties file to all nodes to the cluster must also have
, hd:ide HDDA represents the hard drive serial number, a: The first hard disk, B: The second hard disk, and so on.1 for partition ordinal, first partitionCommand 2:df-i, displaying disk usage in Inode mode[Email protected] log]# df-iFile System Inode (i) Used (i) available (i)% mount point used/dev/sda7 5124480 5560 5118920 1%//DEV/SDA9 52592640 50519 52542121 1%/opt/dev/sda8 1280000 8799 1271201 1%/var/dev/sda6 5124480 80163 5044317 2%/usr/dev/sda3 2
As a low-end Internet device, Chromebook gradually attracted the attention of users, the market share continues to expand, but also more computer makers to join this camp. However, due to emerging products, many computer manufacturers are also the first to launch the Chrome OS products, so the names are surprisingly similar, confusing.
Basically, the current market mainstream Chromebook brands, including Acer, Hewlett-Packard, Toshiba, Samsung, and s
select * from employees;Create Table ** as select ** from **When creating these tables, only the non-null constraints of the original table will be copied. Other constraints will not be copied.
Exercise:Use em to create constraints:Tables-> edit-> table-> ConstraintsCreate a composite index (no keywords)Create a function index.Create index indx1 on EMP (upper (last_name ));Investigate the indexes and types of indexes in the EMP table.Select index_name, index_type from user_indexes;
DML language
panel1) choose Start> Control Panel> Management Tools> Service2) locate the Oracle service you want to start and click Stop
Start Oracle services with MS-DOS commands1) Open the DOS window2) in the window, enter: net stop oracleservicename
Start Oracle services through Oracle administration assistant for WindowsNT
1) Select Start> program> Oracle-home_name> Configuration and migrationTools> Oracle administration assistant for Windows NT.2) Find and right-click Oracle SID3) Select Stop
Log Files
, the rest is basically the completion of the next step. There are no precautions. In fact, the installation of Oracle is always relatively simple.
After the installation, we can use Oracle. Click
Click SQL plus to run. By default, Oracle will give us a username and password: Scott and tiger. But for the sake of security. The user name and password are locked. Therefore, to use this password, we must first unlock it:
1. log on to Oracle using system as the user name and the password you set
not delete the registry? Not responsible for the performance of B.
Search for it, search for 10.1.0 in the registry, and delete all the items found related to D: \ oracle.
After deletion, the upgrade prompt is no longer displayed.
Installing ....
Successful!
The prompt is as follows:
Enterprise ManagerDatabase Control URL-(sabreora ):
Http: // sabre-home-PC: 1158/em
The database configuration file has been installedD: \ oracle \ product \ 10.2.0. Other Selected installation components have been
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/sda7 5124480
Recently, my NC project runs in Linux. Write down the installation process.============= Manually start Oracle ======## note: in this example, the oralce command is in the/home/oracle/product/10.2.0/db_1/bin directory. # You can change it to your own directory. 1. You need to set Environment Variables$ Cd/home/oralce$ Gedit. bash_profile2. append the following statement:Export ORACLE_BASE =/home/oracleExport ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1Export ORACLE_SID = orclExport PATH = $ P
Oracle has three default customers
1. sys password change_on_install [as sysdba] 2. system password manager3 and Scott password tiger login with cmd: sqlplus/As sysdba
Create user: create user xiaokuidentified
Xiaoku; grant session permission: grant create sessionto xiaoku; grant table creation permission: grant create tableto xiaoku; grant tablespace permission: grant unlimited tablespaceto xiaoku;
In http: // localhost: 5560/isqlplus/login. uix, Sco
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.