BEA WebLogic Server 7 Servisní příručka

Server™BEA WebLogic Server Version 6.1Document Date: June 24, 2002BEA WebLogicAdministration Guide and BEA WebLogic Express™

x WebLogic Server Administration GuideFailover, Cookies, and HTTP Sessions...13-13Failover Behavior Whe

4 Configuring WebLogic Servers and Clusters4-8 Administration GuideClick the View JNDI Tree link and view the tree in the right pane of the Administra

Server Configuration TasksAdministration Guide 4-9Click the Monitor All EJB Deployments link to display the EJB Deployments table.n Deploying Web Appl

4 Configuring WebLogic Servers and Clusters4-10 Administration Guiden Assigning mail sessions to a server using the Server node of the Administration

Cluster Configuration TasksAdministration Guide 4-11displays in the right pane asking you to confirm your deletion request. Click Yes to confirm your

4 Configuring WebLogic Servers and Clusters4-12 Administration Guide

Administration Guide 5-1CHAPTER5 Monitoring a WebLogic Server DomainThe following sections explain how to monitor your WebLogic Server domain:n Overvi

5 Monitoring a WebLogic Server Domain5-2 Administration Guiden Tables of data about all entities of a particular type (such as the WebLogic Servers ta

Monitoring ServersAdministration Guide 5-3You can access monitoring data for each WebLogic server from the monitoring tabs for that server. The Loggin

5 Monitoring a WebLogic Server Domain5-4 Administration GuideMonitoring JDBC Connection PoolsJava Database Connectivity (JDBC) subsystem resources can

Administration Guide 6-1CHAPTER6 Using Log Messages to Manage WebLogic ServersThe following sections describe the functions of the logging subsystem:n

WebLogic Server Administration Guide xiProtecting Passwords... 14-60

6 Using Log Messages to Manage WebLogic Servers6-2 Administration Guiden WebLogic Server component subsystems generate messages that are logged to a l

Overview of Logging SubsystemAdministration Guide 6-3Figure 6-1 WebLogic Server Logging Subsystem

6 Using Log Messages to Manage WebLogic Servers6-4 Administration GuideLocal Server Log FilesIn versions of WebLogic Server prior to 6.0, a new log fi

Local Server Log FilesAdministration Guide 6-5For example, if you enter the following value in the File Name field:myserver_%yyyy%_%MM%_%dd%_%hh%_%mm%

6 Using Log Messages to Manage WebLogic Servers6-6 Administration GuideClient LoggingJava clients that use the WebLogic logging facility may also gene

Message AttributesAdministration Guide 6-7The following is an example of a log message:####<Jun 2, 2000 10:23:02 AM PDT> <Info> <SSL>

6 Using Log Messages to Manage WebLogic Servers6-8 Administration GuideMessage CatalogIn addition to the information contained in a log message, messa

Message SeverityAdministration Guide 6-9Message SeverityWebLogic Server log messages have an attribute called severity which reflects the importance o

6 Using Log Messages to Manage WebLogic Servers6-10 Administration GuideDebug MessagesMessages with a severity of debug are a special case. Debug mess

Creating Domain Log FiltersAdministration Guide 6-11Creating Domain Log FiltersThe log messages forwarded by WebLogic Servers to the domain log are, b

xii WebLogic Server Administration GuideOverview of JDBC Configuration ...16-7When to Use a Tx

6 Using Log Messages to Manage WebLogic Servers6-12 Administration Guide

Administration Guide 7-1CHAPTER7 Deploying ApplicationsThe following sections discuss installation and deployment of applications and application comp

7 Deploying Applications7-2 Administration GuideFor more information about Resource Adaptor components, see Managing the WebLogic J2EE Connector Archi

Using the Administration Console to Deploy ApplicationsAdministration Guide 7-3Step 2: Deploying Application Components.There are three types of compo

7 Deploying Applications7-4 Administration Guide6. The Available field lists Managed Servers (or Clusters if you selected Targets→Clusters). Select th

Using the Administration Console to Deploy ApplicationsAdministration Guide 7-5Deploying Resource Adapter ComponentsTo deploy a resource connector com

7 Deploying Applications7-6 Administration GuideDeployment OrderWithin components of the same type, such as EJBs, you can specify the order in which t

Auto-DeploymentAdministration Guide 7-7n The Managed Server does not have the latest version of the application. The Administration Server maintains a

7 Deploying Applications7-8 Administration Guide-Dweblogic.ProductionModeEnabled=trueIf auto-deployment is enabled for the target WebLogic Server doma

Auto-DeploymentAdministration Guide 7-9Auto-Deployment of Applications in Expanded Directory FormatAn application or application component can be auto

WebLogic Server Administration Guide xiii17.Managing JMSJMS and WebLogic Server...

7 Deploying Applications7-10 Administration GuideRedeployment of Applications Auto-Deployed in Exploded FormatYou can also dynamically redeploy applic

Administration Guide 8-1CHAPTER8 Configuring WebLogic Server Web ComponentsThe following sections discuss how to configure WebLogic Server Web compone

8 Configuring WebLogic Server Web Components8-2 Administration GuideOverviewIn addition to its ability to host dynamic Java-based distributed applicat

HTTP ParametersAdministration Guide 8-3FrontendHTTPPort The frontend HTTP Port is set when the Port information coming from the URL may be inaccurate

8 Configuring WebLogic Server Web Components8-4 Administration GuideHTTPS Duration(labeled Https Keep Alive Secs on the Virtual Host panel)The number

Configuring the Listen PortAdministration Guide 8-5Configuring the Listen PortYou can specify the port that each WebLogic Server listens on for HTTP r

8 Configuring WebLogic Server Web Components8-6 Administration Guidefiles. In addition, a Web Application can access external resources such as EJBs a

Web ApplicationsAdministration Guide 8-7For example, if your Web Application is called shopping, you would use the following URL to access a JSP calle

8 Configuring WebLogic Server Web Components8-8 Administration GuideConfiguring Virtual HostingVirtual hosting allows you to define host names that se

Configuring Virtual HostingAdministration Guide 8-9http://www.mystore.com/shopping/cart.jspIf, however, you declared shopping as the default Web Appli

xiv WebLogic Server Administration GuideAbout the Bridge’s Resource Adapters ...18-3Deploying the Bri

8 Configuring WebLogic Server Web Components8-10 Administration Guideb. Select the Servers tab. You will see a list of available servers.c. Select a s

How WebLogic Server Resolves HTTP RequestsAdministration Guide 8-11How WebLogic Server Resolves HTTP RequestsWhen WebLogic Server receives an HTTP req

8 Configuring WebLogic Server Web Components8-12 Administration Guidehttp://host:port/oranges/navalDoes not matterServlet mapped with <url-pattern&

How WebLogic Server Resolves HTTP RequestsAdministration Guide 8-13http://host:portNo Welcome file* from the default Web Application.http://host:port/

8 Configuring WebLogic Server Web Components8-14 Administration Guide* For more information, see Configuring Welcome Pages at http://e-docs.bea.com/wl

Setting Up HTTP Access LogsAdministration Guide 8-15Setting Up HTTP Access Logs by Using the Administration ConsoleTo set up HTTP access logs use the

8 Configuring WebLogic Server Web Components8-16 Administration Guide7. In Log Rotation Type, select By Size or By Date. l By Size: Rotates the log wh

Setting Up HTTP Access LogsAdministration Guide 8-17auth_userIf the remote client user sent a userid for authentication, the user name; otherwise “-”

8 Configuring WebLogic Server Web Components8-18 Administration GuideCreating the Fields DirectiveThe first line of your log file must contain a direc

Setting Up HTTP Access LogsAdministration Guide 8-19The following identifiers require prefixes, and cannot be used alone. The supported prefix combina

WebLogic Server Administration Guide xvUpdating Deployed Resource Adapters... 20-5Monitoring...

8 Configuring WebLogic Server Web Components8-20 Administration Guide cs-uri-queryOnly the query portion of the URI. This field has type <uri>,

Setting Up HTTP Access LogsAdministration Guide 8-21http://e-docs.bea.com/wls/docs61/javadocs/weblogic/servlet/logging/FormatStringBuffer.html).3. Com

8 Configuring WebLogic Server Web Components8-22 Administration Guideint getResponseContentLength(); javax.servlet.ServletResponse.setContentLength()T

Setting Up HTTP Access LogsAdministration Guide 8-23Enumeration getHeaders(String name); javax.servlet.http.Http.ServletRequestint getIntHeader(String

8 Configuring WebLogic Server Web Components8-24 Administration GuideListing 8-1 Java Class for Creating a Custom ELF Fieldimport weblogic.servlet.l

Setting Up WebLogic Server for HTTP TunnelingAdministration Guide 8-25MaxPostSizeLimits the number of bytes of data received in a POST from a single r

8 Configuring WebLogic Server Web Components8-26 Administration GuideEnable TunnelingEnables or disables HTTP tunneling. HTTP tunneling is disabled by

Using Native I/O for Serving Static Files (Windows Only)Administration Guide 8-27Using Native I/O for Serving Static Files (Windows Only)When running

8 Configuring WebLogic Server Web Components8-28 Administration Guide

Administration Guide 9-1CHAPTER9 Proxying Requests to Another HTTP ServerThe following sections discuss how to proxy HTTP requests to another HTTP ser

xvi WebLogic Server Administration GuideExample... A-17pem2de

9 Proxying Requests to Another HTTP Server9-2 Administration GuideIf you want to proxy requests to a cluster of WebLogic Servers, you can use the Http

Setting Up a Proxy to a Secondary HTTP ServerAdministration Guide 9-3If you are using the new version of HttpProxyServlet, see “Sample web.xml for use

9 Proxying Requests to Another HTTP Server9-4 Administration GuideIf you set the <url-pattern> to “/”, then any request that cannot be resolved

Sample Deployment Descriptor for the Proxy ServletAdministration Guide 9-5<url-pattern>/</url-pattern></servlet-mapping><servlet-

9 Proxying Requests to Another HTTP Server9-6 Administration Guide<init-param><param-name>redirectURL</param-name><param-value>

Administration Guide 10-1CHAPTER10Proxying Requests to a WebLogic ClusterThe following sections discuss how to proxy HTTP requests to a cluster of Web

10 Proxying Requests to a WebLogic Cluster10-2 Administration GuideNew Version of the HttpClusterServlet A new version of the HttpClusterServlet was i

Setting Up the HttpClusterServletAdministration Guide 10-33. Create the web.xml deployment descriptor file for the servlet, under the WEB-INF director

10 Proxying Requests to a WebLogic Cluster10-4 Administration Guide4. In the Administration Console, assign the servlet as the default Web Application

Sample Deployment DescriptorsAdministration Guide 10-5web.xml for HttpClusterServlet SP02This listing before is a sample web.xml for the HttpClusterSe

WebLogic Server Administration Guide xviiCANCEL_SHUTDOWN...B-9Syntax...

10 Proxying Requests to a WebLogic Cluster10-6 Administration Guideweb.xml for Deprecated HttpClusterServlet<!DOCTYPE web-app PUBLIC "-//Sun M

Sample Deployment DescriptorsAdministration Guide 10-7Proxy Servlet Deployment ParametersKey parameters for configuring the behavior of the current ve

10 Proxying Requests to a WebLogic Cluster10-8 Administration GuideTable 10-1 WLS 6.1 SP02 Proxy Servlet Deployment ParametersParameter in WLS 6.1

Sample Deployment DescriptorsAdministration Guide 10-9ConnectRetrySecsInterval in seconds that the the servlet will sleep between attempts to connect

10 Proxying Requests to a WebLogic Cluster10-10 Administration GuidePathTrimString trimmed by the plug-in from the beginning of the original URL, befo

Sample Deployment DescriptorsAdministration Guide 10-11Table 10-2 Parameters for Deprecated Proxy Servlet clientCertProxySpecifies to trust client ce

10 Proxying Requests to a WebLogic Cluster10-12 Administration GuidedefaultServersList of host names and associated plain and SSL listen ports for the

Verifying Your ConfigurationAdministration Guide 10-13Cluster Configuration and Proxy Plug-insTwo WebLogic Server configuration attributes can be set

10 Proxying Requests to a WebLogic Cluster10-14 Administration Guideport is the port number on that server that is listening for HTTP requests, and pl

Administration Guide 11-1CHAPTER11 Installing and Configuring the Apache HTTP Server Plug-InThe following sections describe how to install and configu

xviii WebLogic Server Administration GuideUNLOCK ... B-25Syntax.

11 Installing and Configuring the Apache HTTP Server Plug-In11-2 Administration GuideOverviewThe Apache HTTP Server Plug-In allows requests to be prox

CertificationsAdministration Guide 11-3Keep-Alive Connections in Apache Version 2.xThe Apache HTTP Server Plug-In improves performance by using a reus

11 Installing and Configuring the Apache HTTP Server Plug-In11-4 Administration GuideInstalling the Apache HTTP Server Plug-InYou install the Apache H

Installing the Apache HTTP Server Plug-InAdministration Guide 11-5Choose the appropriate shared object from the following table (note that on the Com

11 Installing and Configuring the Apache HTTP Server Plug-In11-6 Administration GuideIf you are using Compaq OpenVMS, skip to step 5.2. Enable the sha

Installing the Apache HTTP Server Plug-InAdministration Guide 11-73. You install the Apache HTTP Server Plug-In with a support program called apxs (AP

11 Installing and Configuring the Apache HTTP Server Plug-In11-8 Administration Guide<IfModule mod_weblogic.c>WebLogicHost [hostname]WebLogicPor

Installing the Apache HTTP Server Plug-InAdministration Guide 11-9Installing as a Statically Linked ModuleTo install the Apache HTTP Server Plug-In as

11 Installing and Configuring the Apache HTTP Server Plug-In11-10 Administration Guide5. Copy Makefile.libdir, Makefile.tmpl from the lib directory of

Configuring the Apache HTTP Server Plug-InAdministration Guide 11-11Editing the httpd.conf FileTo edit the httpd.conf file to configure the Apache HTT

WebLogic Server Administration Guide xixINVOKE ...B-42Syntax..

11 Installing and Configuring the Apache HTTP Server Plug-In11-12 Administration Guide<IfModule mod_weblogic.c>WebLogicHost myweblogic.server.co

Configuring the Apache HTTP Server Plug-InAdministration Guide 11-13</Location>An alternate way of proxying by path to multiple clusters would b

11 Installing and Configuring the Apache HTTP Server Plug-In11-14 Administration Guide Include conf/weblogic.conf </IfModule>Note: Defining par

Using SSL with the Apache Plug-InAdministration Guide 11-15client-->2-way SSL-->Apache<--1-way SSL<--WebLogic ServerThe Apache HTTP Server

11 Installing and Configuring the Apache HTTP Server Plug-In11-16 Administration Guide WebLogicPort 7001 PathTrim /weblogic</IfModule> The follo

Using SSL with the Apache Plug-InAdministration Guide 11-17 <param-name>clientCertProxy</param-name> <param-value>true

11 Installing and Configuring the Apache HTTP Server Plug-In11-18 Administration GuideConnection Errors and Clustering FailoverWhen the Apache HTTP Se

Connection Errors and Clustering FailoverAdministration Guide 11-19The Dynamic Server ListWhen you specify a list of WebLogic Servers in the WebLogicC

11 Installing and Configuring the Apache HTTP Server Plug-In11-20 Administration GuideFigure 11-1 Connection Failover *The Maximum number of retries

Template for the httpd.conf FileAdministration Guide 11-21Template for the httpd.conf FileThis section contains a sample httpd.conf file. You can use

CopyrightCopyright © 2002 BEA Systems, Inc. All Rights Reserved.Restricted Rights LegendThis software and documentation is subject to and made availab

xx WebLogic Server Administration Guide

11 Installing and Configuring the Apache HTTP Server Plug-In11-22 Administration GuideExample Using WebLogic Clusters# These parameters are common for

Sample Configuration FilesAdministration Guide 11-23Example Configuring IP-Based Virtual HostingNameVirtualHost 172.17.8.1<VirtualHost goldengate.d

11 Installing and Configuring the Apache HTTP Server Plug-In11-24 Administration Guide

Administration Guide 12-1CHAPTER12 Installing and Configuring the Microsoft Internet Information Server (ISAPI) Plug-In The following sections describ

12 Installing and Configuring the Microsoft Internet Information Server (ISAPI) Plug-In12-2 Administration GuideOverview of the Microsoft Internet Inf

Platform SupportAdministration Guide 12-3Proxying RequestsThe plug-in proxies requests to WebLogic Server based on a configuration that you specify. Y

12 Installing and Configuring the Microsoft Internet Information Server (ISAPI) Plug-In12-4 Administration GuideMicrosoft Internet Information Server

Installing the Microsoft Internet Information Server Plug-InAdministration Guide 12-5Note: To avoid out-of-process errors, do not deselect the "C

12 Installing and Configuring the Microsoft Internet Information Server (ISAPI) Plug-In12-6 Administration Guide10. Configure proxying by path. In add

Proxying Multiple Virtual Websites from IISAdministration Guide 12-7Note: The only time you need to use HTTP-tunneling is when you connect through an

Administration Guide xxiAbout This DocumentThis document explains the management subsystem provided for configuring and monitoring your WebLogic Serve

12 Installing and Configuring the Microsoft Internet Information Server (ISAPI) Plug-In12-8 Administration Guidel port is the port number where IIS li

Sample iisproxy.ini FileAdministration Guide 12-9To enable Basic Authentication, in the Directory Security tab of the console, ensure that the Allow A

12 Installing and Configuring the Microsoft Internet Information Server (ISAPI) Plug-In12-10 Administration Guidebetween the Microsoft Internet Inform

Using SSL with the Microsoft Internet Information Server Plug-InAdministration Guide 12-114. Set the SecureProxy parameter in the iisproxy.ini file to

12 Installing and Configuring the Microsoft Internet Information Server (ISAPI) Plug-In12-12 Administration Guide<context-param> <para

Testing the InstallationAdministration Guide 12-13Note: l If the image links called from the servlet are part of the Web Application, you must also pr

12 Installing and Configuring the Microsoft Internet Information Server (ISAPI) Plug-In12-14 Administration GuideConnection Errors and Clustering Fail

Connection Errors and Clustering FailoverAdministration Guide 12-15The Dynamic Server ListWhen you specify a list of WebLogic Servers in the WebLogicC

12 Installing and Configuring the Microsoft Internet Information Server (ISAPI) Plug-In12-16 Administration GuideFigure 12-1 Connection Failover *Th

Administration Guide 13-1CHAPTER13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI) The following sections describe how to in

xxii Administration Guiden Chapter 11, “Installing and Configuring the Apache HTTP Server Plug-In,” explains how to install and configure the WebLogic

13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI)13-2 Administration GuideOverview of the Netscape Enterprise Server Plug-I

CertificationsAdministration Guide 13-3WebLogic Server. If a connection is inactive for more than 30 seconds or a user-defined amount of time, the con

13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI)13-4 Administration Guideare respectively located in the /lib or /bin dire

Modifying the obj.conf FileAdministration Guide 13-5c. To test the Netscape Enterprise Server Plug-In, open a browser and set the URL to the Enterpris

13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI)13-6 Administration GuideWhere NETSCAPE_HOME is the root directory of the

Modifying the obj.conf FileAdministration Guide 13-7The value of the ppath attribute can be any string that identifies requests intended for Weblogic

13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI)13-8 Administration Guide4. If you want to proxy by MIME type, the MIME ty

Using SSL with the NSAPI Plug-InAdministration Guide 13-9fn=wl_proxy WebLogicHost=localhost WebLogicPort=7001\ PathPrepend=/jspfilesPathCheck fn=nt-ur

13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI)13-10 Administration GuideThe WebLogic Server proxy plug-in does not use t

Using SSL with the NSAPI Plug-InAdministration Guide 13-11Specifying Trust of the WL-Proxy-Client-Cert HeaderThe plug-in can encode users’ identity ce

Administration Guide xxiiin Appendix D, “Parameters for Web Server Plug-ins,” discusses the parameters for Web server plug-ins.AudienceThis document i

13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI)13-12 Administration GuideConnection Errors and Clustering FailoverWhen th

Connection Errors and Clustering FailoverAdministration Guide 13-13The Dynamic Server ListWhen you specify a list of WebLogic Servers in the WebLogicC

13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI)13-14 Administration GuideFigure 13-1 Connection Failover *The Maximum n

Failover Behavior When Using Firewalls and Load DirectorsAdministration Guide 13-15Failover Behavior When Using Firewalls and Load Directors In most c

13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI)13-16 Administration GuideSample obj.conf File (Not Using a WebLogic Clust

Sample obj.conf File (Not Using a WebLogic Cluster)Administration Guide 13-17<Object name="si" ppath="*/servletimages/*">Ser

13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI)13-18 Administration GuideSample obj.conf File (Using a WebLogic Cluster)

Sample obj.conf File (Using a WebLogic Cluster)Administration Guide 13-19theirweblogic.com:7001" PathTrim="/weblogic"</Object># H

13 Installing and Configuring the Netscape Enterprise Server Plug-In (NSAPI)13-20 Administration Guide# The following directive enables HTTP-tunneling

Administration Guide 14-1CHAPTER14Managing SecurityThe following sections describe how to implement security in WebLogic Server:n Steps for Configurin

xxiv Administration GuideContact Us!Your feedback on BEA documentation is important to us. Send us e-mail at [email protected] if you have questions

14 Managing Security14-2 Administration GuideSteps for Configuring SecurityImplementing security in a WebLogic Server deployment largely consists of c

Changing the System PasswordAdministration Guide 14-35. Protect the network connection between clients and WebLogic Server by implementing the SSL pro

14 Managing Security14-4 Administration GuideThe password of the system User is encrypted and is further protected when WebLogic Server applies a hash

Specifying a Security RealmAdministration Guide 14-5Maintaining the secrecy of WebLogic passwords is critical to keeping your WebLogic Server deployme

14 Managing Security14-6 Administration GuideUse the Manage Caching Realm button to clear the user, group, and ACL caches.Caution: If the fileRealm.pr

Specifying a Security RealmAdministration Guide 14-7Note: Also make a backup copy of the SerializedSystemIni.dat file for the File realm. For more inf

14 Managing Security14-8 Administration Guidesecurity realm. Reducing the frequency of such calls improves the performance. The trade-off is that chan

Specifying a Security RealmAdministration Guide 14-94. Click Create.5. Configure and enable the ACL cache by defining values for the attributes shown

14 Managing Security14-10 Administration Guide7. To enable and configure the Authentication cache, define values for the attributes shown on the Authe

Specifying a Security RealmAdministration Guide 14-1110. To save your changes, click the Apply button.11. To enable and configure the User cache, defi

Administration Guide xxvmonospace textCode samples, commands and their options, Java classes, data types, directories, and file names and their extens

14 Managing Security14-12 Administration Guide13. To enable and configure the Permission cache, define values for the attribute shown on the Permissio

Specifying a Security RealmAdministration Guide 14-13for BEA customers that are currently using the LDAP security realm in an older release of WebLogi

14 Managing Security14-14 Administration GuideRestrictions When Using the LDAP Security RealmThe LDAP security realm has the following restrictions:n

Specifying a Security RealmAdministration Guide 14-15Locating Users and Groups in the LDAP DirectoryThe LDAP security realm needs to know where the Us

14 Managing Security14-16 Administration GuideThe name of the class that implements the LDAP Security realm is displayed.3. Click Create.4. To enable

Specifying a Security RealmAdministration Guide 14-175. To save your changes, click the Apply button.6. To specify how Users are stored in the LDAP di

14 Managing Security14-18 Administration Guide7. To save your changes, click the Apply button.Table 14-9 LDAP Security Realm Attributes on the Users

Specifying a Security RealmAdministration Guide 14-198. To specify how Groups are stored in the LDAP directory, assign values to the attributes shown

14 Managing Security14-20 Administration Guide13. Choose the Filerealm tab.14. In the Caching Realm attribute, choose the name of the Caching Realm to

Specifying a Security RealmAdministration Guide 14-212. Choose the LDAP server you want to use with WebLogic Server. The following options are availab

xxvi Administration Guide...Indicates the omission of items from a code example or from a syntax line. Convention Usage

14 Managing Security14-22 Administration GuideNote: When using the LDAP v2 realm for Microsoft Site server, you must also specify membership.search=tr

Specifying a Security RealmAdministration Guide 14-23ConfigurationData="server.host=ldapserver.example.com;server.port=700;useSSL=true;server.pri

14 Managing Security14-24 Administration GuideListing 14-3 Default Novell Directory Services Template<CustomRealmName="defaultLDAPRealmForNo

Specifying a Security RealmAdministration Guide 14-25Using Microsoft Active Directory with WebLogic ServerBy default, WebLogic Server does not support

14 Managing Security14-26 Administration Guideignore accounts that have been disable. Modify the user.filter value to only return accounts that do not

Specifying a Security RealmAdministration Guide 14-27your ACLs, you can reduce the frequency with which you must refresh the information in WebLogic S

14 Managing Security14-28 Administration Guide6. Configure the Caching realm. For more information, see “Configuring the Caching Realm.”Note: When you

Specifying a Security RealmAdministration Guide 14-29If the test comes up with an immediate failure stating that the client or user running WebLogic S

14 Managing Security14-30 Administration Guide5. Verify that the Windows user running WebLogic Server is a member of the Administrators group.6. Reboo

Specifying a Security RealmAdministration Guide 14-31In UNIX, a user is defined as a member of a group in the following ways:n The user is defined in

Administration Guide 1-1CHAPTER1 Overview of WebLogic Server ManagementThe following sections describe the tools available to manage WebLogic Server:n

14 Managing Security14-32 Administration Guide4. To save your changes, click the Apply button. 5. When you have finished defining the attributes, rebo

Specifying a Security RealmAdministration Guide 14-33-Dweblogic.security.unixrealm.authProgram=wlauth_progReplace wlauth_prog with the name of the wla

14 Managing Security14-34 Administration GuideThe RDBMS Security realm can be used as a starting point for creating a production security realm. You c

Specifying a Security RealmAdministration Guide 14-355. Define attributes for the JDBC driver being used to connect to the database. The following tab

14 Managing Security14-36 Administration GuidenewUser=INSERT INTO users VALUES ( ? , ? );addGroupMember=INSERT INTO groupmembers VALUES ( ? , ? );remo

Specifying a Security RealmAdministration Guide 14-37Installing a Custom Security RealmYou can create a custom security realm that draws from an exist

14 Managing Security14-38 Administration Guide6. Configure the Caching realm. For more information, see “Configuring the Caching Realm.”Note: When you

Defining UsersAdministration Guide 14-39n If you are using a custom security realm, follow the steps in “Installing a Custom Security Realm” to specif

14 Managing Security14-40 Administration GuideUsers are entities that can be authenticated in a WebLogic Server security realm. A User can be a person

Defining UsersAdministration Guide 14-41n To execute an operation on a WebLogic Server resource, they must provide a username and password (or digital

1 Overview of WebLogic Server Management1-2 Administration GuideDomains, the Administration Server and Managed ServersAn inter-related set of WebLogic

14 Managing Security14-42 Administration GuideFor more information about Users and the access control model in WebLogic Server, see Introduction to We

Defining ACLsAdministration Guide 14-433. Enter the name of the Group in the Name attribute on the Group Configuration window. BEA recommends naming G

14 Managing Security14-44 Administration GuideTable 14-16 ACLs for WebLogic Server ResourcesFor this WebLogic Server resource...This ACL... Grants Pe

Defining ACLsAdministration Guide 14-45Note: When you specify an ACL for a JDBC connection pool, you must specifically define access to the JDBC conne

14 Managing Security14-46 Administration GuideBefore you can boot WebLogic Server, you need to give boot permission for the server to a specific Group

Configuring the SSL ProtocolAdministration Guide 14-47Obtaining a Private Key and Digital CertificateYou need a private key and digital certificate fo

14 Managing Security14-48 Administration GuideTable 14-17 Fields on the Certificate Request Generator FormField DescriptionCountry code Two-letter IS

Configuring the SSL ProtocolAdministration Guide 14-494. Click the Generate Request button.The Certificate Request Generator servlet displays messages

14 Managing Security14-50 Administration Guide6. When you are instructed to select a server type, choose BEA WebLogic Server to ensure that you receiv

Configuring the SSL ProtocolAdministration Guide 14-51 -----BEGIN ENCRYPTED PRIVATE KEY----- -----END ENCRYPTED PRIVATE KEY-----A PEM(.pem) format d

Domains, the Administration Server and Managed ServersAdministration Guide 1-3In a domain with multiple WebLogic Servers, only one server is the Admin

14 Managing Security14-52 Administration GuideCopy the root certificate of the certificate authority into the \wlserver6.1\config\ directory of your W

Configuring the SSL ProtocolAdministration Guide 14-53Table 14-18 SSL Protocol AttributesAttribute DescriptionEnabled Enables the use of the SSL prot

14 Managing Security14-54 Administration GuideServer Certificate Chain File NameFull directory location of the digital certificate used to sign the di

Configuring the SSL ProtocolAdministration Guide 14-55Key Encrypted Specifies that the private key for WebLogic Server is encrypted with a password. T

14 Managing Security14-56 Administration GuideNote: In previous releases of WebLogic Server, it was possible to define digital certificates that were

Configuring the SSL ProtocolAdministration Guide 14-57Using PKCS#7 FilesPKCS#7 files can be used with WebLogic Server. However, the certificate chain

14 Managing Security14-58 Administration Guide9. Click Next.10. Enter a name for the converted digital certificate.11. Click Finish.The resulting file

Configuring Mutual AuthenticationAdministration Guide 14-59Configuring Mutual AuthenticationWhen WebLogic Server is configured for mutual authenticati

14 Managing Security14-60 Administration Guide1. Configure WebLogic Server to use the SSL protocol. For more information, see Defining Attributes for

Protecting PasswordsAdministration Guide 14-61n Set the permissions on the SerializedSystemIni.dat file protections such that the administrator of the

WebLogic Server Administration Guide iiiContentsAbout This DocumentAudience...

1 Overview of WebLogic Server Management1-4 Administration GuideAdministration ConsoleThe Administration Console is a JSP-based application hosted by

14 Managing Security14-62 Administration GuideTable 14-20 Password Protection AttributesAttribute DescriptionMinimum Password Length Number of charac

Installing an Audit ProviderAdministration Guide 14-63Installing an Audit ProviderWebLogic Server enables you to create an audit provider to receive a

14 Managing Security14-64 Administration GuideInstalling a Connection FilterYou can create connection filters that allow you to reject or accept clien

Setting Up the Java Security ManagerAdministration Guide 14-65Note: In pre-6.0 releases of WebLogic Server, you enabled the Java Security Manager by u

14 Managing Security14-66 Administration Guide3. If you have extra directories in your CLASSPATH or if you are deploying applications in extra directo

Modifying the weblogic.policy File for Third Party or User-Written ClassesAdministration Guide 14-67Modifying the weblogic.policy File for Third Party

14 Managing Security14-68 Administration Guideis trailed with “/-” it means that the element preceding it is a directory and that grant functions for

Configuring Security Context PropagationAdministration Guide 14-69WebLogic Server environment obtain IIOP connections from a WLEC connection pool and

14 Managing Security14-70 Administration Guide4. Click the Create button.5. Propagate the security context for a User in a WebLogic Server security re

Configuring Security Context PropagationAdministration Guide 14-716. To save your changes, click the Apply button and reboot WebLogic Server.7. Run th

Administration ConsoleAdministration Guide 1-5The value of hostname is the DNS name or IP address of the Administration Server and port is the address

14 Managing Security14-72 Administration Guide8. Set the -E option of the ISL command to configure the IIOP Listener/Handler to detect and utilize the

SSL Certificate ValidationAdministration Guide 14-73SSL Certificate ValidationIn previous releases, WebLogic Server did not ensure each certificate in

14 Managing Security14-74 Administration Guide%WL_HOME%\server\lib\cacerts%WL_HOME%\server\lib\demo.crt%WL_HOME%\server\lib\trusted.crtGenerally these

SSL Certificate ValidationAdministration Guide 14-75If you only have the end entity certificate, you can also tell whether it is old or new by looking

14 Managing Security14-76 Administration GuideControlling the Level of Certificate ValidationBy default WebLogic Server will reject any certificates i

SSL Certificate ValidationAdministration Guide 14-77Table 14-23 describes the options for the command-line argument.Table 14-23 Options for -Dweblogi

14 Managing Security14-78 Administration GuideChecking Certificate ChainsWebLogic Server provides a ValidateCertChain command-line utility to check wh

SSL Certificate ValidationAdministration Guide 14-79Troubleshooting Problems with CertificatesIf SSL communications were working before the patch but

14 Managing Security14-80 Administration Guide

Administration Guide 15-1CHAPTER15Managing Transactions These sections discuss transaction management and provide guidelines for configuring and manag

1 Overview of WebLogic Server Management1-6 Administration GuideRun-time and Configuration ObjectsThe Administration Server is populated with JavaBean

15 Managing Transactions15-2 Administration GuideBefore configuring your transaction environment, you should be familiar with the J2EE components that

Configuring TransactionsAdministration Guide 15-31. Start the Administration Console.2. Select the domain node in the left pane. The Configuration tab

15 Managing Transactions15-4 Administration GuideAdditional Attributes for Managing TransactionsBy default, if an XA resource that is participating in

Additional Attributes for Managing TransactionsAdministration Guide 15-5You set these attributes directly in the config.xml file when the domain is in

15 Managing Transactions15-6 Administration Guide EnableResourceHealthMonitoring="true" Properties="user=scott;password=tiger;server=

Moving a Server to Another MachineAdministration Guide 15-7For detailed information on monitoring and logging values and attributes, see the Server to

15 Managing Transactions15-8 Administration Guide

Administration Guide 16-1CHAPTER16Managing JDBC ConnectivityThe following sections provide guidelines for configuring and managing database connectivi

16 Managing JDBC Connectivity16-2 Administration GuideFrequently performed tasks to set and manage connectivity include:n Defining the attributes that

Overview of JDBC AdministrationAdministration Guide 16-3Related InformationThe JDBC drivers, used locally and in distributed transactions, interface w

Central Point of Access to Log MessagesAdministration Guide 1-7Figure 1-1 WebLogic Server Management SubsystemCentral Point of Access to Log Message

16 Managing JDBC Connectivity16-4 Administration GuideTransactions (JTA)n For information on managing JTA, see Chapter 15, “Managing Transactions.”n F

JDBC Components—Connection Pools, Data Sources, and MultiPoolsAdministration Guide 16-5Figure 16-1 JDBC Components in WebLogic ServerConnection Pool

16 Managing JDBC Connectivity16-6 Administration GuideMultiPoolsMultiPools aid in either:n Load Balancing—pools are added without any attached orderin

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSourcesAdministration Guide 16-7JDBC Configuration Guidelines for Connection Po

16 Managing JDBC Connectivity16-8 Administration GuideThe following table describes how to use these objects in local and distributed transactions:Not

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSourcesAdministration Guide 16-9n Use the Java Transaction API (JTA)n Use the E

16 Managing JDBC Connectivity16-10 Administration Guidejavax.transaction.xa.XAResource), including the WebLogic jDriver for Oracle/XA. n Any JDBC driv

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSourcesAdministration Guide 16-11Note: New Property: "Password." This

16 Managing JDBC Connectivity16-12 Administration GuideThe following table shows a sample Connection Pool configuration using the WebLogic jDriver for

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSourcesAdministration Guide 16-13The following table shows a sample Connection

1 Overview of WebLogic Server Management1-8 Administration Guidewhich messages to forward by providing a filter that selects messages of interest. A m

16 Managing JDBC Connectivity16-14 Administration GuideConfiguring XA JDBC Drivers for Distributed TransactionsTo allow XA JDBC drivers to participate

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSourcesAdministration Guide 16-15The following attributes are an example of a T

16 Managing JDBC Connectivity16-16 Administration GuideThe following attributes are an example of a Tx Data Source configuration using the Oracle Thin

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSourcesAdministration Guide 16-17Configure the Tx Data Source for use with a Cl

16 Managing JDBC Connectivity16-18 Administration GuideThe Optional column indicates whether a particular data source property is optional or not. Pro

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSourcesAdministration Guide 16-19Table 16-15 lists the mapping between Oracle’s

16 Managing JDBC Connectivity16-20 Administration GuideAdditional XA Connection Pool PropertiesWhen using connections from a connection pool in distri

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSourcesAdministration Guide 16-21Non-XA Driver/Single ResourceIf you are using

16 Managing JDBC Connectivity16-22 Administration GuideHeuristic Completions and Data InconsistencyWhen Enable Two-Phase Commit is selected for a non-

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSourcesAdministration Guide 16-23Only One Non-XA ParticipantWhen a non-XA resou

Creating a New DomainAdministration Guide 1-9http://hostname:port/consolewhere hostname is the name of the machine where you started the Administratio

16 Managing JDBC Connectivity16-24 Administration GuideThe following table shows configuration attributes for a sample Tx Data Source using a non-XA J

Configuring and Managing JDBC Connection Pools, MultiPools, and DataSources Us-Administration Guide 16-25Creating the JDBC Objects Using the Administr

16 Managing JDBC Connectivity16-26 Administration GuideRefer to the following table for more information on association and assignment in the configur

Configuring and Managing JDBC Connection Pools, MultiPools, and DataSources Us-Administration Guide 16-27Configuring JDBC Connectivity Using the Admin

16 Managing JDBC Connectivity16-28 Administration GuideDatabase Passwords in Connection Pool ConfigurationWhen you create a connection pool, you typic

Configuring and Managing JDBC Connection Pools, MultiPools, and DataSources Us-Administration Guide 16-29openString=Oracle_XA+Acc=P/userName/+SesTm=17

16 Managing JDBC Connectivity16-30 Administration GuideManaging and Monitoring ConnectivityManaging connectivity includes enabling, disabling, and del

Configuring and Managing JDBC Connection Pools, MultiPools, and DataSources Us-Administration Guide 16-31JDBC Management Using the Command-Line Interf

16 Managing JDBC Connectivity16-32 Administration GuideIncreasing Performance with the Prepared Statement CacheFor each connection pool that you creat

Increasing Performance with the Prepared Statement CacheAdministration Guide 16-33http://e-docs.bea.com/wls/docs61/javadocs/weblogic/management/config

1 Overview of WebLogic Server Management1-10 Administration Guide10. At the end of the start script there is a cd command:cd config\mydomainReplace my

16 Managing JDBC Connectivity16-34 Administration Guidestatement such as select * from emp and then drop and recreate the emp table, the next time you

Increasing Performance with the Prepared Statement CacheAdministration Guide 16-35Determining the Proper Prepared Statement Cache SizeTo determine the

16 Managing JDBC Connectivity16-36 Administration GuideIf you enable the connection pool to grow as demand for connections increases, new connections

Administration Guide 17-1CHAPTER17Managing JMSThe following sections explain how to manage the Java Message Service (JMS) for WebLogic Server:n JMS an

17 Managing JMS17-2 Administration GuideFigure 17-1 WebLogic Server JMS MessagingAs illustrated in the figure, WebLogic JMS accepts messages from pr

Configuring JMSAdministration Guide 17-3When you migrate WebLogic Server applications from a previous release, the configuration information will be c

17 Managing JMS17-4 Administration GuideStarting the Default WebLogic ServerThe default role for a WebLogic Server is the Administration Server. If a

Configuring JMSAdministration Guide 17-5b. Click the Connection Pools node in the left pane, and then click the Configure a new JDBC Connection Pool l

17 Managing JMS17-6 Administration Guidec. Fill in the Thresholds & Quotas tab, as appropriate. Click Apply when you’re done making changes. d. On

Configuring JMSAdministration Guide 17-7Note: For more information on configuring a Connection Factory, see “Configuring Connection Factories” on page

Administration Guide 2-1CHAPTER2 Starting and Stopping WebLogic ServersThe following sections describe procedures for starting and stopping Administra

17 Managing JMS17-8 Administration Guiden Target a WebLogic Server instance that is associated with a JMS server. When the target WebLogic Server boot

Configuring JMSAdministration Guide 17-9l Maximum number of outstanding messages that may exist for an asynchronous session and the overrun policy (th

17 Managing JMS17-10 Administration GuideConfiguring DestinationsA destination identifies a queue (Point-To-Point) or a topic (Pub/Sub) for a JMS serv

Configuring JMSAdministration Guide 17-11Configuring JMS TemplatesA JMS template provides an efficient means of defining multiple destinations with si

17 Managing JMS17-12 Administration GuideFor instructions on creating and configuring a JMS template, see “JMS Templates” in the Administration Consol

Configuring JMSAdministration Guide 17-13Warning: You cannot configure a transaction (XA) connection pool to be used with a JDBC database store For mo

17 Managing JMS17-14 Administration GuideNote: The JMS samples provided with your WebLogic Server distribution are set up to work with the Cloudscape

Configuring JMSAdministration Guide 17-15n <prefix>JMSStoren <prefix>JMSStateThe prefix name uniquely identifies JMS tables in the persist

17 Managing JMS17-16 Administration GuideConfiguring Session PoolsServer session pools enable an application to process messages concurrently. After y

Monitoring JMSAdministration Guide 17-17n JMS selector expression used to filter messages. For information about defining selectors, see Developing a

2 Starting and Stopping WebLogic Servers2-2 Administration GuideAdministration Server for the domain. Additional WebLogic Servers in the domain are ma

17 Managing JMS17-18 Administration Guide5. Select the Monitoring tab to display the monitoring data.For detailed information about the information be

Tuning JMSAdministration Guide 17-19Persistent StoresThe following sections describe the tuning options available when using persistent stores with We

17 Managing JMS17-20 Administration GuideJMS message paging saves memory for both persistent and non-persistent messages, as even persistent messages

Tuning JMSAdministration Guide 17-21Configuring a Paging Store for a JMS ServerEach JMS server must have its own paging store, which is used exclusive

17 Managing JMS17-22 Administration Guidel In the Bytes Threshold High field, enter an amount that will start bytes paging when the number of bytes on

Tuning JMSAdministration Guide 17-233. Click the template that you want to configure for paging. The right pane shows the tabs associated with configu

17 Managing JMS17-24 Administration Guide4. On the Thresholds & Quotas tab, configure bytes paging:l Select the Bytes Paging Enabled check box.l I

Tuning JMSAdministration Guide 17-253. Click the topic or queue that you want to configure for paging. The right pane shows the topics or queues assoc

17 Managing JMS17-26 Administration GuideJMS Server Paging AttributesTable 17-1 describes the paging attributes that you define when configuring pagin

Tuning JMSAdministration Guide 17-27JMS Template Paging AttributesTable 17-3 describes the paging attributes that you define when configuring paging o

Starting the WebLogic Administration ServerAdministration Guide 2-3Failover Considerations for the Administration ServerBecause the Administration Ser

17 Managing JMS17-28 Administration GuideMessages Paging Enabled n If the Messages Paging Enabled check box is not selected (False), then destination-

Tuning JMSAdministration Guide 17-29JMS Destination Paging AttributesTable 17-3 describes the attributes that you define when configuring paging on de

17 Managing JMS17-30 Administration GuideNote: If server paging is enabled, and destination-level paging is disabled for a given destination, than mes

Recovering from a WebLogic Server FailureAdministration Guide 17-31Recovering from a WebLogic Server FailureThe following sections describe how to res

17 Managing JMS17-32 Administration GuideNote: JMS persistent stores can increase the amount of memory required during initialization of WebLogic Serv

Recovering from a WebLogic Server FailureAdministration Guide 17-33Programming ConsiderationsYou may want to program your JMS application to terminate

17 Managing JMS17-34 Administration Guide

Administration Guide 18-1CHAPTER18Using the WebLogic Messaging BridgeThe following sections explain how to configure and manage a WebLogic Messaging

18 Using the WebLogic Messaging Bridge18-2 Administration Guiden WebLogic JMS with a third-party JMS product (for example, MQSeries).n WebLogic JMS wi

Messaging Bridge Configuration TasksAdministration Guide 18-3About the Bridge’s Resource AdaptersA messaging bridge uses resource adapters to communic

iv WebLogic Server Administration Guide2-13Restarting the Administration Server on the Same Machine ...2-14Restarting the Administration Serv

2 Starting and Stopping WebLogic Servers2-4 Administration GuideNote: When starting WebLogic Server, JDK 1.3 may throw an OutOfMemory error if you are

18 Using the WebLogic Messaging Bridge18-4 Administration GuideThe supported adapters are located in the WL_HOME\lib directory and are described in th

Messaging Bridge Configuration TasksAdministration Guide 18-5You will specify the appropriate adapter by its JNDI name when you configure each source

18 Using the WebLogic Messaging Bridge18-6 Administration GuideNote: When configuring a messaging bridge to interoperate between WebLogic Server relea

Messaging Bridge Configuration TasksAdministration Guide 18-7You need to configure a JMSBridgeDestination instance for each actual source and target J

18 Using the WebLogic Messaging Bridge18-8 Administration Guide5. Click Create to create the JMS bridge destination.Adapter Classpath When connecting

Messaging Bridge Configuration TasksAdministration Guide 18-96. When you finish defining attributes for a source JMS bridge destination, repeat these

18 Using the WebLogic Messaging Bridge18-10 Administration GuideTable 18-3 General Bridge Destination Attributes on the Configuration TabAttribute De

Messaging Bridge Configuration TasksAdministration Guide 18-115. Click Create to create the general bridge destination.6. When you finish defining att

18 Using the WebLogic Messaging Bridge18-12 Administration GuideConfiguring a Messaging Bridge InstanceA messaging bridge instance communicates with t

Messaging Bridge Configuration TasksAdministration Guide 18-13Target Destination Select the target destination to which messages are sent from the mes

Starting the WebLogic Administration ServerAdministration Guide 2-5Invoking the WebLogic Server from the Start menu executes the start script startWeb

18 Using the WebLogic Messaging Bridge18-14 Administration GuideQOS Degradation Allowed When selected, the messaging bridge automatically degrades the

Messaging Bridge Configuration TasksAdministration Guide 18-155. Click Create to create the messaging bridge. 6. On the Connection Retry tab, define t

18 Using the WebLogic Messaging Bridge18-16 Administration GuideThe source and target destinations for a messaging bridge will not always be available

Messaging Bridge Configuration TasksAdministration Guide 18-179. Click Apply to store new attribute values. 10. On the Targets tab, assign WebLogic Se

18 Using the WebLogic Messaging Bridge18-18 Administration GuideUsing the Messaging Bridge to Interoperate with Different WebLogic Server Versions and

Using the Messaging Bridge to Interoperate with Different WebLogic Server VersionsAdministration Guide 18-19n If a JMS file store is being used for pe

18 Using the WebLogic Messaging Bridge18-20 Administration GuideUsing the Messaging Bridge To Access Destinations In a Release 6.1 or Later DomainUse

Using the Messaging Bridge to Interoperate with Different WebLogic Server VersionsAdministration Guide 18-21n On the Messaging Bridge → Configuration

18 Using the WebLogic Messaging Bridge18-22 Administration GuideUsing the Messaging Bridging To Access Destinations In a Release 5.1 DomainWhen config

Bridging to a Third-Party Messaging ProviderAdministration Guide 18-23Note: If your implementation is using a 5.1 Service Pack, the corresponding sp.

2 Starting and Stopping WebLogic Servers2-6 Administration GuideStarting the WebLogic Administration Server from the Command LineThe WebLogic Server i

18 Using the WebLogic Messaging Bridge18-24 Administration Guidethat is using the XA resource of the resource manager). For example, when using MQ Ser

Managing a Messaging BridgeAdministration Guide 18-25Managing a Messaging BridgeOnce a messaging bridge is up and running, it can managed from the Adm

18 Using the WebLogic Messaging Bridge18-26 Administration Guide5. Click the Monitoring all Messaging Bridge Runtimes text link to display the monitor

Administration Guide 19-1CHAPTER19Managing JNDIThe following sections describe how to manage JNDI:n “Overview of JNDI Management” on page 19-1n “Viewi

19 Managing JNDI19-2 Administration GuideViewing the JNDI TreeTo view the objects in the WebLogic Server JNDI tree for a specific server, do the follo

Administration Guide 19-3

19 Managing JNDI19-4 Administration Guide

Administration Guide 20-1CHAPTER20Managing the WebLogic J2EE Connector ArchitectureBased on the Sun Microsystems J2EE Connector Specification, Version

20 Managing the WebLogic J2EE Connector Architecture20-2 Administration GuideOverview of WebLogic J2EE Connector ArchitectureBEA WebLogic Server conti

Installing a New Resource AdapterAdministration Guide 20-3Installing a New Resource AdapterThis section discusses how to connect a new connector (reso

Starting the WebLogic Administration ServerAdministration Guide 2-7machine) or start Managed Servers remotely using the Node Manager, you need to set

20 Managing the WebLogic J2EE Connector Architecture20-4 Administration Guide1. Start WebLogic Server.2. Open the Administration Console.3. Open the D

Configuring and Deploying a New ConnectorAdministration Guide 20-5Undeploying Deployed Resource AdaptersTo undeploy a deployed connector from the WebL

20 Managing the WebLogic J2EE Connector Architecture20-6 Administration GuideMonitoringTo monitor all connection pool run times for a connector, proce

Editing Resource Adapter Deployment DescriptorsAdministration Guide 20-7Editing Resource Adapter Deployment DescriptorsThis section describes the proc

20 Managing the WebLogic J2EE Connector Architecture20-8 Administration Guide6. To edit an existing element in one of the resource adapter deployment

Administration Guide 21-1CHAPTER21Managing WebLogic Server LicensesYour WebLogic Server requires a valid license to run. The following sections explai

21 Managing WebLogic Server Licenses21-2 Administration GuideUpdating a LicenseYou will need to update the BEA license file if one of the following is

Administration Guide A-1APPENDIXA Using the WebLogic Java UtilitiesWebLogic provides several Java programs that simplify installation and configuratio

A Using the WebLogic Java UtilitiesA-2 Administration GuideTo use these utilities you must correctly set your CLASSPATH. For more information, see “Se

Administration Guide A-3ClientDeployerYou use weblogic.ClientDeployer to extract the client-side JAR file from a J2EE EAR file, creating a deployable

2 Starting and Stopping WebLogic Servers2-8 Administration GuideNote: Secure a plain text copy of the private key password before you allow WebLogic S

A Using the WebLogic Java UtilitiesA-4 Administration Guideder2pemThe der2pem utility converts an X509 certificate from DER format to PEM format. The

Administration Guide A-5dbpingThe dbping command-line utility tests the connection between a DBMS and your client machine via a JDBC driver. You must

A Using the WebLogic Java UtilitiesA-6 Administration GuideDBName of the database. Use the following format, depending on which JDBC driver you use:We

Administration Guide A-7deployThe deploy utility gets a J2EE application from an archive file (.jar, .war, or .ear) and deploys the J2EE application t

A Using the WebLogic Java UtilitiesA-8 Administration GuideOther Required ArgumentsArgument DescriptionpasswordSpecifies the system password for the W

Administration Guide A-9OptionsOption Definition-component componentname:target1, target2Component to be deployed on various targets, must be specifie

A Using the WebLogic Java UtilitiesA-10 Administration GuideExamplesThe deploy utility is useful for various purposes, including the following:n Viewi

Administration Guide A-11n Removing a Deployed J2EE Applicationn Updating a Deployed J2EE ApplicationViewing a Deployed J2EE ApplicationTo view an app

A Using the WebLogic Java UtilitiesA-12 Administration GuideRemoving a Deployed J2EE ApplicationTo remove a deployed J2EE application, you need only r

Administration Guide A-13getPropertyThe getProperty utility gives you details about your Java setup and your system. It takes no arguments.Syntax$ jav

Starting the WebLogic Administration ServerAdministration Guide 2-9where domain_name is the name of the domain. This will also be the subdirectory whi

A Using the WebLogic Java UtilitiesA-14 Administration GuidelogToZipThe logToZip utility searches an HTTP server log file in common log format, finds

Administration Guide A-15MulticastTestThe MulticastTest utility helps you debug multicast problems when configuring a WebLogic Cluster. The utility se

A Using the WebLogic Java UtilitiesA-16 Administration GuideExample$ java utils.MulticastTest -N server100 -A 237.155.155.1Set up to send and receive

Administration Guide A-17myipThe myip utility returns the IP address of the host. Syntax$ java utils.myipExample$ java utils.myipHost toyboat.toybox.c

A Using the WebLogic Java UtilitiesA-18 Administration Guidepem2derThe pem2der utility converts an X509 certificate from PEM format to DER format. The

Administration Guide A-19SchemaThe Schema utility lets you upload SQL statements to a database using the WebLogic JDBC drivers. For additional informa

A Using the WebLogic Java UtilitiesA-20 Administration Guide (tablename varchar(32), maxkey int);

Administration Guide A-21showLicensesThe showLicenses utility displays license information about BEA products installed in this machine.Syntax$ java -

A Using the WebLogic Java UtilitiesA-22 Administration GuidesystemThe system utility displays basic information about your computer’s operating enviro

Administration Guide A-23t3dbpingThe t3dbping utility tests a WebLogic JDBC connection to a DBMS via any two-tier JDBC driver. You must have access to

2 Starting and Stopping WebLogic Servers2-10 Administration GuideAppManager thread that polls the applications directory for changes is only created o

A Using the WebLogic Java UtilitiesA-24 Administration Guide verboseToZipWhen executed from the document root directory of your HTTP server, verboseTo

Administration Guide A-25versionThe version utility displays version information about your installed WebLogic via stdout. Syntax$ java weblogic.Admin

A Using the WebLogic Java UtilitiesA-26 Administration GuidewriteLicenseThe writeLicense utility writes information about all your WebLogic licenses i

Administration Guide A-27Example of Windows NT Output* * * * * * * os.name * * * * * * * Windows NT* * * * * * * os.arch * * * * * * * x86* * * * * *

A Using the WebLogic Java UtilitiesA-28 Administration Guide

Administration Guide B-1APPENDIXB WebLogic Server Command-Line Interface ReferenceThe following sections discuss the WebLogic Server command-line inte

B WebLogic Server Command-Line Interface ReferenceB-2 Administration Guiden You want to create scripts for administration and management efficiency.n

Using WebLogic Server CommandsAdministration Guide B-3Using WebLogic Server CommandsThis section presents the syntax and required arguments for using

B WebLogic Server Command-Line Interface ReferenceB-4 Administration GuideNote: The exit code for all commands is 1 if the Administration client canno

Using WebLogic Server CommandsAdministration Guide B-5In a development environment in which security is not a top priority, you can use the -username

Starting the WebLogic Administration ServerAdministration Guide 2-11A Server’s Root DirectoryAll instances of WebLogic Server use a root directory to

B WebLogic Server Command-Line Interface ReferenceB-6 Administration GuideExamples of Providing User CredentialsThe following command specifies the us

WebLogic Server Administration Command ReferenceAdministration Guide B-7Connect to WebLogic ServerCONNECTMakes the specified number of connections to

B WebLogic Server Command-Line Interface ReferenceB-8 Administration GuideNote: The exit code for all commands is 1 if the Administration client canno

WebLogic Server Administration Command ReferenceAdministration Guide B-9CANCEL_SHUTDOWNThe CANCEL_SHUTDOWN command cancels the SHUTDOWN command for a

B WebLogic Server Command-Line Interface ReferenceB-10 Administration GuideCONNECTMakes the specified number of connections to the WebLogic Server and

WebLogic Server Administration Command ReferenceAdministration Guide B-11HELPProvides syntax and usage information for all WebLogic Server commands (

B WebLogic Server Command-Line Interface ReferenceB-12 Administration GuideLICENSES Lists the licenses for all WebLogic Server instances installed on

WebLogic Server Administration Command ReferenceAdministration Guide B-13LISTLists the bindings of a node in the JNDI naming tree. Syntaxjava weblogic

B WebLogic Server Command-Line Interface ReferenceB-14 Administration GuideLOCKLocks a WebLogic Server against non-privileged logins. Any subsequent l

WebLogic Server Administration Command ReferenceAdministration Guide B-15PINGSends a message to verify that a WebLogic Server is listening on a port,

2 Starting and Stopping WebLogic Servers2-12 Administration GuideBut c:\MyManagedRootDir is not.By convention, the root directory for an Administratio

B WebLogic Server Command-Line Interface ReferenceB-16 Administration GuideSERVERLOGDisplays the log file generated on a specific server.n If you do n

WebLogic Server Administration Command ReferenceAdministration Guide B-17SHUTDOWNShuts down the WebLogic Server that is specified in the URL.Syntax ja

B WebLogic Server Command-Line Interface ReferenceB-18 Administration GuideSTOREUSERCONFIGCreates a user-configuration file and an associated key file

WebLogic Server Administration Command ReferenceAdministration Guide B-19Argument Definition-userconfig-file con-fig-file Specifies a file pathname at

B WebLogic Server Command-Line Interface ReferenceB-20 Administration GuideConfiguring the Default Path NameIf you do not specify the location in whic

WebLogic Server Administration Command ReferenceAdministration Guide B-21Creating User-Configuration and Key FilesTo create user-configuration and key

B WebLogic Server Command-Line Interface ReferenceB-22 Administration Guide2. When you create an additional user-configuration file, specify the exist

WebLogic Server Administration Command ReferenceAdministration Guide B-23A user who logs in to pat’s account can use the following syntax to invoke we

B WebLogic Server Command-Line Interface ReferenceB-24 Administration GuideTHREAD_DUMPProvides a real-time snapshot of the WebLogic Server threads tha

WebLogic Server Administration Command ReferenceAdministration Guide B-25UNLOCKUnlocks the specified WebLogic Server after a LOCK operation. Syntaxjav

Starting the WebLogic Administration ServerAdministration Guide 2-13n Change the value of the variable JAVA_HOME to the location of your JDK.n UNIX us

B WebLogic Server Command-Line Interface ReferenceB-26 Administration GuideVERSIONDisplays the version of the WebLogic Server software that is running

WebLogic Server Connection Pools Administration Command ReferenceAdministration Guide B-27WebLogic Server Connection Pools Administration Command Refe

B WebLogic Server Command-Line Interface ReferenceB-28 Administration GuideDetermine if a Connection Pool ExistsEXISTS_POOLTests whether a connection

WebLogic Server Connection Pools Administration Command ReferenceAdministration Guide B-29CREATE_POOLAllows creation of connection pool while WebLogic

B WebLogic Server Command-Line Interface ReferenceB-30 Administration GuideExampleIn the following example, a user with the name adminuser and the pas

WebLogic Server Connection Pools Administration Command ReferenceAdministration Guide B-31 initialCapacity=2,maxCapacity=8, props=user=SCOTT;pas

B WebLogic Server Command-Line Interface ReferenceB-32 Administration GuideDESTROY_POOLConnections are closed and removed from the pool and the pool d

WebLogic Server Connection Pools Administration Command ReferenceAdministration Guide B-33DISABLE_POOLYou can temporarily disable a connection pool, p

B WebLogic Server Command-Line Interface ReferenceB-34 Administration GuideENABLE_POOLWhen a pool is enabled, the JDBC connection states for each in-u

WebLogic Server Connection Pools Administration Command ReferenceAdministration Guide B-35EXISTS_POOLTests whether a connection pool with a specified

WebLogic Server Administration Guide vStep 3: Configure Startup Information for Managed Servers... 3-9Platform Support for Node Manager...

2 Starting and Stopping WebLogic Servers2-14 Administration GuideIf the Administration Server goes down while Managed Servers continue to run, you do

B WebLogic Server Command-Line Interface ReferenceB-36 Administration GuideRESET_POOLThis command resets the connections in a registered connection po

Mbean Management Command ReferenceAdministration Guide B-37Mbean Management Command ReferenceTable B-3 presents an overview of the Mbean management co

B WebLogic Server Command-Line Interface ReferenceB-38 Administration GuideCREATECreates an instance of a configuration Mbean. Returns OK to stdout wh

Mbean Management Command ReferenceAdministration Guide B-39DELETEDeletes a configuration Mbean. Returns OK in stdout when successful. This command can

B WebLogic Server Command-Line Interface ReferenceB-40 Administration GuideGETDisplays run-time Mbean attributes. You can request a list of attributes

Mbean Management Command ReferenceAdministration Guide B-41ExampleIn the following example, a user requests a display of the Mbean attributes for a se

B WebLogic Server Command-Line Interface ReferenceB-42 Administration GuideINVOKEInvokes the specified method (including arguments) on the specified M

Mbean Management Command ReferenceAdministration Guide B-43SETSets the specified attribute values for the named configuration Mbean. Returns OK on std

B WebLogic Server Command-Line Interface ReferenceB-44 Administration Guide

Administration Guide C-45APPENDIXC WebLogic SNMP Agent Command-Line ReferenceWebLogic Server can use Simple Network Management Protocol (SNMP) to comm

Starting the WebLogic Administration ServerAdministration Guide 2-15Note: If you do not have Service Pack 2 of WebLogic Server 6.1 installed, the new

C WebLogic SNMP Agent Command-Line ReferenceC-46 Administration GuideFor more information about using SNMP with WebLogic Server, refer to the WebLogic

Required Environment and Syntax for the SNMP Command-Line InterfaceAdministration Guide C-47java command-name arguments Table C-1 describes arguments

C WebLogic SNMP Agent Command-Line ReferenceC-48 Administration GuideCommands for Retrieving the Value of WebLogic Server AttributesTable C-2 is an ov

Commands for Retrieving the Value of WebLogic Server AttributesAdministration Guide C-49snmpwalkReturns a recursive list of all managed objects that a

C WebLogic SNMP Agent Command-Line ReferenceC-50 Administration GuideIf you invoke this command from a computer that is running the Examples Server, t

Commands for Retrieving the Value of WebLogic Server AttributesAdministration Guide C-51snmpgetnextReturns a description of the managed object that im

C WebLogic SNMP Agent Command-Line ReferenceC-52 Administration GuideThe command returns output similar to the following:Response PDU received from 12

Commands for Retrieving the Value of WebLogic Server AttributesAdministration Guide C-53snmpgetRetrieves the value of one or more object instances. Th

C WebLogic SNMP Agent Command-Line ReferenceC-54 Administration GuideCommands for Testing TrapsTable C-3 is an overview of commands that generate and

Commands for Testing TrapsAdministration Guide C-55snmpv1trapConstructs an SNMPv1 trap and distributes it to the SNMP manager or trap daemon that is r

2 Starting and Stopping WebLogic Servers2-16 Administration Guide2. Starts its kernel-level services, which include logging and timer services.3. Init

C WebLogic SNMP Agent Command-Line ReferenceC-56 Administration GuideExampleThe following example generates a log message trap that contains the trapT

Commands for Testing TrapsAdministration Guide C-57java snmpv1trap -p 165 localhost .1.3.6.1.4.140.625 localhost 6 601000 .1.3.6.1.4.1.140.625.100.5 S

C WebLogic SNMP Agent Command-Line ReferenceC-58 Administration GuidesnmptrapdStarts a daemon that receives traps and prints information about the tra

Commands for Testing TrapsAdministration Guide C-59java snmptrapd 3. Open another shell and do the following:a. Add a supported SDK to the shell’s PAT

C WebLogic SNMP Agent Command-Line ReferenceC-60 Administration Guide

Administration Guide D-1APPENDIXD Parameters for Web Server Plug-insThe following sections describe the parameters that you use to configure the Apach

D Parameters for Web Server Plug-insD-2 Administration GuideGeneral Parameters for Web Server Plug-InsNote: Parameters are case sensitive.Parameter De

General Parameters for Web Server Plug-InsAdministration Guide D-3WebLogicCluster noneIdentifes the WebLogic Server instances to which HTTP requests s

D Parameters for Web Server Plug-insD-4 Administration GuidePathTrim nullString trimmed by the plug-in from the beginning of the original URL, before

General Parameters for Web Server Plug-InsAdministration Guide D-5ConnectRetrySecs 2Interval in seconds that the plug-in should sleep between attempts

Starting a WebLogic Managed ServerAdministration Guide 2-174. Create an entry for the new server (Servers→Create a new server). Set the machine for th

D Parameters for Web Server Plug-insD-6 Administration GuideDebug OFFSets the type of logging performed for debugging operations. It is not advisable

General Parameters for Web Server Plug-InsAdministration Guide D-7WLLogFile See the Debug parameterSpecifies path and file name for the log file that

D Parameters for Web Server Plug-insD-8 Administration GuideWLSocketTimeoutSecs 2 (must be greater than 0)Set the timeout for the socket while connect

General Parameters for Web Server Plug-InsAdministration Guide D-9DefaultFileName noneIf the URI is “/” then the plug-in performs the following steps:

D Parameters for Web Server Plug-insD-10 Administration GuideFileCaching ONWhen set to ON, and the size of the POST data in a request is greater than

General Parameters for Web Server Plug-InsAdministration Guide D-11QueryFromRequest(Apache HTTP Server only)OFFWhen set to ON, specifies that the Apac

D Parameters for Web Server Plug-insD-12 Administration GuideWLProxySSL OFF Set this parameter to ON to maintain SSL communication between the plug-in

SSL Parameters for Web Server Plug-InsAdministration Guide D-13SSL Parameters for Web Server Plug-InsNote: Parameters are case sensitive.Parameter Def

D Parameters for Web Server Plug-insD-14 Administration GuideConfiguring Web Applications and Clusters for the Plug-inSet the following attributes on

Administration Guide I-1IndexAaccess logs 8-14ADMIN_URL environment variable 2-20Administration commands, overview B-6, B-27, 48, 54Administration Con

2 Starting and Stopping WebLogic Servers2-18 Administration GuideWhen starting a WebLogic Managed Server, you need to specify the parameters that you

I-2 Administration GuideHTTP parameters 8-2JMSbacking stores 17-12connection consumers 17-16connection factories 17-8destination keys 17-12destination

Administration Guide I-3FFailover procedures, JMS 17-31Failure, server 17-31FileCaching C-10FrontendHost 8-2FrontendHTTPPort 8-3FrontendHTTPSPort 8-3G

I-4 Administration Guidekeyslicense 21-2killing a serverdifference from stopping 3-17Llicenseevaluation 21-1keys 21-2updating 21-2LICENSES, WebLogic S

Administration Guide I-5Nnative I/O 8-27Netscape (proxy) Plug-in 13-2and clustering 13-15MIME types 13-4obj.conf file 13-5sample obj.conf file 13-16No

I-6 Administration Guideregistering 2-34SHUTDOWN, WebLogic Server command B-17SSLspecifying private key password at server startup 2-7SSL session cach

Administration Guide I-7CREATE B-38CREATE_POOL B-29DELETE B-39DESTROY_POOL B-32DISABLE_POOL B-33ENABLE_POOL B-34enabling command-line interface B-2EXI

Starting a WebLogic Managed ServerAdministration Guide 2-19Informational Thread Dumps When Starting ClustersIf a Managed Server is configured as follo

2 Starting and Stopping WebLogic Servers2-20 Administration GuideYou can ignore these thread dumps; they do not indicate an error in your configuratio

Stopping WebLogic Servers from the Administration ConsoleAdministration Guide 2-21where server_name is the name of the Managed Server you are starting

2 Starting and Stopping WebLogic Servers2-22 Administration Guidewhere:n host is the name or IP address of the machine where the WebLogic Server is ru

Setting Up a WebLogic Server Instance as a Windows ServiceAdministration Guide 2-23Setting Up Windows Services: Main StepsThe following main steps ass

vi WebLogic Server Administration Guide6. Using Log Messages to Manage WebLogic ServersOverview of Logging Subsystem ...

2 Starting and Stopping WebLogic Servers2-24 Administration Guide1. Make a backup copy of weblogic\config\mydomain\installNTService.cmd (where weblogi

Setting Up a WebLogic Server Instance as a Windows ServiceAdministration Guide 2-252. In the line that starts with set CMDLINE=, add the following arg

2 Starting and Stopping WebLogic Servers2-26 Administration Guideof SERVER_START_PENDING for 2 minutes. Then it changes the status to STARTED.The modi

Setting Up a WebLogic Server Instance as a Windows ServiceAdministration Guide 2-27You can also add the -delay:delay_milliseconds option to a Managed

2 Starting and Stopping WebLogic Servers2-28 Administration GuideIf you use -stopclass to gracefully shut down a server, 30 seconds might not be enoug

Setting Up a WebLogic Server Instance as a Windows ServiceAdministration Guide 2-29For information on changing the default behavior, see “Changing the

2 Starting and Stopping WebLogic Servers2-30 Administration Guidefollowing format to specify the start time: Month Day Year Hour:Minutes:Seconds where

Setting Up a WebLogic Server Instance as a Windows ServiceAdministration Guide 2-31When the Windows service checks the file size, if the file is large

2 Starting and Stopping WebLogic Servers2-32 Administration GuideFor example if you archived your class in a file named c:\myJar, the modified stateme

Setting Up a WebLogic Server Instance as a Windows ServiceAdministration Guide 2-33By default, standard out is the command prompt in which you run the

WebLogic Server Administration Guide viiWeb Applications...

2 Starting and Stopping WebLogic Servers2-34 Administration Guide-extrapath:”C\bea\wlserver6.0\bin” -cmdline: %CMDLINE%You must append the following t

Registering Startup and Shutdown ClassesAdministration Guide 2-35

2 Starting and Stopping WebLogic Servers2-36 Administration Guide

Administration Guide 3-1CHAPTER3 Node ManagerThe following sections describe how to use the Node Manager:n Overview of Node Managern Setting Up Node M

3 Node Manager3-2 Administration Guideall the Managed Servers on that machine. To ensure availability of Node Manager, Node Manager should be configur

Overview of Node ManagerAdministration Guide 3-3servername-error.logThis saves information printed to StdErr when an attempt is made by the Node Manag

3 Node Manager3-4 Administration GuideFigure 3-1 Node Manager ArchitectureSetting Up Node ManagerAll communication between Node Manager and the Admi

Setting Up Node ManagerAdministration Guide 3-5security, Node Manager also uses a list of trusted hosts; only commands from an Administration Server o

3 Node Manager3-6 Administration GuideAuthentication requires use of the public key infrastructure. This includes a private key as well as a certifica

Setting Up Node ManagerAdministration Guide 3-7Step 2: Converting a WebLogic-Style Private KeyIf you want to use WebLogic-style certificates with Node

viii WebLogic Server Administration GuideSyntax...10-7Clu

3 Node Manager3-8 Administration GuideIn this example, ca.pem is the WebLogic certificate authority file and is identical in content to the default tr

Setting Up Node ManagerAdministration Guide 3-92. Fill in the fields on the Node Manager tab:l The Listen Address is either the host name or IP addres

3 Node Manager3-10 Administration Guidethe Managed Server in that case if you specified the required values on the command line when starting the Node

Platform Support for Node ManagerAdministration Guide 3-11Platform Support for Node ManagerThe Node Manager is available for use only on Windows and U

3 Node Manager3-12 Administration GuideSetting Up the EnvironmentBefore starting the Node Manager, there are a number of environment variables that ne

Starting the Node Manager from the Command LineAdministration Guide 3-13In the above example it is assumed that the JAVA_HOME variable points to the r

3 Node Manager3-14 Administration GuideThe default port on which the Node Manager will listen for requests from the Administration Server is 5555. You

Starting the Node Manager from the Command LineAdministration Guide 3-15-Dbea.home=directoryIf you used DNS host names rather than IP addresses in the

3 Node Manager3-16 Administration GuideStarting the Node Manager Using Start ScriptsSample start scripts are provided for use in starting Node Manager

Remote Starting and Killing of Managed ServersAdministration Guide 3-17When you start the Managed Server, the messages that are usually printed to STD

WebLogic Server Administration Guide ixInformation Server (ISAPI) Plug-InOverview of the Microsoft Internet Information Server Plug-In ...

3 Node Manager3-18 Administration GuideStarting and Killing Domains and ClustersYou can also start or kill all of the Managed Servers in the active do

Setting Up Node Manager as a Windows ServiceAdministration Guide 3-19To install Node Manager as a Windows Service, do the following:1. Make a copy of

3 Node Manager3-20 Administration Guide

Administration Guide 4-1CHAPTER4 Configuring WebLogic Servers and ClustersThe following sections discuss how to set up WebLogic Servers and WebLogic S

4 Configuring WebLogic Servers and Clusters4-2 Administration Guiden Through the Administration Console, BEA’s graphical user interface (GUI) for mana

Role of the Administration ServerAdministration Guide 4-3Figure 4-1 shows a typical production environment that contains an Administration Server and

4 Configuring WebLogic Servers and Clusters4-4 Administration GuideFigure 4-1 WebLogic Server ConfigurationStarting the Administration ConsoleThe ma

How Dynamic Configuration WorksAdministration Guide 4-51. Enter the following URL: http://host:port/console where host is the host name or IP address

4 Configuring WebLogic Servers and Clusters4-6 Administration GuideOnce the Administration Console has been started, if another process captures the L

Server Configuration TasksAdministration Guide 4-7contains any non-Windows machines (that is, any machines that cannot support a Microsoft SQL Server