This discussion is archived
1 Reply Latest reply: Aug 16, 2011 7:01 AM by 843228 RSS

Blank screen after cloning database

843228 Newbie
Currently Being Moderated
EDIT: Please see our reply - Things have changed

Hello,

we cloned a working and fully functional database with apex 4 installed on the same host (Note 228257.1).
The cloned database seems to work normally but apex/the browser shows only a blank/white screen and "redirects" to /pls/clone*/apex* instead of showing the apex pages on /pls/clone (without /apex) like in the normal environment.
We use the Oracle 10GR2 http server (on a different machine).

When we shutdown the clone-instance and call /pls/clone we get an 503 (Temporarily Unavailable)
When we call /pls/clone/apex_admin and we get an "Object not found" error.

Here is the part of the dads.conf on the http server:
<Location /pls/clone>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_manager.process_download
PlsqlDatabaseConnectString XXX.yyy.de:1521:DBCLONE
PlsqlNLSLanguage GERMAN_GERMANY.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword htmldb
PlsqlCGIEnvironmentList AUTHORIZATION
Allow from all
</location>
And here the listener / tnsnames.ora part (same on http server and database host)
DBCLONE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(PORT = 1521))
(CONNECT_DATA =
# (SERVER = DEDICATED)
(SERVICE_NAME = DBCLONE)
)
)
A connection via sqlplus user/pass@DBCLONE works (from both servers).

What is the problem? We also tried to connect in the dads.conf via
PlsqlDatabaseConnectString DBCLONE
instead of
PlsqlDatabaseConnectString XXX.yyy.de:1521:DBCLONE
but it did not help either.

Regards
Daniel and Michael

Edited by: MJosten on 16.08.2011 01:35

Edited by: MJosten on 16.08.2011 06:57
  • 1. Re: Blank screen after cloning database
    843228 Newbie
    Currently Being Moderated
    We discovered that the database cloning did not succeed completely because the tempfile was not set correctly.

    So we dropped the database clone and cloned again - This time without errors.

    Still APEX does not work correctly but the error has changed:
    1) We get a "Object not found error" (http 404) instead of the white screen
    2) When we type "/pls/clone" a page and sessionid is appended to the url automatically (/pls/clone/f?p=4500:1:3433434343)
    3) We tried to call a public procedure via http (like f is included in APEX_040000 our test procedure was in another scheme) and it works

    But why does apex seem to work but you only see "Object not found"!?

    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points