OCSG + XE

Oracle Communications Services Gatekeeper (OCSG), formerly known as WebLogic Network Gatekeeper (WLNG) is a carrier-grade telecommunications gateway supporting multiple network protocols and offering advanced policy management functionality. As you can imagine, it's a bit of a resource hog. When it comes to developing applications on my laptop, I like to keep the installation as light as possible. When installing, I choose the 'Basic Gatekeeper' domain and I like to use Oracle XE as the database. Oracle XE works great, however, on start-up you may encounter this baffling error:


ORA-12519, TNS:no appropriate service handler
found

If that's the case (and I'm pretty sure it will be), you need to execute this
SQLPlus command:


ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;

That will increase the number of allowable JDBC connections. You will then need to restart XE.


In case you're not familiar with XE, here are some configuration tips:


Within SQLPLUS:


CREATE USER ocsg40 IDENTIFIED BY ocsg40;

GRANT RESOURCE TO ocsg40;

GRANT CREATE SESSION TO ocsg40;

GRANT CREATE TABLE TO ocsg40;

Of course, you can use any user name and password you wish.


When creating an OCSG/WebLogic Domain make sure to configure both datasource tabs:


wlng.datasource


Name: wlng.datasource

JNDI name: wlng.datasource

Database type: Oracle

Driver: Oracle's Driver (Thin XA) Versions: 9.0.1, 9.2.0, 10

Supports global transactions: Two phase commit

DBMS name: XE

DBMS host: localhost

DBMS port: 1521

User name: ocsg40

User password: ocsg40

Confirm user password: ocsg40

wlng.localTX.datasource


Name: wlng.localTX.datasource

JNDI name: wlng.localTX.datasource

Database type: Oracle

Driver: Oracle's Driver (Thin XA) Versions: 9.0.1, 9.2.0, 10

Supports global transactions: unchecked

DBMS name: XE

DBMS host: localhost

DBMS port: 1521

User name: ocsg40

User password: ocsg40

Confirm user password: ocsg40

Comments:

Hi Jeffrey, Thanks for your post. I would like to make a comment about the example code that grants all privileges to the user OCSG40. This is not a good tip nowadays. Granting ALL PRIVILEGES is actually slightly worse than granting DBA as these privileges are not turned off in definer rights code, they are always on. Also even SYS does not have all privileges in 11g anymore, as it has lost EXEMPT ACCESS POLICY and EXEMPT IDENTITY POLICY. I always recommend that the minimum privileges necessary are granted for each role and user and these must be designed for purpose. cheers Pete [Good point. I've modified the entry to reflect the minimum privileges required by OCSG. --Jeff]

Posted by Pete Finnigan on August 26, 2008 at 08:44 PM EDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

Search

Categories
Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today