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