Oracle Portal et al.

  

These are my personal notes that I use as a quick help in my work.
You are welcome to read them.

Contents of current page Top-level home page
 
Index  Java Internet Oracle Notes
Linux Basics Web Basics SQL Notes
Informatica Servlets Apache BkpRstore SQL*Plus
Teradata   LDAP Storage PL/SQL
Windows     Tables OEM
UML Lang.   Net8 Portal
SQL Server Python perl Performance OLAP
Vmware Visual Basic PHP/MySQL User Mgmt  
Git        
More technical pages here

Contents

 

Introduction

  

See some setup information in the Oracle Basics page (scroll down in the installation section)

 

Connections

http://<hostname>:<port>/pls/dad
https://<hostname>:<SSL-port>/pls/dad
Connection to dad (by default: portal); username is portal, password is infrastructure password.
http://<hostname for infrastructure>:<port>/pls/orasso/ORASSO.home
Connection to Single-Sign-On administrations; username is orcladmin, password is infrastructure password.
http://<hostname>:<port>/oiddas
Ldap (OID); use infrastructure port. For full client: oidadmin, user orcladmin.
http://<hostname>:<port>/
Oracle Enterprise Manager Web site: user is ias_admin; default port is 1810. Password is defined during installation.

A farm is a collection of application servers with the same metadata repository. Name: host.domain.com.1521.iasdb.

Infrastructure contains:

The repository for Oracle Enterprise Manager is in file /etc/emtab.
To stop a OEM process on UNIX:
/usr/ucb/ps auxww | grep EMDROOT | grep -v grep
kill <the process number>
Windows: net start Oracle<ORACLE_HOME>EMwebsite

Administer users

Portal: In portal, "Builder", "Administer" tab, "user" portlet

Web OID: connect to http://<hostname>:<port>/oiddas , login as normal user, change password.

OID: "Entry Management", cn=OracleContext, cn=Products, cn=IAS, ...; scroll to the bottom of the properties page to see the userpassword field.

Web OEM: http://<hostname>:<port>/ , choose instance, click on "configure instance" at the bottom of the page.

Default administrator users:

 

Hostname must match the ServerName parameter in httpd.conf file.

Redirection:
Redirect /DADnamepath http://hostname:portnumber/pls/dad

 

URLs:

/pls/portal/url/page/pagegroup/pagename/pagename
/pls/portal/docs/page/pagegroup/pagename/pagename/filename

Stop / Start V2

1. First start listener and database

2. Start OID   

oidmon start
oidctl connect=<db-sid> srever=oidldapd instance=1 start
Start Oracle Internet Directory (see more details)

Start Enterprise Manager Web site

emctl start
Start Enterprise Manager website (see more details)

Start J2EE and Web Cache instance

dcmctl start -cl
Start all application server instances
dcmctl start -ct ohs
Start HTTP server, on both infrastructure and middle tier
dcmctl start -ct oc4j
Start OC4J, on both infrastructure and middle tier
webcachectl start
Start web cache

Start Oracle Management Server and Intelligent Agent (optional)

omsctl start (??)
Start OMS
agentctl start (??)
Start intelligent agent

To stop:

emctl stop
Stop Enterprise Manager website if on middle tier
webcachectl stop
Stop web cache
dcmctl shutdown
Stop HTTP server and OC4J (on both infrastructure and middle tier)
emctl stop
Start Enterprise Manager website (see more details). Stop before stoppeing HTTP server
oidctl srever=oidldapd instance=1 stop
oidmon stop
Start Oracle Internet Directory (see more details)
 

Status

$ORACLE_HOME/bin/emctl status
Enterprise Manager
$ORACLE_HOME/ldap/bin/ldapcheck
Oracle Internet Directory (see more details)
 

Oracle Enterprise Agent:
$ORACLE_HOME/bin/agentctl start agent
agentctl stop agent
agentctl status agent
Windows: net start Oracle<oraclehome>Agent

Oracle Enterprise Managment Server:
oemctl start oms
oemctl stop oms <username/password> (If username/password not provided --> prompt. Default: sysman/oem_temp).
oemctl ping oms
oemctl status oms

Start console: $ORACLE_HOME/bin/oemapp console

 

DCMCTL Command Line Utilisty

DCMCTL command line utility is explained in the 9iAS Administrator's Guide.

Located in ORACLE_HOME/dcm/bin/dcmctl .

dcmctl help
Help
dcmctl getReturnStatus [-verbose]
Status of last command
dcmctl getError [ err-number | err-name ]
Get description of an error. An example of a valid number is 906007; an example of a valid name is ADMN-906007.
dcmctl -a[pplication] app_name
dcmctl -cl[uster] cluster_name
dcmctl -co[mponent] comp_name
dcmctl -{componentType|ct} type
dcmctl -i[nstance] inst_name
Target options
dcmctl -d[ebug]
Print the stack trace in case of exception
dcmctl -l[ogdir] directory
Save the DCM error log file log.xml in the named directory. The directory can be a full pathname or a pathname relative to the current directory. The default directory is ORACLE_HOME/dcm/logs.
dcmctl -o[raclehome] directory
Set the Oracle home. Default where the dcmctl command resides.
dcmctl -t[imeout] num_seconds
Maximum number of seconds to allow for a command to complete. The default is 45 seconds.
dcmctl -v[erbose]
Print long version of state and error messages
dcmctl start
Start the local application server instance only. OPMN and DCM are started if not already executing.
dcmctl start [-cl cluster_name] | [-i instance_name] | [-co component_name] | [ -ct type]
Start the processes indicated. Component types: ohs, oc4j, or opmn (-ct). For all options except the -co and -ct options, OPMN and DCM are started if not already executing.
dcmctl stop
Does not stop OPMN and DCM.
dcmctl stop [-cl cluster_name] | [-i instance_name] | [-co component_name] | [ -ct type]
Stop the processes indicated. Does not stop OPMN and DCM.
dcmctl restart [[-cl cluster_name] | [-i instance_name] | [-co component_name] | [ -ct type]]
Restart the processes indicated. Will leave OPMN and DCM running.
dcmctl shutdown
Stop the local application server instance, including its components, OPMN, and DCM. This command is appropriate to run before a system shutdown.
dcmctl getstate [[-cl cluster_name] | [-i instance_name] | [-co component_name]]
Return the current status of the processes indicated. This command returns a status of "up" or "down" for the indicated process
dcmctl listInstances
Names of instances that belong to the farm but are not part of a cluster.
dcmctl whichInstance
Target instance.
dcmctl destroyInstance -i instance_name
Remove all information related to the instance from the DCM repository. This command can be used if an instance was not deinstalled properly using Oracle Universal Installer.
dcmctl listComponents [[-i instance_name] | [-cl cluster_name]]
List of component instance names.
dcmctl resyncInstance [-force] [-i instance_name]
Resynchronize DCM repository --> local configuration information. Use in case system failure and the instance state is not in sync with the DCM repository. -force option causes resynchronization even if it thinks it is not needed.
 
dcmctl listComponentTypes
List of supported component types : ohs, oc4j, opmn, and jazn.
dcmctl getComponentType -co component_name [-i instance_name ]
Type of the component instance. Put the name between "" if necessary (dcmctl getComponentType -co "HTTP Server" -i ...)
dcmctl createComponent -ct type -co component_name
Create a new component instance. Only oc4j.
dcmctl removeComponent -co component_name
Remove from the local instance. Only oc4j.
dcmctl updateConfig [-ct type [, type]]
Update the DCM repository <-- component configuration files (after manually editing).
saveInstance -dir directory_name
Save the configuration and application information of the current instance to the designated directory, which should be empty (or not exist). Use to save current configuration settings and installed J2EE applications before making configuration changes. You can then back out of the changes, if necessary, using the restoreInstance command.
restoreInstance [-dir directory_name]
Restore the configuration and application information. If no directory is specified, then the instance is restored to the configuration set at install time. This command causes the instance to be shut down. If the instance is a member of a cluster, it is removed from the cluster before the information is restored. RestoreInstance does not effect the configuration of the other members of the cluster.
resetFileTransaction
When using a file-based repository for your application instance, it may leave uncommitted information in the repository if an operation is interrupted (control-C). This command blocks all subsequent updates to the repository, cleans up uncommitted data, and reopens the repository for update.
 

For managing clusters and deploying applications, see the documentation in http://download-uk.oracle.com/docs/cd/A97329_03/core.902/a92171/dcm.htm.

 

EMCTL Command Line Utility

Located in ORACLE_HOME/bin/emctl

emctl start
Start the Enterprise Manager Web site.
emctl stop
Stop (requires ias_admin password).
emctl status
Verify the status
emctl set password new_password
Reset the ias_admin password.
emctl authenticate password
Verify that the supplied password is correct.
emctl ssl test
Enable SSL in a testing environment.
emctl ssl off
Disable SSL in a testing environment.
emctl set ssl password old_password new_password
Set a password to protect an SSL Server Site Certificate. The initial default password is welcome.
emctl gencertrequest
Generate a request for a new SSL Server Site Certificate
emctl installcert -ca certificate_authority_cert_path
Install a Certificate Authority Certificate; use full path.
emctl installcert -cert SSL_server_site_cert_path
Install an SSL Server Site Certificate, use full path.

 

 

 

Other

DCM (Distributed Configuration Management)
Provides a framework to manage configuration of OracleAS. Three pieces: (a) dcmctl, the command-line utility (b) dcm daemon (c) internally used API. OPMN manages the processes whereas DCM manages the configurations. The DCM daemon is started by OPMN. EM works through DCM to change the configurations. The command updateConfig the central repository (but doesn't have everything), while the command resyncInstance updates the configuration files (this is generally done automatically). The related repository is in $ORACLE_HOME/config/ias.properties, under InfrastructureDBCommonName. DCMCTL command line utility is explained in the 9iAS Administrator's Guide; see also section DCMCTL.
OPMN
Process manager(PM) + Oracle notifications system(ONS).
DMS
Dynamic Monitoring Service: performance evaluation and resource monitoring tool.

 

 

 

Tables to look at (V1)

 

Tables in portal30 and portal30_sso

Tables in portal30

 

 

 

E-Business Suite Notes

 

Financials

Start reading the "Oracle Financials Implementation Guide:" 120finig.pdf

 

Tips