A couple of people have asked me recently about the inactive “Edit Web Layout” menu item in Siebel Tools. Well, that functionality is gone – web templates are no longer stored locally in files, but in the database, and so the ability to access this function in Siebel Tools has simply been deactivated. However, all is not lost – “Edit Web Layout” is still available, but you’ll have to access that function through the new Web Tools.
To make matters even more entertaining, that function is not enabled by default nor is it enabled automatically via any of the Patch Sets currently available (up to 17.6 at the time of writing). However, 17.6 does dump a little gem into your Siebel Server BIN folder for you to stumble across, if you happen to read the entire contents of the “Known Issues” section of the patch release notes. Here’s a quick summary of what you have to do, in a Windows environment, to work around “Bug Id 27113012”:
- Install the latest Patch Set (17.6 is what I’ve been using) to your Siebel Enterprise
- Open a command line and change directory to the Siebel Server installation BIN folder (e.g. <SIEBEL_HOME>\ses\siebsrvr\bin\)
- Execute the batch file named “EditWebLayout.bat”
- After executing the batch file, you will be prompted to enter the following information:
Full path of ODBCSQL: <Siebel Server BIN Location>
ODBC Data Source: <ODBC DataSource Name>
Table Owner Name: <Table Owner User - 'SIEBEL' in most cases>
Table Owner Password: <Table Owner Password>
TBLO Name: <A cryptic one this. The batch file gives some garbage about ORAPQ100, or some such. I just used the table owner again, 'SIEBEL'>
Repository Name: <Repository Name - '"Siebel Repository"' in most cases. Yes, you have to put the quotes around it or the batch file will fail>
- Check the output of the command in the log file, EditWebLayout.log, and you’ll see that a bunch of seed data has been loaded
- Clear the browser cache and re-login to the Web Tools application
- Navigate to your Applet then Applet Web Template
- You’ll see an “Edit” icon in the bottom right (cunningly, the tooltip says “Preview” – great job, Oracle!)
Here’s the “Edit Web Template” button
- Click this and you’re back on familiar(ish) ground
And… edit away!
Some wee observations:
- Why do Oracle insist on disabling functionality before they fully implement an alternative?
- Why do Oracle still find it so difficult to deliver repository and seed data fixes, outside of horribly written, unintuitive, manually executed batch scripts that I have to hunt in their obscure documentation to find?
Ho hum, I guess this sort of hack-around is what we’ve come to expect and accept from Siebel releases these days.
Now that the Siebel 17 installation is complete, we can start the logical configuration and deployment process. It’s at this point you’ll want to apply any Patch Sets or whatever – just remember to shutdown the containers for the AI and Enterprise (via the applicationcontainer\bin\shutdown.bat script) and stop the Gateway service.
Before starting with the logical deployment, quickly check the regional settings on your host, if you’re running Windows. This must be set to “English (United States)” or the deployment process will fail. Oracle are fixing this under bug 27348563.
The Siebel Management Console is where all the activities take place. Think of this as an abstraction over the old configuration batch files, the shortcuts for which used to be installed in your start menu. There’s an order to the deployment tasks, so let’s go through them one by one.
Deploy the Enterprise
- First up, create a Siebel Fileshare folder somewhere on the host. I used “D:\Siebel\siebel_fs”
- Start the deployment process by navigating to the Profiles > Enterprise tab on the left side of the Siebel Management Console (hereafter referred to as SMC)
- Clone the sample profile and give it a name, for example “siebel_enterprise_profile”. The clone button is the one with two squares overlapping
- On the first tab, set the primary file system to the absolute path of the fileshare folder that you created. For example, “D:\Siebel\siebel_fs”. Enter the SADMIN username and password in the authentication section
- On the next tab, enter your database platform details. See an example from my Oracle Database Server below:
- On the next tab, select the “Gateway” authentication profile that you created when first logging in to the SMC
- On the last tab, you can leave the encryption type field unchanged
- Now submit the profile
- Now click the Deployment tab on the left of the SMC, and click the “+” button to create a new deployment action. Click the “Enterprise” item
- Select your Enterprise profile, give it a name, and select the “Deploy” radio button before submitting the activity
- After a great deal of whirring and clunking, your new Enterprise will be deployed into the ZooKeeper keystore and made available within the Gateway. You’ll also see a file system structure in place, a Gateway service and an ODBC datasource
Deploy the Siebel Server
Deployment of the Siebel Server is more of the same.
- Start the deployment process by navigating to the Profiles > Siebel Server tab on the left side of the SMC
- Clone the sample profile and give yours a name. For example, “siebel_server_profile”
- Enter the SADMIN username and password and the GUESTCST username and password, as you setup in your database
- Pick which Component Groups you want to enable and leave the port numbers as is
- On the last tab, leave everything as is. You’re all set to submit the profile
- Now click the Deployment tab on the left of the SMC, and click the “+” button to create a new deployment action. Click the “Siebel Server” item
- Select your Siebel Server profile, and enter your FQDN and HTTS port number. For example, “SIEB17.siebel-tech.com:9021”
- Give your Siebel Server a name, pick your languages and you’re ready to submit your Siebel Server deployment
- With a bit of luck, you’ll find a Siebel Server Services awaiting you!
Deploy the Application Interface
There’s a bit more to do to deploy the Application Interface, the replacement for the Siebel Web Engine.
- Start the deployment process by navigating to the Profiles > Application Interface tab on the left side of the SMC
- Clone the sample profile and give yours a name. For example, “ucm_appinterface_profile”
- You don’t need to worry much about what’s here, but you’ll want to specify the GUESTCST password as you defined it during the database setup
- Pick your object manager and specify your REST response base URL. For example, “https://SIEB17.siebel-tech.com:9011/siebel/v1.0/”
- On the second tab, give the application a name, for example “ucm” and choose the object manager. I’ve gone for “ucmobjmgr_enu”. Update the anonymous GUESTCST user password as before
- The third and forth tabs can remain unchanged. Simply submit your profile
- Now click the Deployment tab on the left of the SMC, and click the “+” button to create a new deployment action. Click the “Application Interface” item
- Specify the FQDN and HTTPS port number again. For example, “SIEB17.siebel-tech.com:9021”
- Select your profile and give the new AI a name and description before submitting the deployment
- You should see green lights all around!
You can now access your Siebel 17 user interface using your host plus the name of your AI profile. For example, “https://sieb17.siebel-tech.com:9011/siebel/app/ucm/enu”
It has been rather quiet of late, I’m afraid. The trials and responsibilities of everyday life continue to thwart my efforts to update the blog and keep you appraised of all things “after Siebel”! However, Siebel 17 is not forgotten and I’ve been working closely with Oracle to iron out a bug or two in the IP 2017 deployment process as well a running a project to deploy IP 2017 as part of a large Enterprise programme. More on all that shortly.
In the meantime, I wanted to put the question of self signed certificates to bed and show you how to produce keystore and truststore files for an IP 2017 installation.
You’ll have to install OpenSSL and a Java SDK somewhere on your machine. The machine itself must have a Fully Qualified Domain Name: “MySiebelHost” will not do, it must be “MySiebelHost.mydomain”. In Windows, you can easily get around this without having to actually create a domain and register your machine on it by setting the “Full computer name” in the System Properties:
Anyway, without further ado, I give you “MakeKeys.bat”:
rem CHANGE_ME! :)
rem DO NOT CHANGE
rmdir %SIEBEL%\keys /s /Q
rmdir %SIEBEL%\ca /s /Q
%JAVA%\keytool -genkey -alias siebel -keystore %SIEBEL%\keys\siebelkeystore.jks -keyalg RSA -sigalg SHA1withRSA -dname "cn=%FQDN%" -storepass %PASSWORD% -keypass %PASSWORD%
%JAVA%\keytool -list -v -keystore %SIEBEL%\keys\siebelkeystore.jks -storepass %PASSWORD%
%JAVA%\keytool -certreq -alias siebel -keystore %SIEBEL%\keys\siebelkeystore.jks -file %SIEBEL%\keys\siebelkeystore.csr -storepass %PASSWORD%
%SSL%\openssl req -new -keyout %SIEBEL%\ca\cakey.pem -out %SIEBEL%\ca\careq.pem -subj "/CN=%FQDN%" -passout pass:%PASSWORD%
%SSL%\openssl x509 -signkey %SIEBEL%\ca\cakey.pem -req -days 3650 -in %SIEBEL%\ca\careq.pem -out %SIEBEL%\ca\caroot.cer -extensions v3_ca -passin pass:%PASSWORD%
%JAVA%\keytool -printcert -v -file %SIEBEL%\ca\caroot.cer
echo 1234 > %SIEBEL%\ca\serial.txt
%SSL%\openssl x509 -CA %SIEBEL%\ca\caroot.cer -CAkey %SIEBEL%\ca\cakey.pem -CAserial %SIEBEL%\ca\serial.txt -req -in %SIEBEL%\keys\siebelkeystore.csr -out %SIEBEL%\keys\siebelkeystoreCASigned.cer -days 365 -passin pass:%PASSWORD%
%JAVA%\keytool -import -alias ca -file %SIEBEL%\ca\caroot.cer -keystore %SIEBEL%\keys\siebelkeystore.jks -storepass %PASSWORD% -noprompt
%JAVA%\keytool -import -alias siebel -file %SIEBEL%\keys\siebelkeystoreCASigned.cer -keystore %SIEBEL%\keys\siebelkeystore.jks -storepass %PASSWORD%
%JAVA%\keytool -list -v -keystore %SIEBEL%\keys\siebelkeystore.jks -storepass %PASSWORD%
move %SIEBEL%\keys\siebelkeystore.jks %SIEBEL%\siebelkeystore.jks
echo Use the following path for both keystore and truststore in all Siebel installations: %SIEBEL%\siebelkeystore.jks
echo Use the following password for both keystore and truststore: %PASSWORD%
Simply save to a .BAT file (this is Windows, but should work with small mods on a Linux environment) and set the parameters appropriately. Execute the file and use the resulting “siebelkeystore.jks” file for both the keystore and truststore in your Siebel installations, across all components on that machine.
Having installed the Siebel 17 software, there’s one more step before we can set up the logical Gateway, Enterprise, Siebel Server and Application Interface (what used to be the SWSE): install the Siebel database.
As part of the Siebel Server installation, you’ll have installed the Siebel Database Server components. You can find a traditional shortcut to the configuration tool on your start menu, just like the good old days. Invoke this, enter your database connectivity details and sit back while the installer does its thing:
I noted that the installation process is significantly quicker than it used to be, even though the database installer has a lot more work to do in setting up the repository tables for workspaces. After just over an hour, I have a Siebel database ready to use.
Within the Siebel Server bin folder, you’ll find a shortcut to the license key deployment tool (LicenseKeyModule.bat). Double click this and enter your database connection details:
Select the components you’d like to use in your development environment. Click “Apply” to finish the job:
We’re ready to rock – tune in tomorrow for a detailed guided to the Siebel Management Console and the process to deploy the Gateway, Enterprise, Siebel Server and AI.
So, it’s finally arrived – Siebel 17 is here!
Of course, I’ve immediately hammered my home broadband to download all 20 delightful gigabytes of installation material to give you the low down on how to set it all up.
I’ve prepared 4 VMs for my Siebel 17 environment:
- Siebel Web – will hold the Apache Tomcat applications for both the Siebel Management Console (SMC) and the OM “Application Interface” component – the new name for SWSE
- Siebel App – will hold the Gateway and Siebel Server components
- Siebel DB – runs an Oracle 12c database
- Siebel Client – we’ll put Tools on here, just for old times sake!
At the moment, we’re only really interested in the first three.
I take a moment, these days, to prep my machines before installing anything. This typically involves an installation of a Java SDK, an Oracle Client, all Windows updates, SQL Developer and so on. My machines were ready to go by the time I’d used SNIC.BAT to produce me some installers.
Haley, what are you still doing here?
Installing the Application Interface
Running the installer, I see a familiar sight in the usual Siebel install wizard:
Some familiar and not so familiar installation options
Clearly, there are some new additions this time around! Installing the Application Interface requires the creation of a keystore and truststore, concepts that will be familiar to anyone who has used Tomcat in the past. I ran a few quick commands from my Java JDK bin folder to generate both. Note that there are some specific requirements for these files documented in Bookshelf and full instructions can be found in article Doc ID 2294567.1 on My Oracle Support. I’ve written a new post that contains a Windows batch file that you can amend and simply run to produce the appropriate keystore and truststore files.
Specify the siebel_keystore.jks for both the keystore and truststore files created above in the installation process, along with your chosen password.
During the installation process, you need to choose and note down ports for each of the Tomcat REST facades that will sit atop the Siebel components. These facades abstract a management interface that allows configuration and maintenance centrally, from the Siebel Management Console. It’s important that you write these down, though they can be derived by referring to the Tomcat configuration files within the applicationcontainer folder in each of your component installations. I’ve opted to use a standard range for each component across the HTTPS, HTTP and Shutdown ports respectively:
- Application Interface: 9011, 9012, 9013
- Gateway: 9021, 9022, 9033 (with 9034 as the Gateway TLS port)
- Siebel Server 1: 9031, 9032, 9033
Installing the Enterprise Server
The Enterprise Server installation is much the same and I elect to install the Gateway and Siebel Server separately, by invoking the installer two more times, picking a different installation folder and set of ports for each.
Not much else to do now but click “Next” and await success.
War file deployed, installation complete. Phew!
Okay, so I’ve only just scraped the tip of the Siebel 17 iceberg, by installing the base software. There’s a lot more to do to get my Siebel 17 environment up and running. Stay tuned for the next instalment!
I’ve just seen a load of excellent posts on John Bedford’s “Oracle Siebel CRM” blog, answering many of the frequently asked questions related to the upcoming release of Siebel IP 2017:
There are also a number of Web Casts available from the Oracle University site, including some demonstrations and discussions around the new Siebel Composer functionality:
Some really interesting reading in there and I cannot wait for the GA release! I’ve some VMs prep’d and ready… must be coming soon!
Stay tuned for more information and hopefully and in depth review!