TEXT   26

oracle.txt

Guest on 4th June 2021 09:11:33 AM

  1. 0. configuration depencies follow http://docs.oracle.com/cd/E11882_01/install.112/e48740/toc.htm
  2. 1. Dowload Oracle from official website and extrack.
  3. 2. (Improtant)Make dir /u01 to top levle, and type "smit mklv" for add logical partition finish and type "smit crfs_j2" for mount dir to logical partition
  4. 3. Type su - root and run rootpre.sh -- finish exit and run ./runInstaller ... finish.
  5. 4. Followign configuretion in .profile oracle user
  6.  
  7. ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
  8. ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
  9. LIBPATH=$ORACLE_HOME/lib; export LIBPATH
  10. LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib; export LD_LIBRARY_PATH
  11. ORACLE_SID=STFS; export ORACLE_SID
  12.  
  13. 5. Run $ORACLE_HOME/bin/netca for configuration network
  14. 6. Run $ORACLE_HOME/bin/dbca for new database and configuration SID, USER, PASS ... , etc,. for connect database.
  15. 7. LISTENER
  16.  
  17. lsnrctl start
  18. lsnrctl stop
  19.  
  20. 8. DB
  21. --
  22. sqlplus /nolog
  23. conn system/oracle@TEST
  24. --
  25. source .profile
  26. ORACLE_SID=STFS; export ORACLE_SID --- ORACLE_SID=TEST; export ORACLE_SID
  27. sqlplus "/ as sysdba" -- Login
  28. STARTUP -- for start db
  29. SHUTDOWN IMMEDIATE -- for stop db
  30. --
  31. 9. Test connect from client.
  32. 10. Have fun :)
  33. ===Power by PON===
  34. sqlplus system/oracle@STFS
  35. sqlplus system/oracle@TEST
  36.  
  37. https://10.30.2.50:1158/em/console/logon/logon = STFS
  38. https://10.30.2.50:5500/em/console/logon/logon = TEST
  39.  
  40.  
  41. select username,account_status,EXPIRY_DATE from dba_users where username like 'SYS%';
  42.  
  43.  
  44. http://10.30.2.50/

Raw Paste


Login or Register to edit or fork this paste. It's free.