Categories

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

How to make sqlplus output appear in one line

The following sqlplus commands maybe usefull:

SET LINESIZE linesize the length of the line. In most cases the maximum value for linesizeis 32767. You can find out your maximum value if you set LINESIZE to an invalid value and check the error message so SET LINESIZE 0 may give SP2-0267: linesize option 0 out of […]

Starting and Stopping the Oracle Enterprise Manager Console

To access the Oracle Enterprise Manager Console from a client browser, the dbconsole process needs to be running on the server. The dbconsole process is automatically started after installation.

However, in the event of a system restart, you can start it manually at the command line or start it as a service in […]

Enterprise Manager is not able to connect to the Database instance

How do I resolve the “Enterprise Manager is not able to connect to the Database instance.” Error?

Try the following:

Bounce the OEM console using the following:

To drop old Database console

$ emca -deconfig dbcontrol db

To recreateDatabase console

$ emca -config dbcontrol db

or:

$emca -config dbcontrol db -repos recreate

 

Reset SYS password in Oracle.

How can I recover my lost SYS password?

Sign-on to SQL*Plus without a password:

sqlplus /nologconnect / as sysdbaALTER USER sys IDENTIFIED BY “new_password”;

Unlock & Reset SAP* Password in Oracle

1. Remote Desktop (Windows) / Telnet (Unix/Linux) to OS level and connect to the sql using the command prompt.

C:\Documents and Settings\devadm>sqlplus”/as sysdba”

2. View the SAP* table.

SQL> select UFLAG, BNAME, MANDT from SAPSR3.USR02 where BNAME=’SAP*’;

3. Unlock the SAP* password.

SQL> update SAPSR3.USR02 set UFLAG=0 where BNAME=’SAP*’ and MANDT=000;

4. Reset the […]