Tech-Today
We assume that you have successfully download and installed the OracleXEUniv.exe.
How to change the default http and ftp port in oracle xe univ
1.) Click Start->Run
2.) Type C:\Windows\System32\sqlplus system@xe
3.) Enter the admin password
4.) Enter the following command:
You should get this result:
PL/SQL procedure successfully executed
Restart the oracle instance.
Note: Don't use @ character in the password.
- How To Import And Export A Database Dump In Oracle
The following instruction will help us in importing and exporting our oracle database. Create and restore dump file (http://www.database.fi/2011/05/using-expdp-and-impdp-export-and-import-in-10g-11g/)Create dump filesqlplus system/oracleSQL> create...
- How To Setup Toad Oracle Freeware
The following article will help us in configuring our Toad Oracle Freeware with Oracle XE database. For development purposes I normally use XE so it's light. Steps: Download and install Oracle XE - I use 10.2.xI installed in: C:\java\oraclexeDownload...
- How To Port Forward Apache's 80 To Glassfish's 8080 Using Proxy Configuration
Recently, I'm developing and testing an application deployed on Glassfish that runs on port 8080. Then I do need the app to run on port 80, since I don't want to change the default port of Glassifh from 8080 to 80, I've just installed apache...
- How To Create A Connection Pool For Postgresql On Glassfish 3.1.1
This tutorial assumes that 1.) You already have Glassfish 3.1.1 installed. https://blogs.oracle.com/java/entry/glassfish_3_1_1 2.) Create and start a Glassfish domain a.) asadmin create-domain czetsuya b.) asadmin start-domain czetsuya...
- Ora-12519, Tns:no Appropriate Service Handler Found
I often encountered this error after setting up a new machine with jboss/seam/oracle project installed. To resolve this: 1.) Open command prompt, by typing cmd in Start 2.) Execute c:\windows\system\sqlplus system@YOUR_SID 3.) Execute "ALTER SYSTEM SET...
Tech-Today
How to change the default http and ftp port in oracle xe univ
We assume that you have successfully download and installed the OracleXEUniv.exe.
How to change the default http and ftp port in oracle xe univ
1.) Click Start->Run
2.) Type C:\Windows\System32\sqlplus system@xe
3.) Enter the admin password
4.) Enter the following command:
>SQL begin dbms_xdb.sethttpport('9090');
dbms_xdb.setftpport('2100');
end;
/
You should get this result:
PL/SQL procedure successfully executed
Restart the oracle instance.
Note: Don't use @ character in the password.
- How To Import And Export A Database Dump In Oracle
The following instruction will help us in importing and exporting our oracle database. Create and restore dump file (http://www.database.fi/2011/05/using-expdp-and-impdp-export-and-import-in-10g-11g/)Create dump filesqlplus system/oracleSQL> create...
- How To Setup Toad Oracle Freeware
The following article will help us in configuring our Toad Oracle Freeware with Oracle XE database. For development purposes I normally use XE so it's light. Steps: Download and install Oracle XE - I use 10.2.xI installed in: C:\java\oraclexeDownload...
- How To Port Forward Apache's 80 To Glassfish's 8080 Using Proxy Configuration
Recently, I'm developing and testing an application deployed on Glassfish that runs on port 8080. Then I do need the app to run on port 80, since I don't want to change the default port of Glassifh from 8080 to 80, I've just installed apache...
- How To Create A Connection Pool For Postgresql On Glassfish 3.1.1
This tutorial assumes that 1.) You already have Glassfish 3.1.1 installed. https://blogs.oracle.com/java/entry/glassfish_3_1_1 2.) Create and start a Glassfish domain a.) asadmin create-domain czetsuya b.) asadmin start-domain czetsuya...
- Ora-12519, Tns:no Appropriate Service Handler Found
I often encountered this error after setting up a new machine with jboss/seam/oracle project installed. To resolve this: 1.) Open command prompt, by typing cmd in Start 2.) Execute c:\windows\system\sqlplus system@YOUR_SID 3.) Execute "ALTER SYSTEM SET...