Bug 1168016 - upgrading 5.6.0 with embedded PostgreSQL including OS upgrade fails on spacewalk-dump-schema with: ORA-12154
Summary: upgrading 5.6.0 with embedded PostgreSQL including OS upgrade fails on spacew...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Upgrades
Version: 570
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Jan Hutař
URL:
Whiteboard:
Depends On:
Blocks: sat570-upgrades
TreeView+ depends on / blocked
 
Reported: 2014-11-25 21:22 UTC by Jan Hutař
Modified: 2015-01-22 09:10 UTC (History)
2 users (show)

Fixed In Version: rhn-upgrade-5.7.0.21-1
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-01-22 09:10:44 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

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


Note You need to log in before you can comment on or make changes to this bug.