Oracle 9iAS portals 
Author Message
 Oracle 9iAS portals

I was successful at installing Oracle 9i Portals in the past but have
not been able to install it on other systems.  I believe it is a
listener.ora, tnsnames.ora or some script that runs and ruins my paths
set during pre-installation.

-kernel params are good
-tablespaces are good
-listener and DB are reachable
-all other configs and suggestions per Oracle manual have been followed
    ie jdk, seperate oracle homes, etc

After install and during the config assistant for portals I get this log
  that causes it to fail:
(what gets me is I am connected for the other 13 steps and the first
install action within "STEP 14")

-first I show $ORACLE_HOME/assistants/opca/install.log

-second  I show the sqlnet.log file given that shows the problem
    Here is where I don't understand where the config assistant is
getting conect string parameters.

$ORACLE_HOME/assistants/opca/install.log
-------------
STEP 14 : Installing seed data for all layers

INSTALL_ACTION: installSeedData() : ../../bin/sqlplus

TION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=TORRO)(PORT=1521)))(CONNECT_DATA

USERS TEMP wwcinsd.log USERS USERS portal30_NULL portal30_sso portal30_DEMO

INSTALL_ACTION:installSeedData() :../../bin/sqlplus

ON=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=TORRO)(PORT=1521)))(CONNECT_DATA=(

TEMP wwvinsd.log USERS USERS portal30_NULL portal30_sso portal30_DEMO

ORA-03114: not connected to ORACLE

Errors encountered in the Install process. Installation Aborted.

-----------------

$ORACLE_HOME/assistants/opca/sqlnet.log
***********************************************************************

Fatal NI connect error 12545, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/db/u01/app/oracle/product/O9iASpo
rtal/bin/oracle)(ARGV0=oracleorcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTO
COL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=torro)(USER=oracle)))
)

   VERSION INFORMATION:
         TNS for Linux: Version 8.1.7.0.0 - Development
         Oracle Bequeath NT Protocol Adapter for Linux: Version
8.1.7.0.0 - Devel
         TCP/IP NT Protocol Adapter for Linux: Version 8.1.7.0.0 -
Production
   Time: 11-MAY-2002 05:46:27
   Tracing not turned on.
   Tns error struct:
     nr err code: 0
     ns main err code: 12545
     TNS-12545: Connect failed because target host or object does not exist
     ns secondary err code: 12560
     nt main err code: 515
     TNS-00515: Connect failed because target host or object does not exist
     nt secondary err code: 2

***********************************************************************

I don't have my listener.ora setup with the parameters set above like
protocol being bequeth.  Where is it getting this and why has it stopped
using my listener.ora settings.  It seems as though something has
changed my path and it is now reading some other listener.ora file but I
have not found any.

Any help appreciated

iggy



Thu, 28 Oct 2004 20:05:17 GMT
 Oracle 9iAS portals

Quote:

>I was successful at installing Oracle 9i Portals in the past but have
>not been able to install it on other systems.  I believe it is a
>listener.ora, tnsnames.ora or some script that runs and ruins my paths
>set during pre-installation.

>-kernel params are good
>-tablespaces are good
>-listener and DB are reachable
>-all other configs and suggestions per Oracle manual have been followed
>    ie jdk, seperate oracle homes, etc

>After install and during the config assistant for portals I get this log
>  that causes it to fail:
>(what gets me is I am connected for the other 13 steps and the first
>install action within "STEP 14")

>-first I show $ORACLE_HOME/assistants/opca/install.log

>-second  I show the sqlnet.log file given that shows the problem
>    Here is where I don't understand where the config assistant is
>getting conect string parameters.

>$ORACLE_HOME/assistants/opca/install.log
>-------------
>STEP 14 : Installing seed data for all layers

>INSTALL_ACTION: installSeedData() : ../../bin/sqlplus

>TION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=TORRO)(PORT=1521)))(CONNECT_DATA

>USERS TEMP wwcinsd.log USERS USERS portal30_NULL portal30_sso portal30_DEMO

>INSTALL_ACTION:installSeedData() :../../bin/sqlplus

>ON=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=TORRO)(PORT=1521)))(CONNECT_DATA=(

>TEMP wwvinsd.log USERS USERS portal30_NULL portal30_sso portal30_DEMO

>ORA-03114: not connected to ORACLE

>Errors encountered in the Install process. Installation Aborted.

>-----------------

>$ORACLE_HOME/assistants/opca/sqlnet.log
>***********************************************************************

>Fatal NI connect error 12545, connecting to:

>(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/db/u01/app/oracle/product/O9iASpo
>rtal/bin/oracle)(ARGV0=oracleorcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTO
>COL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=torro)(USER=oracle)))
>)

>   VERSION INFORMATION:
>         TNS for Linux: Version 8.1.7.0.0 - Development
>         Oracle Bequeath NT Protocol Adapter for Linux: Version
>8.1.7.0.0 - Devel
>         TCP/IP NT Protocol Adapter for Linux: Version 8.1.7.0.0 -
>Production
>   Time: 11-MAY-2002 05:46:27
>   Tracing not turned on.
>   Tns error struct:
>     nr err code: 0
>     ns main err code: 12545
>     TNS-12545: Connect failed because target host or object does not exist
>     ns secondary err code: 12560
>     nt main err code: 515
>     TNS-00515: Connect failed because target host or object does not exist
>     nt secondary err code: 2

>***********************************************************************

>I don't have my listener.ora setup with the parameters set above like
>protocol being bequeth.  Where is it getting this and why has it stopped
>using my listener.ora settings.  It seems as though something has
>changed my path and it is now reading some other listener.ora file but I
>have not found any.

>Any help appreciated

>iggy

It is just using the *default* connection method, after all other
methods have failed.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address



Thu, 28 Oct 2004 20:53:23 GMT
 Oracle 9iAS portals

Quote:


>>I was successful at installing Oracle 9i Portals in the past but have
>>not been able to install it on other systems.  I believe it is a
>>listener.ora, tnsnames.ora or some script that runs and ruins my paths
>>set during pre-installation.

>>-kernel params are good
>>-tablespaces are good
>>-listener and DB are reachable
>>-all other configs and suggestions per Oracle manual have been followed
>>   ie jdk, seperate oracle homes, etc

>>After install and during the config assistant for portals I get this log
>> that causes it to fail:
>>(what gets me is I am connected for the other 13 steps and the first
>>install action within "STEP 14")

>>-first I show $ORACLE_HOME/assistants/opca/install.log

>>-second  I show the sqlnet.log file given that shows the problem
>>   Here is where I don't understand where the config assistant is
>>getting conect string parameters.

>>$ORACLE_HOME/assistants/opca/install.log
>>-------------
>>STEP 14 : Installing seed data for all layers

>>INSTALL_ACTION: installSeedData() : ../../bin/sqlplus

>>TION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=TORRO)(PORT=1521)))(CONNECT_DATA

>>USERS TEMP wwcinsd.log USERS USERS portal30_NULL portal30_sso portal30_DEMO

>>INSTALL_ACTION:installSeedData() :../../bin/sqlplus

>>ON=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=TORRO)(PORT=1521)))(CONNECT_DATA=(

>>TEMP wwvinsd.log USERS USERS portal30_NULL portal30_sso portal30_DEMO

>>ORA-03114: not connected to ORACLE

>>Errors encountered in the Install process. Installation Aborted.

>>-----------------

>>$ORACLE_HOME/assistants/opca/sqlnet.log
>>***********************************************************************

>>Fatal NI connect error 12545, connecting to:

>>(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/db/u01/app/oracle/product/O9iASpo
>>rtal/bin/oracle)(ARGV0=oracleorcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTO
>>COL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=torro)(USER=oracle)))
>>)

>>  VERSION INFORMATION:
>>        TNS for Linux: Version 8.1.7.0.0 - Development
>>        Oracle Bequeath NT Protocol Adapter for Linux: Version
>>8.1.7.0.0 - Devel
>>        TCP/IP NT Protocol Adapter for Linux: Version 8.1.7.0.0 -
>>Production
>>  Time: 11-MAY-2002 05:46:27
>>  Tracing not turned on.
>>  Tns error struct:
>>    nr err code: 0
>>    ns main err code: 12545
>>    TNS-12545: Connect failed because target host or object does not exist
>>    ns secondary err code: 12560
>>    nt main err code: 515
>>    TNS-00515: Connect failed because target host or object does not exist
>>    nt secondary err code: 2

>>***********************************************************************

>>I don't have my listener.ora setup with the parameters set above like
>>protocol being bequeth.  Where is it getting this and why has it stopped
>>using my listener.ora settings.  It seems as though something has
>>changed my path and it is now reading some other listener.ora file but I
>>have not found any.

>>Any help appreciated

>>iggy

> It is just using the *default* connection method, after all other
> methods have failed.

> Regards

> Sybrand Bakker, Senior Oracle DBA

> To reply remove -verwijderdit from my e-mail address

Thanks. What gets me is it is connecting fine for the previous 12
installl action steps and the sql loader function in step 13 and the
first install action of step 14 then it can no longer connect.  When I
cancel out and re-check if I can connect with sqlplus it works fine.

I'm not sure what I should check into next; perhaps session privs? Is
there a direction you would suggest?

iggy



Fri, 29 Oct 2004 01:56:27 GMT
 Oracle 9iAS portals


Quote:


> >>I was successful at installing Oracle 9i Portals in the past but have
> >>not been able to install it on other systems.  I believe it is a
> >>listener.ora, tnsnames.ora or some script that runs and ruins my paths
> >>set during pre-installation.

> >>-kernel params are good
> >>-tablespaces are good
> >>-listener and DB are reachable
> >>-all other configs and suggestions per Oracle manual have been followed
> >>   ie jdk, seperate oracle homes, etc

> >>After install and during the config assistant for portals I get this log
> >> that causes it to fail:
> >>(what gets me is I am connected for the other 13 steps and the first
> >>install action within "STEP 14")

> >>-first I show $ORACLE_HOME/assistants/opca/install.log

> >>-second  I show the sqlnet.log file given that shows the problem
> >>   Here is where I don't understand where the config assistant is
> >>getting conect string parameters.

> >>$ORACLE_HOME/assistants/opca/install.log
> >>-------------
> >>STEP 14 : Installing seed data for all layers

> >>INSTALL_ACTION: installSeedData() : ../../bin/sqlplus

>>TION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=TORRO)(PORT=1521)))(CONNEC
T_DATA

> >>USERS TEMP wwcinsd.log USERS USERS portal30_NULL portal30_sso
portal30_DEMO

> >>INSTALL_ACTION:installSeedData() :../../bin/sqlplus

>>ON=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=TORRO)(PORT=1521)))(CONNECT_
DATA=(

> >>TEMP wwvinsd.log USERS USERS portal30_NULL portal30_sso portal30_DEMO

> >>ORA-03114: not connected to ORACLE

> >>Errors encountered in the Install process. Installation Aborted.

> >>-----------------

> >>$ORACLE_HOME/assistants/opca/sqlnet.log
> >>***********************************************************************

> >>Fatal NI connect error 12545, connecting to:

>>(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/db/u01/app/oracle/product/O9
iASpo

>>rtal/bin/oracle)(ARGV0=oracleorcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=
(PROTO

>>COL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=torro)(USER=ora
cle)))
> >>)

> >>  VERSION INFORMATION:
> >>        TNS for Linux: Version 8.1.7.0.0 - Development
> >>        Oracle Bequeath NT Protocol Adapter for Linux: Version
> >>8.1.7.0.0 - Devel
> >>        TCP/IP NT Protocol Adapter for Linux: Version 8.1.7.0.0 -
> >>Production
> >>  Time: 11-MAY-2002 05:46:27
> >>  Tracing not turned on.
> >>  Tns error struct:
> >>    nr err code: 0
> >>    ns main err code: 12545
> >>    TNS-12545: Connect failed because target host or object does not
exist
> >>    ns secondary err code: 12560
> >>    nt main err code: 515
> >>    TNS-00515: Connect failed because target host or object does not
exist
> >>    nt secondary err code: 2

> >>***********************************************************************

> >>I don't have my listener.ora setup with the parameters set above like
> >>protocol being bequeth.  Where is it getting this and why has it stopped
> >>using my listener.ora settings.  It seems as though something has
> >>changed my path and it is now reading some other listener.ora file but I
> >>have not found any.

> >>Any help appreciated

> >>iggy

> > It is just using the *default* connection method, after all other
> > methods have failed.

> > Regards

> > Sybrand Bakker, Senior Oracle DBA

> > To reply remove -verwijderdit from my e-mail address

> Thanks. What gets me is it is connecting fine for the previous 12
> installl action steps and the sql loader function in step 13 and the
> first install action of step 14 then it can no longer connect.  When I
> cancel out and re-check if I can connect with sqlplus it works fine.

> I'm not sure what I should check into next; perhaps session privs? Is
> there a direction you would suggest?

> iggy

You don't seem to have a tnsnames.ora, or your ORACLE_SID environment
variable is not set anymore.

tnsnames.ora normally is in $ORACLE_HOME/network/admin.
If there is a tnsnames.ora you didn't configure it properly.

Your error has NOTHING!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! to do with session
privileges.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address



Sat, 30 Oct 2004 02:47:12 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. US-MA-ORACLE 9IAS PORTAL RELEASE 2

2. Oracle 9iAS Portal

3. Problem in configuring Oracle 9iAS Portal on Oracle9i.

4. Oracle 9iAS Portal on 9i Database?

5. 9ias: Migrating a Portal

6. 9iAS installation - portal software

7. Oracle Portal vs Novell Portal

8. Generate an oracle report from command line (oracle 9ias)

9. Oracle 9ias

10. Senior Oracle 9iAS Developer

11. USA-MI-Oracle 9iAS developer

12. OraFocus Weekly: RMan installation and usage, Buffer Cache size advice, Oracle 9iAS Best Practices


 
Powered by phpBB® Forum Software