One database with two instances of same name from same user

Hi guy’s, hope all of you doing well.Yesterday we face new issue, I would like to share same with you. In one of our development server scheduled cold backup use to happened on weekly basis.In this database while going with health check I found that two instances are running with same name & user of [...]

Read Full Post »

SAP BRTOOLS for table reorganization

** Tested with UNIX / Solarise operating system. Sorry guy’s for delay on new post.As we were on trip to GOA for one week.So now we will continue with BR Tool. So here is another one tested example for table reorganization using the BRTOOL. Hope you guys enjoy with this one as well…..!!!! bash-3.00$ /oracle/brspace -u / [...]

Read Full Post »

SAP BRTOOLS for tablespace extend

** Tested with UNIX / Solarise operating system. In our organisation SAP is front end application. So as DBA we do have exposure on BRTOOL,BRSPACE etc.So just sharing the BR tool handling issue from todays onwards. So here is one tested example for adding datafile in tablespace using the BRTOOL. Hopw you guys enjoy with this [...]

Read Full Post »

Oracle Database startup shutdown process in oracle

STARTUP Normal database operation means that an instance is started and the database is mounted and open. This mode allows any valid user to connect to the database and perform typical data access operations. Start an instance, read the initialization parameters from the default server parameter file location, and then mount and open the database [...]

Read Full Post »