Sunday, 9 November 2014

Compile multiple oracle forms and libraries in unix in batch mode

for i in `ls *.pll`
echo Compiling Library $i ....
frmcmp userid=powercard/xxxxx@pcard batch=yes module=$i module_type=library compile_all=yes

for i in `ls *.fmb`
echo Compiling Form $i ....
frmcmp userid=powercard/xxxxx@pcard batch=yes module=$i module_type=form compile_all=yes

Wednesday, 5 November 2014

The SQL Server Reporting Services (MSSQLSERVER) service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion

Click Start, click Run, type regedit, and then click OK.
Locate and then click the following registry subkey:
In the right pane, locate the ServicesPipeTimeout entry.

Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:
On the Edit menu, point to New, and then click DWORD Value.
Type ServicesPipeTimeout, and then press ENTER.
Right-click ServicesPipeTimeout, and then click Modify.
Click Decimal, type 60000, and then click OK.

This value represents the time in milliseconds before a service times out.
Restart the computer.

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

After we did NFS mount with proper options and gave the correct permission we still getting below error:

mount -o hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3 nim_server1:/mksysb /mksysb

chmod -R 777 /mksysb/dumps


server614[/mksysb/dumps]>> expdp powercard/pcard1 DIRECTORY=BACKUP DUMPFILE=expdp_prod_offline.dmp  parfile=11_3_parfile_offline_tables.txt  LOGFILE=expdp_prod_offline.log CONTENT=DATA_ONLY

Export: Release - 64bit Production on Wednesday, 05 November, 2014 13:47:58

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/mksysb/dumps/expdp_prod_offline_.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 6

Issue resolved by issue below command:
ALTER SYSTEM SET EVENTS ‘10298 trace name context forever, level 32′;

Number of Visitors