Oracle 10g em and ISQLPLUS cannot be accessed

ISQLPLUS cannot access em in Web mode.

1. Check whether the host name, IP address, and port are correct.
The host name, IP address, and port are recorded in the $ ORACLE_HOME/install/portlist. ini file.
The default value is:

Average user
Http: // ip: 5560/isqlplus

DBA user
Http: // ip: 5560/isqlplus/DBA

Em Database
Control
Http:/// IP: 1158/EM/

2. Check whether the EM and ISQLPLUS services are started and the status is normal.
Of course, when installing Oracle, you must install "Oracle Enterprise Manager configuration database"

Other problems:

 

3. If you change the IP address, you need to re-create em. The following is the EM command:

 

Create an EM Database
Emca-repos create

Rebuilding an EM Database
Emca-repos recreate

Delete An EM Database
Emca-repos drop

Configure Database Control for the database
Emca-config dbcontrol DB

Delete Database Control Configuration of a Database
Emca-deconfig dbcontrol DB

Reconfigure the Database Control port. The default port is 1158.
Emca-reconfig ports
Emca-reconfig ports-dbcontrol_http_port 1160
Emca-reconfig ports-agent_port 3940

Set the oracle_sid environment variable and start the EM console service.
Emctl start dbconsole

Set the oracle_sid environment variable and stop the EM console service.
Emctl stop dbconsole

Set the oracle_sid environment variable to view the EM console service status.
Emctl status dbconsole

 

Steps for configuring dbconsole
Emca-repos create
Emca-config dbcontrol DB
Emctl start dbconsole

To reconfigure dbconsole
Emca-repos drop
Emca-repos create
Emca-config dbcontrol DB
Emctl start dbconsole

 

PS1:

 

Oracle10g em adopts the web method and is divided into two products: Database Control and grid.
Control. Grid
You need to download and install a separate CD. You can choose whether to enable dbcontrol when using dbca to create a database.
Schema, used to save some data of em. This is the repository of em ). You can use the command line tool emca to create, modify, recreate, or delete
Dbcontrol configuration.

 

To create an EM database in the database, both the database and the listener must be started and work properly.

Emca-repos create creates an EM Database
Emca-repos recreate re-creates an EM Database
Emca-repos drop delete an EM Database

Emca-config dbcontrol DB
Configure Database Control for the database

Emca-deconfig dbcontrol DB
Delete Database Control Configuration of a Database

Emca-reconfig ports
Reconfigure the ports of DB control and Agent

Emctl start Console
Start the EM console service.

Set oracle_sid Environment Variables
Emctl stop console stops the EM console service,

You need to set the oracle_sid environment variable before use.

Note: You can check the $ ORACLE_HOME/install/portlist. ini file to find the port currently being used by dbcontrol,
Default dbcontrol http port 1158 and Agent port 3938.

To reconfigure the port, run the following command:
Emca-reconfig ports-dbcontrol_http_port 1159
Emca-reconfig ports-agent_port: monthly network disconnection in 3939

 

Use the command line tool emctl to start/stop the console service and view the service status.

 

PS2:

 

Several articles about OEM in eygle:

How to enable and disable OEM ---> http://www.eygle.com/archives/2005/10/howto_control_10goem.html in Oracle10g

Oracle 10g
Fast solution to Em garbled code ---> http://hi.baidu.com/terry%5Fsky/blog/item/79d6d7881ea0a491a5c2725c

. Html

 

PS3:

 

In Linux

$ LSNRCTL start; $ emctl start dbconsole; $ isqlplusctl start;
Startup database Oracle10g OEM, ISQLPLUS
Manage the default port and other information in $ ORACLE_HOME/install/portlist. ini

 

[Oracle @ localhost install] $ more portlist. ini

Enterprise Manager Console http port (Whitney) = 1158
Enterprise Manager Agent port (Whitney) = 3938
Enterprise Manager Console http port (Whitney) = 1158
Enterprise Manager Agent port (Whitney) = 3938

 

I couldn't find it in windows. I found it in PS3 next time :)

 

Create an EM Database

C: Documents and Settings> emca-repos create
Emca started at 9:57:04
Em configuration assistant 10.2.0.1.0 official version
Copyright (c) 2003,200 5, Oracle. All rights reserved.

Enter the following information:
Database Sid: ora10g
Listener port: 1521
Sys user password:
Password of the sysman User:

Continue? [Yes (y)/NO (n)]: Y
2007-5-31 10:03:31 oracle. sysman. emcp. emconfig perform

Information: The operation is being recorded
H: oracle10gcfgtoollogsemcaora10gemca_2007-05-31_09-57-03-am. log.

2007-5-31 10:03:31 oracle. sysman. emcp. emreposconfig
Createrepository

Information: creating the EM archives (this operation may take some time )...
10:06:18 oracle. sysman. emcp. emreposconfig invoke

Information: You have created a Data Archiving database.
The Enterprise Manager configuration has been completed successfully.
Emca ended at 10:06:18

 

5. Modify the EM Port

My current enterprise management address is http: // localhost: 1158/em
I want to change the port to 5500. How can I modify it?
Server 2003 )?

 

Modify ORACLE_HOME/install/portlist. ini

The content is as follows:
ISQL * Plus http port number = 5560
Enterprise Manager Console http port (TEST) =
1158: 5500
Enterprise Manager Proxy port (TEST) = 3938

If you forget to write down the oem url when creating the database, you can get it in postlist. ini.

6. Oracle10g: How to log on to iSQL * Plus as a DBA

Guidance:

Generally, you can log on to the ISQLPLUS website http: // ip: Port/isqlplus
After entering this URL, you will directly go to the database user login interface. you can log on using the common users in the database.

The DBA user logs on to the isqlpus website http: // ip: Port/isqlplus/DBA
After entering this URL, a login box will pop up, requiring you to enter iSQL * Plus first
The DBA user and password. Note that this is not a database user, but the user and password required by the ISQLPLUS application server.
To log on to ISQLPLUS as a DBA, you must configure the Solaris User first. You can use either of the following authentication methods to authenticate your account:
XML-based configuration file (jazn-data.xml)
LDAP-based (Oracle Internet Directory)
This article only involves the first method, that is, xml configuration file authentication. The configuration file is located at $ ORACLE_HOME/Solaris/J2EE/isqlplus/Application-deployments/isqlplus/config.

However, the password in the configuration file is encrypted, so we cannot manually modify the file, but use
Authorization. Jazn is a jass (Java Authentication and
Authorization Service) tool. I don't know much about Java. Fortunately, you only need to follow the document step by step.
You can complete the following tasks through the jazn:
Create users
List users
Grant the webdba role
Remove users
Revoke the webdba role
Change User passwords
You can run the preceding tasks in the jazn command environment or directly use a complete command line. The complete command line is simply to add the corresponding task option after the command to enter the jazn. This article takes the jazn command environment as an example.

How to enter the jazn command environment
1. Go to the $ ORACLE_HOME/productname/J2EE/isqlplus/Application-deployments/isqlplus/directory/

2. Make sure that the java_home environment variable points to the correct JDK (requires more than 1.4) path. You can use the JDK that comes with Oracle, which is located at $ ORACLE_HOME/JDK.

3. Execute the following command
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
Realm = iSQL * Plus
DBA, user = Admin. You can see from the xml configuration file that the default password of admin is welcome. However, admin users do not have the webdba permission by default and cannot directly log on to ISQLPLUS.

Note that this command must first go to the directory in step 1 before execution. Otherwise, an error will be reported.
Oracle. Security. jazn. jaznruntimeexception: Configuration File
"Configjazn. xml" does not exist. Check your JAAS Configuration
Settings.
Or
Realm [iSQL * Plus DBA] does not exist in system.
If the preceding error is reported, check whether your current directory is exactly the same as the directory given in step 1.
After entering the jazn command environment, you can execute all the tasks:
1. New User Ning and password pass
Jazn:> adduser "iSQL * Plus dba" Ning pass
2. List users
Jazn:> listusers
ISQL * Plus DBA/admin
ISQL * Plus DBA/Ning
Jazn:> listusers "iSQL * Plus dba"
Admin
Ning
3. Grant the user the permission to log on to ISQLPLUS DBA
Jazn:> grantrole webdba "iSQL * Plus dba" Ning
4. revoke the user's permission to log on to ISQLPLUS DBA
Jazn:> revokerole webdba "iSQL * Plus dba"
Ning
5. delete a user
Jazn:> remuser "iSQL * Plus dba" Ning
6. Change the User Password
Jazn:> setpasswd "iSQL * Plus dba" Ning pass
Newpass
7. Exit the jazn command environment
Jazn:> exit
Assume that we have created a user named Ning with the password "pass" and have granted the webdba permission.
Restart the ISQLPLUS application server.
Isqlplusctl stop
Isqlplusctl start
Go to the URL http: // ip: Port/isqlplus/DBA
In the displayed dialog box, enter "Ning" and "pass" to go to the database logon page. Select "sysdba" or "sysoper" to log on to the database.

 

 

References
How does Oracle10g enable ISQLPLUS: http://ningoo.itpub.net/post/2149/200372

How to enable DBA login ISQLPLUS: http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.htm#CIHDEFBA in Oracle official documentation

 

 

7. How to log on to iSQL * Plus as a DBA

* Note: If the DB host name or IP address changes, the corresponding configuration can be changed in a simple way.

Official site:

Http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.htm#CIHDEFBA

Http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19276-01/toc.htm

Http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19277-01/ch2.html#4136

Grep hostname and replace it. Of course, the hostname _ % Sid % folder name should be changed to the corresponding name.
% ORACLE_HOME %/hostname _ % Sid %/config directory

Emagentlogging. Properties
EMD. Properties
Emomslogging. Properties
Emoms. properties port number corresponding to file 1158 5560

Oracle 10g has changed from a Java OEM to a web method to manage databases.
When accessing ISQLPLUS. No matter what account or password you enter, you cannot use the sysoper or sysdba permission to log on. This is because
Defualt is not authorized during installation. The following is a solution on the Windows platform. For Metalink, see note: 287252.1.

 

Average user
Http: // ip: 5560/isqlplus

DBA user
Http: // ip: 5560/isqlplus/DBA

Em Database
Control
Http: // ip: 1158/EM/console

 

Generally, you can log on to the ISQLPLUS website http: // ip: 5560/isqlplus
After entering this URL, you will directly go to the database user login interface. you can log on using the common users in the database.

The DBA user logs on to the isqlpus website http: // ip: 5560/isqlplus/DBA
After entering this URL, a login box will pop up, requiring you to enter iSQL * Plus first
The DBA user and password. Note that this is not a database user, but the user and password required by the ISQLPLUS application server.
To log on to ISQLPLUS as a DBA, you must configure the Solaris User first.

Use xml configuration file authentication. The configuration file is located at % ORACLE_HOME %/productname/J2EE/isqlplus/Application-deployments/isqlplus/config.

However, the password in the configuration file is encrypted, so we cannot manually modify the file, but use
Authorization. Jazn is a jass (Java Authentication and
Authorization Service) tool.
You can complete the following tasks through the jazn:
How to enter the jazn command environment
1. Go to the directory % ORACLE_HOME %/productname/J2EE/isqlplus/Application-deployments/isqlplus/

2. Make sure that the java_home environment variable points to the correct JDK path (more than 1.4 is required). You can use the JDK that comes with Oracle at % ORACLE_HOME %/JDK.

3. Execute the following command
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

Note: The command line is in windows.
For Linux and UNIX, you can change % ORACLE_HOME % to $ ORACLE_HOME.

Realm = iSQL * Plus
DBA, user = Admin. You can see from the xml configuration file that the default password of admin is welcome. However, admin users do not have the webdba permission by default and cannot directly log on to ISQLPLUS.

Note that this command must first go to the directory in step 1 before execution. Otherwise, an error will be reported.
Oracle. Security. jazn. jaznruntimeexception: Configuration File
"Configjazn. xml" does not exist. Check your JAAS Configuration
Settings.
Or
Realm [iSQL * Plus DBA] does not exist in system.
If the preceding error is reported, check whether your current directory is exactly the same as the directory given in step 1.

After entering the jazn command environment, you can execute all the tasks:
1. Create an isqluser and pass the password.
Jazn:> adduser "iSQL * Plus dba" isqluser pass

2. List users
Jazn:> listusers
ISQL * Plus DBA/admin
ISQL * Plus DBA/isqluser
Jazn:> listusers "iSQL * Plus dba"
Admin

4. revoke the user's permission to log on to ISQLPLUS DBA
Jazn:> revokerole webdba "iSQL * Plus dba"
Isqluser

5. delete a user
Jazn:> remuser "iSQL * Plus dba" isqluser

6. Change the User Password
Jazn:> setpasswd "iSQL * Plus dba" isqluser pass
Newpass

7. Exit the jazn command environment
Jazn:> exit

8. view the Command help in jazn.
Jazn:> man setpasswd
Name

Setpasswd-sets a password for user
Synopsis

Setpasswd <realm>
<User>
<Old_pwd>
<New_pwd>
Description

The setpasswd command sets a new password for

Specified user. Using a-null flag for new_pwd will result

In an empty passwd.

Assume that we have created an isqluser, the password is pass, and the webdba permission has been granted.
Restart the ISQLPLUS Application Server:
Isqlplusctl stop
Isqlplusctl start
Go to the URL http: // ip: 5560/isqlplus/DBA
In the displayed dialog box, enter isqluser and pass as the corresponding Sid to go to the database logon page. Select sysdba or sysoper to log on to the database.

8. Fast solution to Oracle10g em garbled code

I have never used the 10 Gb em tool. Today I open it and find that there are also long-standing garbled code problems. there are also n solutions circulating on the Internet. Let's take a closer look. In fact, this problem is a good solution.

If the system environment variable is set to a Chinese environment during installation, this problem does not occur. The root cause is that the JDK/JRE character set is automatically selected during installation.

In $ ORACLE_HOME/JDK/JRE/lib and $ ORACLE_HOME/JRE/1.4.2/lib/
The directory contains multiple character set font configuration files:

[Oracle @ danaly ~] $ CD $ ORACLE_HOME/JDK/JRE/lib [Oracle @ danaly
Lib] $ ls font * zh_cn * font. properties. zh_cn.redhat
Font. properties. zh_cn.redhat2.1
Font. properties. zh_cn.sun
Font. properties. zh_cn_utf8.sun
[Oracle @ danaly lib] $ CD $ ORACLE_HOME/JRE/1.4.2/lib/[Oracle @ danaly
Lib] $ ls font * zh_cn * font. properties. zh_cn.redhat
Font. properties. zh_cn.redhat2.1
Font. properties. zh_cn.sun
Font. properties. zh_cn_utf8.sun

We only need to replace the default file with an appropriate Chinese Character Set file. I chose to replace the default font definition file with font. properties. zh_cn.redhat:

[Oracle @ danaly lib] $ CP font. properties. zh_cn.redhat
Font. Properties

After replacement, you need to clear the cache and restart em.

The cache path is usually located:

$ ORACLE_HOME/Solaris/J2EE/oc4j_applications/applications/EM/Cabo/images/Cache/ZHS

Clear all GIF files. Then restart EM:

[Oracle @ danaly ZHS] $ emctl stop dbconsoletz set to prcoracle
Enterprise Manager 10 Gb Database Control Release
10.2.0.1.0 copyright (c) 1996,200 5 Oracle
Corporation. All rights
Reserved. http://danaly.hurrray.com.cn: 1158/EM/console/aboutapplicationstopping

Oracle Enterprise Manager 10 Gb Database Control
... Stopped. [Oracle @ danaly
ZHS] $ emctl start dbconsoletz set to prcoracle Enterprise Manager
10g Database Control Release 10.2.0.1.0 Copyright
(C) 1996,200 5 Oracle Corporation. All rights
Reserved. http://danaly.hurrray.com.cn: 1158/EM/console/aboutapplicationstarting

Oracle Enterprise Manager 10g Database Control ..............
Started.
------------------------------------------------------------------ Logs
Are generated in Directory
/Opt/Oracle/product/10.2.0/danaly.hurrray.com.cn _ danaly/sysman/log

Now log on to the web page, and the EM display will display Chinese normally.