Category Archives: tips

Copying files from ASM to File System

Working with Oracle technology is common to have two ways to do something, in this case move files from ASM storage to file system storage. We can do this job with rman or inside asmcmd.

Continue reading

ORA-00020: maximum number of processes: cannot connect as sysdba?!

Database reach max process or sessions, son no new login is available, first your sysadmin cant  access too for solve the problem seting new process value, is a production  enviroment so we dont want to kill the instance as a first step to solve the problem .

Continue reading

How to change DataBase Name

Since Oracle 9i ORACLE give us DBNEWID. Is utility that can change the internal database identifier (DBID) and the database name (DBNAME).

Prior to the introduction of the DBNEWID utility, alteration of the internal DBID of an instance was impossible and alteration of the DBNAME required the creation of a new controlfile. The DBNEWID utility allows the DBID to be
altered for the first time and makes changing the DBNAME simpler.

Continue reading

A Round trip with Oracle Particioning


We are going to make a trip arround partiotioning in Oracle, why use partitioning?, types, despartitioning, how check some info about particioned tables…allways usefull tips for use day to day at work.

Continue reading

Oracle 10g Client on Windows 7

So we want use old sqlplusw, cause is light, fast than any sql developer for some admin duties, but wait! ORACLE baned this software since Oracle 11g, but no problem you can donwload from here 10.2.0.4 client. This client bring a compatibility problem with windows 7 for solve ….

Continue reading