Re: Webdb Linux install help

[Quoted] In article <39A12671.1CBD4D83_at_knowledgeinenergy.com>,   mango <mhammonds_at_knowledgeinenergy.com> wrote:

> I am not able to get passed the sys password and alias part of the
>                  install (Invalid password or alias).
>  I tried accessing sqlplus as the sys user but got an error saying
> object not available or created.
>  But if I change my environment back to the original environment for
>  the Oracle 8i install sqlplus will login as sys
> Can anybody tell me what I am doing wrong here?

What version of Oracle do you have? There is a really annoying bug with version 8.1.5 (8i) with WebDB. The problem is that WebDB needs to access sqlplus with a script, the 8.1.5 version supports multi instances, and cause a problem when accessing through WebDB. To solve this problem an older version of SQLPLUS is included in your webdb home (this is why you now have two oracle home directories an 8.1.5 home and a webdb home). Your bash profile file should point to this webdb (older) version. Make sure all your environment settings are right. Mine look like this:

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:/u01/app/oracle/product/8.1.5/bin:. BASH_ENV=$HOME/.bashrc
USERNAME="" export USERNAME BASH_ENV PATH

# Oracle shit

NLS_LANG=american_america.US7ASCII
ORA_NLS33=/u01/app/oracle/product/8.1.5/ocommon/nls/admin/data

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/webdb
ORACLE_PATH=/u01/oracle/product/8.1.5/bin:.
ORACLE_SID=v8i815

export NLS_LANG ORA__NLS33 ORACLE_BASE ORACLE_HOME ORACLE_PATH ORACLE_SID TNS_ADMIN=/u01/app/oracle/product/8.1.5/network/admin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/u01/app/oracle/product/8.1.5/lib ORACLE_TERM=vt100
WV_GATEWAY_CFG=/u01/app/oracle/product/webdb/listener/cfg/wdbsvr.app

export TNS_ADMIN LD_LIBRARY_PATH ORACLE_TERM WV_GATEWAY_CFG

# Linux shit with Oracle shit

# Java shit

export JRE_HOME=/usr/local/jre
export JAVA_HOME=/usr/local/jre
export PATH=$JAVA_HOME/bin:$PATH
export CLASSPATH=$JAVA_HOME/lib/rt.jar

Next check out your listener.ora tnsnames.ora and sqlnet.ora files, make sure they are the ones in the path to your 8.1.5 home, mine is TNS_ADMIN=/u01/app/oracle/product/8.1.5/network/admin

My files look like this (no indents with the tab key!!!)

# LISTENER.ORA Configuration

File:/u01/app/oracle/product/8.1.5/network/admin/listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =
  (DESCRIPTION =

     (ADDRESS_LIST =
         (ADDRESS=(PROTOCOL=TCP)(HOST=172.16.98.61)(PORT=1521))
      )

      (SID_NAME = v8i815)
     )

# SQLNET.ORA Configuration

File:/u01/app/oracle/product/8.1.5/network/admin/sqlnet.ora
# Generated by Oracle Net8 Assistant

SQLNET.EXPIRE_TIME = 0 SQLNET.CRYPTO_SEED = sgaaahgfjjrwtuwtjyht

# TNSNAMES.ORA Configuration

File:/u01/app/oracle/product/8.1.5/network/admin/tnsnames.ora
# Generated by Oracle Net8 Assistant

USER1 =
(DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS=(PROTOCOL=TCP)(HOST=172.16.98.61)(PORT=1521))     )
    (CONNECT_DATA =
       (SID=v8i815)
    )
)

Make sure these are in your oracle 8.1.5 home mine are in /u01/app/oracle/product/8.1.5/network/admin

Once all this stuff is double checked, try accessing sqlplus in your webdb home without closing down the installer, if you can get in with your SYS user then it should now work!

Benjamin Burger

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 21 2000 - 19:37:04 CEST