Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1168016

Summary: upgrading 5.6.0 with embedded PostgreSQL including OS upgrade fails on spacewalk-dump-schema with: ORA-12154
Product: Red Hat Satellite 5 Reporter: Jan Hutař <jhutar>
Component: UpgradesAssignee: Tomáš Kašpárek <tkasparek>
Status: CLOSED CURRENTRELEASE QA Contact: Jan Hutař <jhutar>
Severity: high Docs Contact:
Priority: unspecified    
Version: 570CC: adujicek, pstudeni
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: rhn-upgrade-5.7.0.21-1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-01-22 09:10:44 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1128174    

Description Jan Hutař 2014-11-25 21:22:04 UTC
Description of problem:
Upgrading 5.6.0 with embedded PostgreSQL including OS upgrade fails on spacewalk-dump-schema with: DBI connect('rhnschema','rhnuser',...) failed: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at ./spacewalk 


Version-Release number of selected component (if applicable):
Upgrading from: Satellite 5.6.0 (up2date) @ embedded PostgreSQL @ RHEL5
Using: rhn-upgrade-5.7.0.6-1.el5sat


How reproducible:
always


Steps to Reproduce:
1. Have 5.6.0 with embedded PostgreSQL @ RHEL5
2. Follow upgrade docs and then in satellite-and-os-upgrade-postgresql.txt
   step 1 there is:

| 1. Create database schema export for migration.
| 
| In this step, you will create an export of your current database schema, that
| later in the process you will import into your newly built Satellite.
| 
| Run as root:
| 
|     cd /etc/sysconfig/rhn/satellite-upgrade/scripts
|     ./spacewalk-dump-schema | \
|         bzip2 -7c - | \
|         split -d -b 2147483648 - /some/storage/path/schema-dump-
| 
| Please have the schema dump files ready for import later in the process.


Actual results:
# ./spacewalk-dump-schema | \
>         bzip2 -7c - | \
>         split -d -b 2147483648 - /tmp/BACKUP-
DBI connect('rhnschema','rhnuser',...) failed: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at ./spacewalk-dump-schema line 59


Expected results:
Dump should proceed. Probably that step is meant to include pg_dump command? Or maybe I'm mistakenly in incorrect upgrade process branch?

Comment 6 Clifford Perry 2015-01-13 11:06:42 UTC
NOTE: With the release of Red Hat Satellite 5.7 on January 12th 2015 this bug /
feature is resolved. This bug was not verified (moved to RELEASE_PENDING)
prior to release. As such, over the next week or so we plan to confirm the
valiation that this was indeed fixed as part of the release and then move to
Closed Current Release. 

The Satellite 5.7 GA Errata:
 - https://rhn.redhat.com/errata/RHSA-2015-0033.html 

Satellite 5.7 Release Notes:
 -
https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.7/html-single/Release_Notes/index.html

Satellite Customer Portal Blog announcement for release:
 - https://access.redhat.com/blogs/1169563/posts/1315743 

Cliff