Monday 3 June 2013

Please provide Output of the script cstcheck.sql need to upload to oracle.


1)Download script from metalink.oracle.com site
2)Move to server
3)Execute the script in apps schema.
4)Give the output to user and user upload the file to oracle.

SQL> show user
USER is "APPS"
SQL> select name from v$database;

NAME
---------
EBSOLTP1

SQL> @cstcheck.sql


Enter value for customer:IBM_INTER

/bin/INCTGL: No such file or directory

End of Diagnostic Report. Look for CstDiag115.txt in user's current directory.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ pwd


It will generate text file (CstDiag115.txt)give it to user and user will upload to oracle.

-rwxrwxrwx 1 oraoltp1 dbaoltp1 122 May 29 23:29 comm.lst
-rw-r--r-- 1 oraoltp1 dbaoltp1 171K May 29 23:29 CstDiag115.txt

No comments:

Post a Comment