Bug 146212
Summary: | Need updated schema on MTV Oracle instance | ||
---|---|---|---|
Product: | [Retired] Red Hat Network | Reporter: | Mike McCune <mmccune> |
Component: | RHN/R&D | Assignee: | James Slagle <jslagle> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Red Hat Satellite QA List <satqe-list> |
Severity: | medium | Docs Contact: | |
Priority: | medium | ||
Version: | RHN Devel | ||
Target Milestone: | --- | ||
Target Release: | --- | ||
Hardware: | All | ||
OS: | Linux | ||
Whiteboard: | |||
Fixed In Version: | rhn370 | Doc Type: | Bug Fix |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2005-09-27 19:51:56 UTC | Type: | --- |
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: | 125080 |
Description
Mike McCune
2005-01-26 00:23:39 UTC
james... not sure what's the best way to go about this... either a complete schema refresh from the build system, or a TOAD diff + script. Heh, even if we use the build system, we'll probably need a diff anyway. So might not be bad to see how far from reality a "pristine" hosted schema would be from stage. Just as a headsup, I tried to connect to the box with the following tnsnames entry: webdev2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = test-db-1.nplab.redhat.com) (PORT = 1521)) ) (CONNECT_DATA = (SID = webdev2) ) ) using: yasql rhnuser/rhnuser@webdev and got: Attempting connection to rhnuser@webdev2 Error: Could not connect to database: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [12541] I logged into the box (standard RHN root password) and poked around. Oracle was listening on 1521, I stopped/started oracle with the init.d script but it still wouldn't accept my connection. Any assistance on getting the listener to respond to requests would be great. Mike, usually there are two parts to Oracle. The database and the TNS Listener. Sounds like you bounced the DB but not the listener. I got the db/listener started. I successfully connected remotely. Although I had to put the following in my tnsnames: webdev2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = calistoga.nplab.redhat.com) (PORT = 1521)) ) (CONNECT_DATA = (SID = webdev2) ) ) It didn't seem to like test-db-1 as the host. calistoga and test-db-1 both resolve to the same IP. Mike, what version of the scheam do you want loaded? The latest 3.6 version? Dropped all objects in webdev2 instance. Intalled the latest 3.7 satellite schema. All of the objects are owned by the rhn user. Let me know if you have any problems. This was completed. |