I wanted to take a moment to express my heartfelt appreciation for the immensely helpful Oracle Apex 23.1 Installation video you shared on your channel. Your clear and concise instructions made the installation process seamless and straightforward, even for those of us who are relatively new to this technology. The comprehensive guidance you provided, along with the step-by-step demonstration, enabled me to set up Oracle Apex 23.1 without any hiccups. Your video not only simplified the otherwise intricate installation process but also instilled confidence in navigating the various stages of the setup. Your expertise and dedication to delivering such valuable content are truly commendable. I am grateful for the time and effort you put into creating this insightful tutorial. Your video has undoubtedly enhanced my understanding and proficiency in handling Oracle Apex 23.1. Once again, thank you for your exceptional contribution. I look forward to exploring more of your enriching content in the future.
Ahmed, I wanted to take a moment to express my deepest gratitude for the video you shared with us. It arrived precisely when we needed it the most, and I must say, it has made a tremendous impact on our development team. Your video provided us with valuable insights and guidance on setting up an Apex environment, a task that seemed daunting and time-sensitive for us. Your clear instructions and step-by-step demonstration made the entire process much more accessible and manageable. We were able to swiftly create the environment we required, thanks to your expert guidance. The timing of your video could not have been more perfect. With the upcoming week being crucial for our development team, we were feeling the pressure to establish the necessary Apex environment quickly. Your video not only alleviated our concerns but also gave us the confidence to tackle the task with ease. I particularly appreciate the thoroughness of your explanations. You ensured that we understood the rationale behind each step, enabling us to gain a deeper understanding of the Apex environment setup. This comprehensive approach was instrumental in empowering our team members to grasp the concepts fully and troubleshoot any potential issues effectively. Ahmed, you have truly gone above and beyond with this video. It has proven to be an invaluable resource for our dev team, and I cannot emphasize enough how grateful we are for your contribution. Your expertise, clear communication, and perfect timing make you a true asset to our community. Once again, thank you for your exceptional video. We look forward to more of your insightful content and the positive impact it will undoubtedly have on our team's growth and success.
Dear Ahmed, Thanks for this video. It came at the right time for me. My dev team need Apex environment for the next week. I discussed in the past with you will right you in private. Thanks
Hi, what the magic happens on 6:45?? I downloaded all .zip files to my catalogue, open command prompt and you have suddenly somethig like SYS@DEMO....you are already connected to your local database?? That's the part I wanted to get to know haha. Is it SQLCL (Command lin?) Cheers
So is it possible to use existing oracle database with Apex installation? In my project I have a oracle 19c db installed on linux host...we are creating packages, procedures tables etc in that db, and i need to use that database in Apex application building? Is this possible? Can't we establish database connection like how we connect to diff db in sql developer?
Is there additional configuration if the Oracle DB and APEX are installed in a separate server? I have installed the ords in my machine, i get the home page but when i click the login button no action has been done in the page
Mr. Ahmed I am facing problem when tring to install ords After entering database hostname [localhost] Listen port 1531 Service name It tells me Failed to connect to user :
ORA-06550: line 2, column 5: PLS-00201: identifier 'WWV_FLOW_INSTANCE_ADMIN.CREATE_OR_UPDATE_ADMIN_USER' must be declared ORA-06550: line 2, column 5: PL/SQL: Statement ignored
getting error as 'java' is not recognized as an internal or external command, operable program or batch file. on ords installation steps, what could be the reason?
To install jdk-11.0.20_linux-x64_bin.rpm as the root user, please follow these steps: Download the Java JDK file. Open the terminal and navigate to the folder where the JDK file is located. Use the following command: bash rpm -i jdk-11.0.20_linux-x64_bin.rpm This command will initiate the installation process for the JDK file."
@@baekhos_Look For this command to work, your database should be configured to use oracle managed files feature, otherwise you must specify a full-path filename.
you need to specify datafile name with location like below command CREATE TABLESPACE TABLESPACE_NAME DATAFILE '/u01/oracle/PROD/db/apps_st/data/datafile_name.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE 1G;
I wanted to take a moment to express my heartfelt appreciation for the immensely helpful Oracle Apex 23.1 Installation video you shared on your channel. Your clear and concise instructions made the installation process seamless and straightforward, even for those of us who are relatively new to this technology.
The comprehensive guidance you provided, along with the step-by-step demonstration, enabled me to set up Oracle Apex 23.1 without any hiccups. Your video not only simplified the otherwise intricate installation process but also instilled confidence in navigating the various stages of the setup.
Your expertise and dedication to delivering such valuable content are truly commendable. I am grateful for the time and effort you put into creating this insightful tutorial. Your video has undoubtedly enhanced my understanding and proficiency in handling Oracle Apex 23.1.
Once again, thank you for your exceptional contribution. I look forward to exploring more of your enriching content in the future.
Ahmed,
I wanted to take a moment to express my deepest gratitude for the video you shared with us. It arrived precisely when we needed it the most, and I must say, it has made a tremendous impact on our development team. Your video provided us with valuable insights and guidance on setting up an Apex environment, a task that seemed daunting and time-sensitive for us. Your clear instructions and step-by-step demonstration made the entire process much more accessible and manageable. We were able to swiftly create the environment we required, thanks to your expert guidance.
The timing of your video could not have been more perfect. With the upcoming week being crucial for our development team, we were feeling the pressure to establish the necessary Apex environment quickly. Your video not only alleviated our concerns but also gave us the confidence to tackle the task with ease.
I particularly appreciate the thoroughness of your explanations. You ensured that we understood the rationale behind each step, enabling us to gain a deeper understanding of the Apex environment setup. This comprehensive approach was instrumental in empowering our team members to grasp the concepts fully and troubleshoot any potential issues effectively.
Ahmed, you have truly gone above and beyond with this video. It has proven to be an invaluable resource for our dev team, and I cannot emphasize enough how grateful we are for your contribution. Your expertise, clear communication, and perfect timing make you a true asset to our community. Once again, thank you for your exceptional video. We look forward to more of your insightful content and the positive impact it will undoubtedly have on our team's growth and success.
Thanks Hila for your nice words and I'm really happy that my video was valuable to you and your team.
Thanks again
Ahmed
Very useful information indeed
Dear Ahmed,
Thanks for this video. It came at the right time for me. My dev team need Apex environment for the next week.
I discussed in the past with you will right you in private.
Thanks
Hi, what the magic happens on 6:45?? I downloaded all .zip files to my catalogue, open command prompt and you have suddenly somethig like SYS@DEMO....you are already connected to your local database?? That's the part I wanted to get to know haha. Is it SQLCL (Command lin?) Cheers
Exactly that's where I'm at. I can't proceed after that
@@yonatan356 same
Did you solve?
@@tomislavtlak4883 in my case problem was in system administrator Access rights... I didn't have relevant ones
Cheers
Perfect! Thank You.
Thanks for the video. Is there a tutorial on how to install Pre-created pluggable Oracle Database ? Thanks again
which password has been used at 16:26 for ords installation? none is working. please help.
So is it possible to use existing oracle database with Apex installation? In my project I have a oracle 19c db installed on linux host...we are creating packages, procedures tables etc in that db, and i need to use that database in Apex application building? Is this possible? Can't we establish database connection like how we connect to diff db in sql developer?
Is there additional configuration if the Oracle DB and APEX are installed in a separate server?
I have installed the ords in my machine, i get the home page but when i click the login button no action has been done in the page
Mr. Ahmed
I am facing problem when tring to install ords
After entering database hostname [localhost]
Listen port 1531
Service name
It tells me
Failed to connect to user :
After restarting the system localhost refused connection. Please describe solution of this error.
ORA-06550: line 2, column 5:
PLS-00201: identifier 'WWV_FLOW_INSTANCE_ADMIN.CREATE_OR_UPDATE_ADMIN_USER'
must be declared
ORA-06550: line 2, column 5:
PL/SQL: Statement ignored
when I put create tablespace apex datafile size 200M autoextend on next 10m maxsize unlimited;
*
ERROR at line 1:
ORA-02236: invalid file name
For this command to work, your database should be configured to use oracle managed files feature, otherwise you must specify a full-path filename.
@@amfattah2011 thanks, I will verify 🙏
@@amfattah2011 how i can find the full path name? I don't know where the file apex.dbf exist
getting error as
'java' is not recognized as an internal or external command,
operable program or batch file.
on ords installation steps, what could be the reason?
To install jdk-11.0.20_linux-x64_bin.rpm as the root user, please follow these steps:
Download the Java JDK file.
Open the terminal and navigate to the folder where the JDK file is located.
Use the following command:
bash
rpm -i jdk-11.0.20_linux-x64_bin.rpm
This command will initiate the installation process for the JDK file."
Asslam o Alaikum,
Sir,
Can i install without using pdb?
Yes, you can
Where to run the command in the Excel file
Does changing admin password necessary?
how to resolve this "D:\ORACLE_APEX\ORDS>java -jar ords.war simple
Warning: Support for executing: java -jar ords.war has been deprecated."
Brother it seems you are using older version of JAVA
when I put create tablespace apex datafile size 200M autoextend on next 10m maxsize unlimited;
*
ERROR at line 1:
ORA-02236: invalid file name
An error occurs saying that the file name is inappropriate. I need a specific way to solve this, can you tell me in detail?
@@baekhos_Look For this command to work, your database should be configured to use oracle managed files feature, otherwise you must specify a full-path filename.
you need to specify datafile name with location like below command
CREATE TABLESPACE TABLESPACE_NAME DATAFILE '/u01/oracle/PROD/db/apps_st/data/datafile_name.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE 1G;