How to login to Discoverer as a user?
Dear Experts,
I've installed Oracle Discoverer using weblogic on
Server: 64 bit Redhat 5.5
---------
lsb_release -a
LSB Version: :core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: EnterpriseEnterpriseServer
Description: Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
Release: 5.5
Codename: Carthage
java weblogic.version -verbose
Server 10.3.5.0 Fri Apr 1 20:20:06 PDT 2011 1398638 ImplVersion: 10.3.5.0
Oracle WebLogic Server Module Dependencies 10.3 Thu Mar 3 14:37:52 PST 2011 ImplVersion: 10.3.5.0
Oracle WebLogic Server on JRockit Virtual Edition Module Dependencies 10.3 Thu Feb 3 16:30:47 EST 2011 ImplVersion: 10.3.5.0
...
cat /middleware/user_projects/domains/ClassicDomain/config/fmwconfig/servers/WLS_DISCO/applications/discoverer_11.1.1.2.0/configuration/styles/version.txt
UIX 11.1.1.2
---------
I can get to the weblogic admin console at:
http://black.testrac.com:7001/em
All the systems are up with lots of green lights and arrows.
---------
But what is the secret to login to Oracle Discoverer as a user?
This webpage (on my server)
http://black.testrac.com:8090/discoverer/viewer
Brings me to a screen like the one shown here:
http://docs.oracle.com/html/B13918_03/urlstart.htm#i1014049
in section 13.4.3
I keep looking and looking all over Oracle Docs for a simple example on how to login.
But alas, as usual, have not had any luck.
1)
What are all the unspoken prerequisites???
(ie. With the Oracle database, you need sqlplus and a tnsnames.ora file on the client, and the listener must be started or the server)
1b) Must I create connection strings before a successful login?
2)
What is a simple example of a database connection string that works? (Non-RAC)
ie. servername:1521:THEORACLESID
or
THEORACLESID
or
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = black)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = STOREHOUSE)))
or
something else?
??
3)
The options in the drop down, Connect to, are:
Oracle BI Discoverer
Oracle Applications
Oracle BI Discoverer for OLAP
What are the default user names and passwords?
ie. in Oracle Apps R12, there is:
SYSADMIN/sysadmin
OPERATIONS/welcome
4)
Where are some clear and concise docs on this?
Thanks a lot!