Application Express :: Migrate From One Server To Newer Server
Jun 7, 2013
I'm trying to migrate an Apex Application from one server to a newer server . My custom app I used the theme from Go Live CheckList samples....
Well, when trying to install that application I get 'Insufficient space to install application ' with a BIG red X... I was able to install other Package Application except for the one I need and now my application errors out because of some shared Themes. At first I thought it was a DB thing so I downgraded back to 10g from 11....but that didn't work... Apex works fine...
Other samples work fine...Version Apex 4.2.2 and Oracle XE 10g...
View 3 Replies
ADVERTISEMENT
Oct 23, 2011
In My Organization we are using Oracle Application server now we want to introduce Weblogic server.
Here we have 2 web servers and 3 application servers.
Now we want migrate to weblogic server.. Ho can we migrate to Weblogic server.
View 2 Replies
View Related
Oct 31, 2012
I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .
View 22 Replies
View Related
Jul 11, 2011
Here are the cards I've been dealt:
I've inherited a 10.2.0.1.0 instance running on a windows 2003 box; running fine, no problems other than system has been in production since 2005 and has gotten pretty old and tired. This old box has one tablespace on it... called "gateway".
I've installed 11.2.0.1 on a new (Windows 2008 R2 Enterprise 64-bit) server and created an empty database also called "gateway".
Now to move the data and views, objects, everything.
I've read up on a variety of migration techniques (oops, I mean "upgradation" LOL) and can follow the steps...
In short, I want to pull everything off of server a (10.2) and put it into production on server b (11.2). There seems to be quit a few options.
1. install 10.2 on my NEW server (server b), move the data over and get everything running, then install 11.2 and have it upgrade the database as part of the installation process.
2. drop the empty tablespace on server b, stop the database on server a, copy the files over from the old to the new home, run DBUA or set the compatibility attribute...
3. run some type of server a to server b utility that can bridge the two over the network. Some type of mirroring technique?
4. run file export scripts on server a, copy files to server b and run various import scripts
I tend to think that option 3 would be the best because both instances are in great health and are running right now. Is there a mechanism that allows the 11.2 instance to see and upgrade from a different server?
View 9 Replies
View Related
Jun 28, 2012
Apex 4.0 and 4.1
I have 2 apps App1 and App2.I create a tab "TAB1" with 4 pages (1,2,3,4) in App1.I want to import it to App2 but its has already its own pages(1,2,3,4)
Will the import handle this issue?
View 3 Replies
View Related
May 20, 2013
I did the following to migrate.
1. After the installtion of Oracle 9.2 I created the service using oradim.
2. Should I need to copy my old datafiles to 9.2 before using the migrate option?
3. Should I need to startup the database before migrate?
View 1 Replies
View Related
Mar 5, 2010
We have and oracle 8i database that has an application that has part of it developed by PL/SQL and the other part on portal 309,is it possible to convert to MS/Sql Database,what tool can we use or what steps do we have to go through to achieve this.
View 1 Replies
View Related
Aug 8, 2012
My requirement is we are planning to migrate the sql server data to oracle. what is the way to do migration from sql server to oracle. if any tools are there for migration.Previous we used sql developer( which is provided by oracle i.e. freeware ) tool but it was created only table structures not ported any data.
View 3 Replies
View Related
Dec 1, 2011
how to migrate a table from 10g xe database to a oracle9i database.Both the database are stand alone and we cannot create a dblink.
View 2 Replies
View Related
Feb 1, 2013
I need to migrate data from oracle server to MySql.
View 14 Replies
View Related
Jul 11, 2012
I have to migrate two different databases to oracle.i have made two Migration Repository for each to do the migration, migration is done.but i would like to know can it be done with one migration repository.if yes then with one is best way to do it.data of two databases is different but table and sp are 99% same.
View 3 Replies
View Related
Jan 3, 2012
I am trying to use the datapump tool to migrate a 10g db to 11g. Everything works fine except for the "nameless" check constraints.
View 7 Replies
View Related
Oct 31, 2012
I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server...So far i have just installed the oracle software on 64bit windows 2008 server.how to move the data or migrate from old server to new server..
View 1 Replies
View Related
Mar 10, 2011
I am looking to migrate and upgrade an Oracle 9i database to 10g.
Would there be any fallout if the characterset were changed from US7ASCII to UTF8?
View 2 Replies
View Related
Oct 27, 2012
after my first Apex installation I have got the above mentioned error. I have tried the following Apex calls:
localhost:7778/apex
localhost:7778/apex/apex_admin
Instead of using localhost I used the hostname or the IP address of the box without success.The whole installation process went fine from scratch. No errors, no warnings, nothing.I am using the following environment:
CentOS 6.3
Oracle 11.2.0.3 EE
Apex 4.1.1
With exec dbms_xdb.sethttpport(7778); I enabled the above port number. If I look at the output of the lsnrctl status I see that my local listener is also listening on 7778. I have no errors in the alert.log and no other trace files where I can have a look at.
View 1 Replies
View Related
Dec 17, 2012
I want to create a DB job on APEX Server-1, when runs every 30 mins and on finding records, invokes an API available on another APEX Server-2 passing the parameters from Server-1. How do I achieve this ?
View 3 Replies
View Related
Jun 6, 2012
APEX 4.0.2.00.07
Oracle 10.1.2.0.0
I have 2 workspaces, the one regard as Dev env, another regard as Pro. env. When the change need to be migrated, the some page of Dev workspace should be copy to Pro. one. I export the pages what I want to move from Dev., then try to import it into Pro. but I get the error as below:
Page Origin: This page was exported from a different application or from an application in different workspace. Page cannot be installed in this application. I don't want to copy the page one by one.
View 16 Replies
View Related
Jun 13, 2013
how to migrate sql server database to oracle database?
View 2 Replies
View Related
Aug 6, 2012
How could i redirect to an url in apex? I tried with adding google.com in target url but it shows
Not found
The requested URL /apex/[URL]....was not found on this server
how to assign it?
View 4 Replies
View Related
Jul 4, 2012
I need to write a procedure to migrate files from Collaboration plum tree server to oracle database server into a table using a BLOB column .
View 2 Replies
View Related
Aug 4, 2011
I am using expdp/impdp to migrate 4 TB database from solaris to Linux.But the import process is taking forever.
View 13 Replies
View Related
Dec 5, 2012
I'm trying to create a web service via the WSDL wizard (Apex 4.0.2). We are behind a firewall and connect to the internet via a proxy server. The proxy server requires authentication with a username and password. How to include the username and password in defining the Proxy Server in the Application Definition page or optionally in the alternate location in the Manual Web Service wizard page?
I assume the base definition for the proxy server is [http://]host[:port][]
View 2 Replies
View Related
Aug 1, 2012
I'm having some difficulty securing my Oracle APEX + Oracle HTTP Server environment.
There are currently around 20 Applications running on the APEX Server, and I'd like to publish 2 of them Externally for users.
I have added a certificate to Oracle Wallet Manager to secure the OHS, but I can access all the Applications on the APEX Server by just changing the Application ID suffix.
How can allow only two applications to be accessible via the internet?
View 11 Replies
View Related
Sep 28, 2012
I am trying to use embedded weblogic server for creating an LDAP authtication secheme but it is not working
I believe that embedded ldap server works on the same port as the admin server of the domain but configuring it has been a pain. I got the following code from forum to test the ldap connection
declare
l_retval pls_integer;
l_retval2 pls_integer;
l_session dbms_ldap.session;
l_ldap_host varchar2(256);
[code]........
Every time I run this, I get the following error
ldap session : 01000000(returned from init)
error: ORA-31202: DBMS_LDAP: LDAP client/server error: Invalid credentials
-31202
View 0 Replies
View Related
Mar 6, 2013
Environment:
Apex 4.2
DB 11gR2
I've started using Apex 4.2(new to Apex). I have built a form based on a table with a date column on it. The form allows update on all fields/columns of the base table. For the date field/column, the goal is to present the user with sysdate on load and update the date with sysdate if the record is changed any of the fields. How can I accomplish this?
View 7 Replies
View Related
Dec 4, 2012
I have installed Oracle 11g XE . After this , i have upgraded to Apex 4.2 All it's working fine, but..... by default XE installs and configure apex to use embebed pl/sql gateway.
In this scenario, the images are stored directly in the database within the oracle XML DB repository. This may be a problem because XE have a 11GB limit and my apex aplication is simple, but it may upload pictures for customers, etc, and in this schenma the pictures will consume space in the database instead consuming in the linux filesystem.Can i install HTTP server in a 11g XE and reconfigure apexr?, or can i change to apache+listener? or more easy....can i upload images outside the XML DB in my apex application easily?
View 1 Replies
View Related
Nov 7, 2012
We have Oracle DB 11g.I want to develop a small application for internal use the company.I have used Oracle Application Express workspace provided by Oracle and I thought of using Oracle Apex is the right tool for our internal reporting.
But I am not sure what is needed in order to start developing the application in-house.What should I check with the DBA team in order to find out if I can use Oracle APEX in the organization.Is there any prerequisites, web Server, etc that is needed in order to use Oracle Apex?
View 4 Replies
View Related
Dec 15, 2012
I have been learning to create pdf report with Apex 4.2 and BI Publisher 10 which I have been successful with. Now I like to learn how to create pdf reports using FOP thinking of the customers who will not spend money on BI Publisher. I have gone through the documents and procedures described in Java 4 Less. [URL] and [URL]. Configured Apex instance setting accordingly.
For default layout a tabular pdf report is created. I have created an xsl-fo file named Formatted_report.fo on same query and xml file from report query with BI Desktop. But when I try to print a formatted output with Formatted_report.fo report layout it does not work(J4LFOPServer ). but same layout with .rtf template works fine (BI Publisher Print Server).
View 2 Replies
View Related
Aug 27, 2012
when i try to login to apex for first time (10.10.0.170:5555) it asked about server XDB username and password,i dont know which username and password i can use
View 4 Replies
View Related
Sep 19, 2012
I want my application to provide an end-user with ability to upload the files from their machine to SFTP server directly. So far, I have managed to write the function which uses java source and allows to upload files from the database. It works just fine.
The function looks as follows:
FUNCTION SFTP_CMD (
V_USER IN VARCHAR2,
V_PASS IN VARCHAR2,
V_HOST IN VARCHAR2,
[code]..
where V_FILE_SRC represents location of the file to be uploaded. The thing is that the FILE BROWSE apex item does not allow to specify the file location, it identifies it somehow automatically, when you press the button 'Choose file'. The question is how can I catch file's path, so that I can pass it to V_FILE_SRC parameter in my function? Should I write my own plugin? or hack FILE BROWSE item? =)
View 2 Replies
View Related
