Last active
August 29, 2015 14:06
-
-
Save AmrAbdeen/4295d5d23ba8a8e3c736 to your computer and use it in GitHub Desktop.
ORACLE PL/SQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Select constraint | |
select * from all_constraints | |
where constraint_name = 'T_CUST_PASS_CK' | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- To change lisetner port .. | |
SQLPLUS /NOLOG | |
At the SQL Command Line prompt, enter the following command: | |
CONNECT SYSTEM/password | |
--where password is the SYSTEM password that you set upon installation (Windows) or configuration (Linux) of Oracle Database XE. | |
At the SQL Command Line prompt, enter the following command: | |
EXEC DBMS_XDB.SETHTTPPORT(nnnn); | |
--where nnnn represents the new port number to use for HTTP connection requests. Be certain that you select a port number that is not already in use. | |
--For example, to use port number 8087 for HTTP connection requests, enter this command: | |
EXEC DBMS_XDB.SETHTTPPORT(8087); | |
--If the command is successful, the following message is displayed: | |
--PL/SQL procedure successfully completed. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sqlplus /nolog | |
connect / as sysdba | |
Once connected, you can change the SYS password to something you know: | |
ALTER USER sys IDENTIFIED BY new_password; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment