Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Solutions › Topic Id: 1158 | Permalink

ptlpatch.csh ERROR:Invalid Portal Connect Info ,cannot proceed with the installation

Topic ID: 1158
Created By: 2006-SEP-26 18:02:43 [Vitaliy]
Updated By: 2006-SEP-26 18:02:56 [Vitaliy]
Status: Closed
Severity: Normal
Read Only: No
4393
2006-SEP-26 18:02:43
Moderator
 
 
Registered On: Mar 2006
Total Posts: 267
ptlpatch.csh ERROR:Invalid Portal Connect Info ,cannot proceed with the installation

ISSUE:
=======

## applying portal patch

cd $ORACLE_HOME/OPatch
./opatch apply -silent /u01/app/oracle/patch/5024386 -pre -s portal -p portpassword -c hostname.yourcompany.com:1521:YOURSID


GETTING THIS ERROR:
===================

ERROR:Invalid Portal Connect Info ,cannot proceed with the installation


SOLUTION:
==========

Use SERVICE_NAMES instead of SID for connection:

cd $ORACLE_HOME/OPatch
./opatch apply -silent /u01/app/oracle/patch/5024386 -pre -s portal -p portpassword -c hostname.yourcompany.com:1521:YOURSID.yourcompany.com


RESEARCH:
==========

Welcome to Oracle Portal OneOffPatch Installer Version 3.0

Installing Oneoff

ptlpatch version 3.0

Usage:
ptlpatch.csh

 -z <zipfile> -s <portal_schema> -p <portal_password> -c <connect_string>

ptlpatch.csh

 -b <bugnum>  -s <portal_schema> -p <portal_password> -c <connect_string>
 
   -z  <zipfile> -b <bugnum>
   -s  <portal_schema>
   -p  <portal_password>
   -ss <sys_schema>
   -sp <sys_password>
   -c  <connect_string> Format=<hostname>:<port>:<sid>
   -l  <log_file_name>  Default=patch.log
   -showlog
   -show
   -deinstall

Example:

   ptlpatch.csh -z zipfile  -s portal_schema -p portal_password -ss sys_schema -sp sys_password -l patch.log -c connect_string
   ptlpatch.csh -b bugnumber -s portal_schema -p portal_password -ss sys_schema -sp sys_password -l patch.log -c connect_string
   ptlpatch.csh -z zipfile  -l patch.log
   ptlpatch.csh  -showlog  -s portal_schema -p portal_password -c connect_string
   ptlpatch.csh  -show  -s portal_schema -p portal_password -c connect_string
   ptlpatch.csh  -deinstall -b bugnumber -s portal_schema -p portal_password -c connect_string

ERROR:Invalid Portal Connect Info ,cannot proceed with the installation

CMD=./ptlpatch.csh  -z P5024386_PATCHBUNDLE.zip -s portal -p portpassword -c hostname.yourcompany.com:1521:YOURSID



from /u01/app/oracle/product/10gAS/portal/patch/oneoffs/sqlnet.log

Fatal NI connect error 12514, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname.yourcompany.com)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=YOURSID)(CID=(PROGRAM=
perl@callisto)(HOST=callisto)(USER=oracle))))

  VERSION INFORMATION:
        TNS for Solaris: Version 10.1.0.4.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 10.1.0.4.0 - Production
  Time: 26-SEP-2006 16:29:17
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12564
    TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

REFERENCE:
   Note:279771.1 OracleAS Portal One-offs Installations Issues
4394
2006-SEP-26 18:02:56
Moderator
 
 
Registered On: Mar 2006
Total Posts: 267
.