Bit of an odd one this. Oracle 11g database, a user’s password has expired. But when I try to change it, I can’t: [sourcecode language=“bash”] $sqlplus MYUSER/oldPW@oraDBServer SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 23 07:57:41 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-28001: the password has expired Changing password for MYUSER New password: Retype new password: ERROR: ORA-01017: invalid username/password; logon denied Password unchanged [/sourcecode]

(Updated 12th Oct 09) Here’s a list of the OBIEE benchmark documents published by Oracle: BenchmarkDateSource document1 - IBM System x3755Sep-07PDF2 - HP DL380 G4Sep-07PDF3 - Sun T2000Sep-07PDF4 - Sun SPARC Enterprise T5440Aug-09PDF5 - Sun SPARC Enterprise T5440Oct-09PDF Collecting the numbers into one table gives this: Based on the details in the documents I think these were all against OBIA’s Service Analytics schema & dashboards/reports. Interesting to note the side-by-side comparison in benchmark 3 (Sun T2000) of two servers, in one case both running BI and Presentation Services and in the other having the two components separate.

Here’s a list of the OBIEE benchmark documents published by Oracle: 28,000 User Benchmark on Sun SPARC Enterprise T5440 Server running Solaris 10 [Aug 09] 10,000 User Benchmark on Sun T2000 [Sept 07] 5,800 User Benchmark on HP DL380 G4 [Sept 07] 4,000 User Benchmark on an IBM System x3755 Server running Red Hat Enterprise Linux

Production cluster is 2x BI Server and 2x Presentation Services, with a BIG-IP F5 load balancer on the front. Symptoms Users started reporting slow login times to BI. Our monitoring tool (Openview) reported that “BIServer01 may be down. Failed to contact it using ping.”. BIServer01 cannot be reached by ping or ssh from Windows network. Diagnostics nqsserver and nqsclustercontroller on BIServer01 was logging these repeated errors: [nQSError: 12002] Socket communication error at call=send: (Number=9) Bad file number

A new version of the web browser Opera was released recently. Several years ago I used Opera and may even have paid for it IIRC. Then Firefox came along, and the “it’s not IE” excuse was lost for Opera. Not that I mind IE too much nowadays but at the time it was atrocious. Since then I’ve revisited Opera each time a new release has come out, but nothing has impressed me enough to ditch Firefox (and nowadays Google Chrome).

Bringing together in one place all of the script syntax that I’ve found so far for using with OBIEE’s AdminTool.exe /command Details and examples on usage in the following blogs (where I compiled the commands from): Venkat Erik Eckhardt (translated from Czech, original here) @lex Kumar Kambam DON’T TRY THIS AT HOME! I would only recommend this for read-only purposes such as generating the metadata dictionary or consistency check. * OpenOnline DSN [user [password]] - Opens the online repository.

There’s an undocumented feature in AdminTool.exe that you can use the /command switch with a text file containing scripted commands to make changes to an RPD file (or create a new one). It’s undocumented and UNSUPPORTED so be careful using it. Some good details in these blog posts, especially Erik’s which has a good list of syntax. Venkat Erik Eckhardt (translated from Czech, original here) @lex Kumar Kambam I’m intrigued to know how the original posters figured out the commands available, if it’s undocumented… :)

Kudos to the My Oracle Support blog for taking the time to respond to my to my comment about searching for Metalink 3 SRs throwing an error. In essence, if you previously used Metalink 3 you must use https://support.oracle.com. If you use https://metalink.oracle.com/ then you’ll hit the problems I did. ML3 SR’s are not supported on https://metalink.oracle.com/CSP/ui/index.html. This front end is used for support on legacy server technology, middleware including BEA, and EBusinessSuite

Another way of keeping up with what’s going on in the obiee world, add this RSS feed of del.icio.us obiee tags to your reader. It may be less “current” (because people might discover and bookmark ‘old’ pages), but it’s another tool in the armoury :) If you want an aggregated RSS feed of OBIEE / Oracle related blog postings try this one.

Following the Oracle CAF tutorial here, I got to Cloning Answers Requests section and then got stuck. I’d set up my environment exactly the same as in the tutorial, down to the same paths etc. After firing up the CAF to clone requests from the SampleSales catalog: I clicked on Next and got the error “Exception occurred when while initializing repository!!!” By playing around with the passwords and path names I determined that both RPD files existed and that CAF could load them enough to validate the passwords.