How to change the port number of oracle

By -
Step 1--> Open sqlplus

Step 2-->Connect to user/password

Step 3-->Following query execute you are command prompt

exec DBMS_xdb.sethttpport('8007');

(EX)

SQL> exec DBMS_xdb.sethttpport('8007');

PL/SQL procedure successfully complied

Step 4-->After you can check oracle home page

Comments

Post a Comment

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

By -
We frequently encounter issues with concurrent programs running long and concurrent requests not picking up jobs. These problems are often expected from the development and functional team we need to address this issue To solve this, we should take the following steps: Collect below basis level of information to development team 1 Oracle seeded program/Custom program? 2 How much time it used earlier? 3 Is there any recent code change done in concurrent program? 4 Is this program fetching higher data compare to last run? 5 Does this job running any specific time/ It can be run any time? 6 Does this job fetching data using DB link? 7 Does the problem happen on both the test and production instance?   Troubleshooting Steps for Concurrent Requests Check for Locks and Blocking sessions Identify if the request is running but blocked by database locks/Blocking sessions. Use DBA tools or queries to identify and release locks if necessary. Review Parameters and Data ...
Read more

EBS R12.2 Cloning Step by step

By -
Image
I explained Cloning step by step procedure for database and R12.2 application. My Database version 11.2.0.3.0         1. Preclone db tier and application Tier     2. Copy the apps Tier  and db home only to target server     3. Take Rman full backup and copy the backup to target server            cd [RDBMS ORACLE_HOME]/appsutil/clone/bin              $ perl adcfgclone.pl dbTechStack                         Run adcfgclone dbTechStack This files are to be restored to a different location: db_file_name_convert=('/oracle/PROD/db/data' , '/oracle/CLONE/db/data') log_file_name_convert=('/oracle/PROD/db/data' , '/oracle/CLONE/db/data') $ sqlplus '/as sysdba' SQL> s...
Read more

How to Grant Privileges in Oracle EBS R12.2 Using AD_ZD.GRANT_PRIVS

By -
When working with Oracle E-Business Suite (EBS) R12.2, granting privileges to applicatation objects requires special care to avoid invalidating objects in the current edition.  Grants cannot be performed in the run edition when the application is being used. A direct GRANT (DDL) command can potentially cause object invalidation when the application is actively being used. To handle this in a more controlled manner, Oracle introduced the AD_ZD.GRANT_PRIVS utility. Why Use AD_ZD.GRANT_PRIVS? In Oracle EBS R12.2, all grants should be performed using the AD_ZD.GRANT_PRIVS procedure rather than the traditional GRANT statement.  The reason is simple: the GRANT statement directly modifies objects in the database, and this can invalidate them in the current edition. Invalidations during runtime can cause service interruptions, which is unacceptable in a live system. Syntax for Granting and Revoking Privileges The AD_ZD package provides two p...
Read more