Re: Webdb Linux install help

Before trying the excellent advice given by Benjamin, try setting a environment variable called TWO_TASK to your tnsnames alias..

For instance if alias for the instance you want to connect to is myorcl then

EXPORT TWO_TASK=myorcl

and see if it helps...it did on my Linux setup...

To use another instance , change the tnsnames entry used...  

hyopsodus_at_my-deja.com wrote:

>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_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (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 - 21:26:07 CEST