Creating/Changing Administrative Credentials
TipAdmin is the default Instance administrator account. As a post installation step, administrators can run the script apxchpwd.sql to create one or more Instance administrator accounts or change passwords for these accounts.
Step - 1
Run SQLPlus in command line
C:\>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 27 10:35:46 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
Step - 2
Locate and Run apxchpwd.sql script at SQL prompt. In my it is located at installed folder of apex as C:\oraclexe\app\oracle\product\11.2.0\server\apex\apxchpwd.
SQL> @C:\oraclexe\app\oracle\product\11.2.0\server\apex\apxchpwd
Enter a value below for the password for the Application Express ADMIN user.
Enter a password for the ADMIN user [] (enter the passward for admin user which you want to be altered)
Session altered.
...changing password for ADMIN
PL/SQL procedure successfully completed.
Commit complete.
SQL>
Step - 3
Enter link in browser http://127.0.0.1:8080/apex/apex_admin
Enter username as admin and password which you altered above in step - 2.
Apex will offer change password for the first time you login as Administrative Services for security purpose to qualify the standard password rules. First enter current password then changed password and lastly confirm changed password.
When this password is accepted then you have successful to change admin password and remember it. By observing the screen you will find that now you have fully controlled environment of apex.
Creating a Workspace
First install oracle apex.Run oracle apex by entering the link in your browser. In my case I am using chrome and entered the link http://127.0.0.1:8080/apex/f?p=4950:1:2398160260894482.
Login as a database user which has been granted the DBA database role (for example, SYSTEM).
Enter Database Username means Workspace name
Enter Application Express Username
Enter Password and Confirm Password
Click Create Workspace
Enter Application Express Username
Enter Password and Confirm Password
Click Create Workspace
Click on click here.
Cheer!
Video Link.....
Video Link.....
Click Application Builder
Video Link.....
Removing a Workspace
Run oracle apex by entering the link in your browser. In my case I am using chrome and entered the link http://127.0.0.1:8080/apex/apex_admin
Enter Application Express internal administration credentials
Click Manage Workspaces
Under workspace action click Remove Workspace
Click List Item to select the name of workspace to be removed
Click Next
Click Check Box as confirmation to delete the number of applications and users in workspace selected
Click Remove Workspace after observing the database objects.
Creating an Application in a Workspace
First install oracle apex.
Run oracle apex by entering the link in your browser. In my case I am using chrome and entered the link http://127.0.0.1:8080/apex/f?p=4950:1:2398160260894482.
Click Application Express
Login as a database user which has been granted the DBA database role (for example, SYSTEM).
Click Already have an account? Login Here
Enter Application Express workspace and credentials.
Click Application Builder
Click Create
Select application type: Database, Websheet, Sample Applications and Click Next
Select From Scratch or From Spreadsheet and click Next
Enter an application name and an unique application ID. Then, select an application creation method and a schema. Click Next
To Add Page Select Page Type: and Click Add Page
Click Create
Again Click Create
Click Application Builder where you can see the application you have created
Click Application you have created just now then you will see two pages already created in this application i.e. Login page and other one.
Video Link.....
Deleting an Application in Workspace
Click Application Builder
Click application which you have created
Click Edit Application Properties
Click Delete
Click Permanently Delete Now
Video Link.....
No comments:
Post a Comment