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 range (1 through 32767) (1)
  • SET TRIMSPOOL ON otherwise every line in the spoolfile is filled up with blanks until the linesize is reached.
  • SET TRIMOUT ON otherwise every line in the output is filled up with blanks until the linesize is reached.
  • SET WRAP OFF Truncates the line if its is longer then LINESIZE. This should not happen if linesize is large enough.
  • SET TERMOUT OFF suppresses the printing of the results to the output. The lines are still written to the spool file. This may accelerate the exectution time of a statement a lot.
  • SET PAGESIZE 0 to set an infinite pagesize and avoid headings , titles and so on There are some other SETparamters concering output (NUMWIDTH, NUMFORMAT, LONG, COLSEP) and performance (ARRAYSIZE,LONGCHUNKSIZE)

EXP :

SET LINESIZE 320;
SET PAGESIZE 400;
SET LONG 500;;

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 Windows.

To start the dbconsole process from the command line:

  1. Navigate into your ORACLE_HOME/bin directory.
  2. Run the following statement:
    ./emctl start dbconsole
    
    

Continue reading Starting and Stopping the Oracle Enterprise Manager Console

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 /nolog
connect / as sysdba
ALTER 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 SAP* password

SQL>delete from SAPSR3.USR02 where BNAME=’SAP*’ and MANDT=000;

5. Set the parameter login/no_automatic_user_sapstar is set to 0. You also can check in RZ11. You need to reboot the SAP once the parameter is change.

login/no_automatic_user_sapstar=0

Note:

• This example shows for SAP* in client 000 in Oracle environment.
• Default password for sap* is pass / 06071992.
• Execute transaction code /$tab to reset buffer

Source: http://itsiti.com/unlock-reset-sap-password-in-oracle