Is iSQL Plus running

來源:互聯網
上載者:User
  iSQL *Plus Page
iSQL*Plus is a product independent of Enterprise Manager. The iSQL*Plus user interface runs in a web browser connected to the Internet or your intranet. iSQL*Plus enables you to use a web browser to connect to an Oracle database and perform the same actions as you would through the command line version of SQL*Plus (known as SQL*Plus in this guide). You can use iSQL*Plus to write SQL*Plus, SQL and PL/SQL commands to:

Enter, edit, run and save SQL commands and PL/SQL blocks.

Calculate, and print query results.

You can use the iSQL*Plus Workspace to write, load, save and execute scripts. You can enter scripts as you would in command line SQL*Plus. The script output can be displayed in the Workspace screen or saved to a file on your client machine.

The iSQL *Plus application can be used by two types of users; a database user with NORMAL role and a WebDBA user. For security reasons, if you want to connect as SYSOPER or SYSDBA, you must create and configure a WebDBA user that is HTTP authenticated.

Configuring iSQL *Plus

If you receive an error message page after you click the iSQL *Plus link on the Database Home page, you should check the following:
Is iSQL *Plus configured properly?
For Grid Control, iSQL*Plus will not be shipped with the OMS (Oracle Management Server). So iSQL *Plus needs to be manually configured to point to any running 10G iSQL *Plus server. All the target databases discovered in this Grid Control application will use this iSQL *Plus server for their queries.

For Database Control, the iSQL *Plus installation will automatically configure to use the iSQL *Plus server shipping with this target.

To configure iSQL *Plus, two entries in the $ORACLE_HOME/sysman/config/emoms.properties file on the OMS (Oracle Management Server) machine needs to be populated by replacing the following placeholders: replace %ISQLPLUS_PROTOCOL%, %ISQLPLUS_HOST% and %ISQLPLUS_PORT% with the protocol, the host and the port of the iSql *Plus server you want to use.

For a database user with NORMAL role:
oracle.sysman.db.isqlplusUrl=%ISQLPLUS_PROTOCOL%\://%ISQLPLUS_HOST%\:%ISQLPLUS_PORT%/isqlplus/dynamic

For a database user with SYSOPER and SYSDBA role (requires additional setup for iSQL *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 for all nodes of the cluster must also have these two entries configured.

After configuring the entries, the OMS needs to be restarted to pick up the change.
Is iSQL *Plus running?
If iSQL *Plus is not started, you may start iSQL *Plus using the command:

$ORACLE_HOME/bin/isqlplusctl start
Is iSQL* Plus DBA Access Set up?
If iSQL* Plus is configured properly, the iSQL *Plus Connection Role page prompts you to select the role you want to use to connect to iSQL *Plus -- Normal, SYSOPER (WebDBA) or SYSDBA (WebDBA).

To connect as SYSOPER or SYSDBA, the WebDBA user must be set up and authenticated using the Oracle JAAS Provider, known as JAZN (Java AuthoriZationN). This is Oracle's implementation of the Java Authentication and Authorization Service (JAAS). When iSQL *Plus WebDBA URL is invoked, you must enter a valid JAZN username and password in a dialog to gain access to the iSQL*Plus DBA URL. This username and password may be different to the username and password for your Oracle database instance.

For instructions on how to set up access to iSQL*Plus DBA URL, see the SQL*Plus User's Guide and Reference.

For more information about the jaznadmin setup, see the iSQL*Plus Installation and Configuration guide or go to:

wiggum.ce.columbia.edu:7778/iplus/help/us/toc.htm


相關文章

Beyond APAC's No.1 Cloud

19.6% IaaS Market Share in Asia Pacific - Gartner IT Service report, 2018

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。