Category: Oracle

Show Oracle Database DBID

The database ID or DBID is a unique identification number computed when the database is created. To find out this number, you can either: 1) Login to RMAN,  it will display the DBID upon connection to the target database.     e.g. shell> rman target / or 2) You can obtain the DBID by querying V$DATABASE    eg.  […]

Changeing an Oracle database character set

Check what character set you are using at the moment. SQL> select value from v$nls_parameters where parameter=’NLS_CHARACTERSET’; Shutdown the database. SQL> shutdown immediate; Startup in mount mode. SQL> startup mount; Restrict the database. SQL> alter system enable restricted session; Check the current job_queue_processes setting. SQL> show parameter job_queue_processes; Set it to 0 for now. SQL> […]

Using cpio

Some files that you get from Oracle download come in cpio format. Here’s what to do with them. First unzip the files: gunzip lnx_920_disk1.cpio.gz gunzip lnx_920_disk2.cpio.gz gunzip lnx_920_disk3.cpio.gz Next unpack the contents of the files: cpio -idmv < lnx_920_disk1.cpio cpio -idmv < lnx_920_disk2.cpio cpio -idmv < lnx_920_disk3.cpio

Next Page »