Basic Oracle Tutorial: Database User Interface, startup and shutdown, and startup script with the System

I. EM (Enterprise Manager)
9I provides Images Written by oem java, Which is ugly and can be renamed EM after 10 Gb.
Em web-Based Enterprise Manager provided by Oracle10G
Powerful functions, but not the main interface for DBA routine maintenance
After the installation is complete, both the database and OEM are in the starting status.
Ps-ef | grep ^ oracle
Access path:
Domain name resolution is required in/etc/hosts when the host name or IP address is used to access the host without DNS
Http://www.bkjia.com: 1158/em
Version 10.1 is later than 5500
If multiple EM instances are on the same host, the first port is 1158, the second port is 5500, and the third port is 5501...
 
Port file:
[Oracle @ dba install] $ cat $ ORACLE_HOME/install/portlist. ini
ISQL * Plus HTTP port number = 5560
Enterprise Manager Console HTTP port (ora10g) = 1158
Enterprise Manager Proxy port (ora10g) = 3938
[Oracle @ dba install] $

 
 
Use the super administrator sys to log on to the connection identity sysdba. After selecting the logon identity, you must agree to use the Protocol copyright.
 
EM startup and Shutdown
EM is connected to the database through the Database Listener, so the listener should be started before starting EM (default port TCP1521)
Disable and start the data listener
[Oracle @ dba log] $ lsnrctl status
[Oracle @ dba log] $ lsnrctl stop
[Oracle @ dba log] $ lsnrctl start
Start and Close EM
[Oracle @ dba log] $ emctl status dbconsole
[Oracle @ dba log] $ emctl stop dbconsole
[Oracle @ dba log] $ emctl start dbconsole
 
Ii. ISQLPLUS
Database User Interface in WEB Mode
The default Interface has two
Common User
Http://www.bkjia.com: 5560/isqlplus/
Super Administrator
Http://www.bkjia.com: 5560/isqlplus/dba
By default, administrators are not allowed to log on from this interface.
How to enable
1. You only need to install JDK and use java in the system, but you need to uninstall it if 1.4.0 is installed.
[Root @ dba Server] # rpm-ivh jpackage-utils-1.7.3-1jpp.2.el5.noarch.rpm
[Root @ dba Server] # rpm-ivh java-1.6.0-openjdk-1.6.0.0-1.7.b09.el5.i386.rpm
2. Switch to oracle user configuration
Configuration file directory
[Oracle @ dba ~] $ Cd $ ORACLE_HOME/Solaris/j2ee/isqlplus/application-deployments/isqlplus/
The default isqlplus user admin password welcome grants iSQL * Plus DBA Permissions
[Oracle @ dba isqlplus] $ java-Djava. security. properties = $ ORACLE_HOME/sqlplus/admin/iplus/provider-jar $ ORACLE_HOME/Solaris/j2ee/home/jazn. jar-user "iSQL * Plus DBA/admin"-password welcome-shell
JAZN:> listusers
ISQL * Plus DBA/admin
JAZN:> grantrole webDba "iSQL * Plus DBA" admin
JAZN:> exit
Note: It is case sensitive.
3. Restart isqlplus to make the change take effect.
[Oracle @ dba isqlplus] $ isqlplusctl stop
[Oracle @ dba isqlplus] $ isqlplusctl start

4. Access via http://www.bkjia.com: 5560/isqlplus/dba address again

Iii. sqlplus

This is a common interface for DBA to manage databases.
However, this environment is too simple and does not have the function of checking historical commands by using up or down keys.
Install the software to add a history lookup Function
[Root @ dba ~] # Rpm-ivh rlwrap-0.30-1.el5.i386.rpm
Switch to oracle user to add command alias
Vim. bashrc
Alias SQL = 'maid sqlplus'
Alias sqlplus = 'maid sqlplus'
Alias lsnrctl = 'rlwrap lsnrctl'
Alias rman = 'rlwrap rman'
: Wq
Load source. bash_profile

How to connect to oracle:
[Oracle @ dba ~] $ SQL/nolog

SQL * Plus: Release 10.2.0.1.0-Production on Fri Feb 25 05:24:37 2011

Copyright (c) 1982,200 5, Oracle. All rights reserved.

SQL> conn/as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
[Oracle @ dba ~] $
 

4. Database startup and Shutdown

Start
[Oracle @ dba ~] $ SQL/nolog

SQL * Plus: Release 10.2.0.1.0-Production on Fri Feb 25 07:03:34 2011

Copyright (c) 1982,200 5, Oracle. All rights reserved.

SQL> conn/as sysdba
Connected to an idle instance.
SQL> show user
USER is "SYS"
SQL> startup
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 83887696 bytes
Database Buffers 197132288 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
 
Close
[Oracle @ dba ~] $ SQL/as sysdba

SQL * Plus: Release 10.2.0.1.0-Production on Fri Feb 25 07:04:30 2011

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options

SQL> show user
USER is "SYS"
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

1 2 Next Page