Wednesday, June 8, 2016

How to enable multiple remote connection for windows server 2012


How to enable multiple remote connection for windows server 2012
Answer:
1. Open command propmt
2.write gpedit.msc and open it
3.Go to computer configuration -> Administrative Tempalates -> Wondows Components
->Remote Desktop services -> Remote Desktop Session Host -> Connections.
4. Here Disble the below mentioned.

Restrict Remote Desktop Services user to a single remote.....

Now go to command prompt and update the group policy using below mentioned command.

Go to command prompt and type -> gpupdate and enter it. it should be successfully applied.

Friday, August 15, 2014

Recover Database from ORA-00333: redo log read error

I got the above error when i start My DB.
I followed the below steps to recover this.

SQL> startup
ORACLE instance started.
Total System Global Area ***** bytes
Fixed Size               ***** bytes
Variable Size            ***** bytes
Database Buffers         ***** bytes
Redo Buffers             ***** bytes
Database mounted.
 
 ORA-00333: redo log read error block *Number* count *Number*



================================================================================
Step 1: Since the DB is in mount mode, We can query v$log & v$logfile to identify the status of log file group and their member.

 SQL> select l.status, member from v$logfile inner join v$log l using (group#); 
 STATUS  MEMBER
 ------------- --------------------------------------
 CURRENT /oracle/fast_recovery_area/redo01.log
 INACTIVE /oracle/fast_recovery_area/redo02.log
 INACTIVE /oracle/fast_recovery_area/redo03.log



 
Step 2: Recover the database using ackup controlfile.

 SQL> recover database using backup controlfile;
ORA-00279: change  generated at  needed for thread 1
ORA-00289: suggestion : /oracle/fast_recovery_area/archivelog/o1_mf_1_634_%u_.arc
ORA-00280: change  for thread 1 is in sequence #
Specify log: {=suggested | filename | AUTO | CANCEL}




Step3: Give 'CURRENT' log file member along with location as input. If it does not work give other log file members along with location in input prompt. In our case we give 
/oracle/fast_recovery_area/redo01.log

Saturday, December 21, 2013

Scheduled task won't run .bat file 2008R2

In our production environments, i scheduled a task to start some programs which is a BAT file in Windows Server 2008 R2.

If i double click the .bat file, it started. But from scheduled task, it is not starting. Although i select the task and try to run task manually , it is not starting.

Solution 

 Fill in the "Start In (Optional)" field. There you need to enter the path of .BAT file.
Go to task's properties, Actions, Edit and put the path to BAT filr.

Ex: E:\MUBASHER-IT\ANBI\Documents\

No need to put double quotes.


Sunday, June 16, 2013

How to increase number of connections in Oracle




SQL> alter system set processes=200 scope=spfile/both; 

Sunday, June 2, 2013

Schedule a CRON Job in HP-UX

Few days back i have a problem to schedule a cron job in HP-UX to run a .sh script.
Cron is staring exactly on the scheduled time and the particular .sh script also calling from the cron job.
But that component is not starts.

This start.sh script is as follows.

/usr/java/jre1.5.0_22/bin/java -server -Xms512m -Xmx1024m -XX:MaxPermSize=512m -Dsun.rmi.dgc.client.gcInterval=90000 -Dsun.rmi.dgc.server.gcInterval=90000 -Djavax.net.ssl.keyStore=keystore -Djavax.net.ssl.keyStorePassword=password -jar lib/DBC.jar> nohup_dbc.out &


Solution

What i did was, i created another script start-cron.cron file which as follows.

 "cd /<File path to start.sh>
  sleep 2
  ./start.sh
  "
and save as .cron.
Change the permission as 777

Then i call the start-cron.cron  file in the CRON job scheduler.
Then the component was started.

Monday, May 20, 2013

Import PKCS12 private keys into JKS keystores using Java Keytool

1) Import alice.p12 into alice.jks

keytool -v -importkeystore -srckeystore certifiate.p12 -srcstoretype PKCS12 -destkeystore mykeystore.jks -deststoretype JKS


=================================


* Create an new empty JKS store.

keytool -genkey -alias mykey -keystore keystore.jks
keytool -delete -alias mykey - keystore keystore.jks

Wednesday, April 24, 2013

Websphere Application server-Transaction across two base servers fails

During a brokerage solution implementation, we have faced a issue of connecting two Websphere application servers. In "SystemOut.log" files, the following error appears.


org.omg.CORBA.TRANSACTION_ROLLEDBACK: 
>> SERVER (id=4773e3aa, host=ICAPNT17) TRACE START:
>>    org.omg.CORBA.TRANSACTION_ROLLEDBACK: javax.transaction.TransactionRolledbackException:  ; nested exception is: 
com.ibm.websphere.csi.CSITransactionRolledbackException:   vmcid: 0x0  minor code: 0  completed: No
>> at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:988)
>> at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:259)
>> at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:570)
>> at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4558)
>> at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4372)
>> at com.mubasher.connectors.web.session.EJSRemoteStatelessWebConnectorFacade_415e6c0a.createOrder(Unknown Source)
>> at com.mubasher.connectors.web.session._EJSRemoteStatelessWebConnectorFacade_415e6c0a_Tie.createOrder(_EJSRemoteStatelessWebConnectorFacade_415e6c0a_Tie.java:369)
>> at com.mubasher.connectors.web.session._EJSRemoteStatelessWebConnectorFacade_415e6c0a_Tie._invoke(_EJSRemoteStatelessWebConnectorFacade_415e6c0a_Tie.java:168)
>> at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java:622)
>> at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:475)
>> at com.ibm.rmi.iiop.ORB.process(ORB.java:504)
>> at com.ibm.CORBA.iiop.ORB.process(ORB.java:1571)
>> at com.ibm.rmi.iiop.Connection.respondTo(Connection.java:2771)
>> at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2640)
>> at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:63)
>> at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:118)
>> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1646)
>> SERVER (id=4773e3aa, host=ICAPNT17) TRACE END.
  vmcid: 0x0  minor code: 0  completed: No In class: class com.directfn.tradeweb.plugins.trade.service.CreateOrderService
com.directfn.tradeweb.system.exceptions.ServiceException: javax.transaction.TransactionRolledbackException: CORBA TRANSACTION_ROLLEDBACK 0x0 No; nested exception is:


 I found that this is happening because of  global security enabled default behavior is for transaction protocol messages, e.g. prepare, commit, rollback to be secured. This prevents malicious completion of global transactions.

What we Did

1) Global transaction on WAS requires the two servers to "trust" each other. I solved the problem by importing server A's LTPA key into server B and vice-versa.

2) If you run in an environment where security is not a concern, or the servers are secured by another means, this behavior can be disabled by unchecking the Enable protocol security check box on the transaction
service panel in the admin console