Saturday 27 February 2016

Database startup/shutdown process in oracle 11g Database

First setup oracle Database Enviornment
then do the activities as startup/shutdown process:
-----------------------------------------------------------------------------------

[oracle@r12ebs ~]$ . 1122.env
[oracle@r12ebs ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sun Feb 28 11:54:12 2016

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting up database:
SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size            2233336 bytes
Variable Size          675286024 bytes
Database Buffers      377487360 bytes
Redo Buffers           13930496 bytes
Database mounted.
Database opened.

Stopping Database:

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.


Monday 8 February 2016

To know Oracle Apps Login URL in Oracle Application

select * from  icx_parameters --HOME_URL

And Default UserName: operations
                    Password: welcome

Script to update salespersons customer site wise in oracle apps R12

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'DEENA VISION%'; SELECT * FROM HZ_CUST_ACCOUNTS_ALL WHERE PARTY_ID =94043 ; SE...