tag:blogger.com,1999:blog-25740336.post7189814626467689768..comments2023-08-24T22:26:48.675+01:00Comments on The PeopleSoft DBA Blog: Using Two Temporary Tablespaces in PeopleSoftDavid Kurtzhttp://www.blogger.com/profile/00468908370233805717noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-25740336.post-50083639619842891472012-11-16T13:30:05.332+00:002012-11-16T13:30:05.332+00:00After futher checking and testing, the second data...After futher checking and testing, the second database name and TNS name (HCM91REP) is not required at all. The second schema (SYSADMRP) is selected by the second access profile which is associated with the StandbyUserId (PSAPPS2). So the StandbyDBName (HCM91) should be the same as DBName. Document updated.David Kurtzhttps://www.blogger.com/profile/08139761793598085235noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-5461630052965959452012-11-16T12:57:25.015+00:002012-11-16T12:57:25.015+00:00Hi David,
Kind of loopback, nice one, even though ...Hi David,<br />Kind of loopback, nice one, even though tricky.<br />In the linked document, shouldn't psdbowner.dbname (HCM91REP), tns entry (HCMRP) and StandbyDBName (HCM91) be identical to make all the "standby" connection use (pages 13-14)?<br />I think you also should add a link to your api code (http://www.go-faster.co.uk/scripts/psftapi.sql).<br /><br />Regards,<br /><br />Nicolas.Nicolas Gasparottohttps://www.blogger.com/profile/06634519580752248909noreply@blogger.com