Everything for SAP Hana / Basis /Technology / BO / BW

TeamViewer and VNC installation on openSUSE As we all know that  TeamViewer connects to any PC or server around the world within a few seconds. You can manage the remote machine as if you are logged into that machine. You can install   TeamViewer on  your openSuse  box by following the below simple steps :: 1 >  Download the   TeamViewer package for  openSUSE root@server[#]  cd  /usr/src root@server[#] wget http://www.teamviewer.com/download/teamviewer_linux_suse64.rpm 2 >  Install the required binaries root@server[#]   zypper install libfreetype6-32bit root@server[#]  zypper install wine 3 > Install TeamViewer package by using zypper or rpm root@server[src]# rpm --install teamviewer_linux_suse64.rpm or root@server[src]# zypper in teamviewer_linux_suse64.rpm This will install TeamViewer on  your machine. Now to access   TeamViewer you have to install   vnc viewer ...

When this error start showing you that means you don't have space to be utilized by DB for data storage or even for log purpose. so you can't alter database size. You need to initialize some spare disk. > disk init name=sybase_disk,physname="D:\sybase_test_database\data\sybase.dat",skip_alloc="true",size="10G"

How to increase size of Sybase database on UNIX platforms ?Posted by Sybase Admin  Issue  I have problem in size of database because the free space of the database is less than specific percentage of total space. Cause Users used to update in the database and that lead to increase used space of this database Solution I)                Increase size of  database by creating new data file and log file ü  First we need to know the sequence of the exiting data and log files of this database to specify the name new files isql  -U  -P  // used to access sql  1>   sp_helpdb  DBname 2>   go ü  second we need to create the defined data file 1>   disk init name =”name of new data file” , physname =”destination path/name of data file” ,size=” desired space M” 2>   go ü  Third we need to create the defined log file 1>   disk in...

"The following error has occurred: The cluster resource 'SQL Server (InstanceName)' could not be brought online. Error: The resource failed to come online due to the failure of one or more provider resources. (Exception from HRESULT: 0x80071736)" The following error shows up in the System event log: "Cluster network name resource 'resource_name' failed to create its associated computer object in domain 'ad.weil.com' for the following reason: Unable to create computer account. The text for the associated error code is: Access is denied. Please work with your domain administrator to ensure that: - The cluster identity 'computer_object' can create computer objects. By default all computer objects are created in the 'Computers' container; consult the domain administrator if this location has been changed. - The quota for computer objects has not been reached. - If there is an existing computer object, verify the Cluster Identity 'c...

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start). SQL Server Installation is failed with Wait on the Database Engine recovery handle failed error. I have already posted workaround for that issue, please search about that post. After fixing the SQL Server issue, I observed SQL Server Agent is not starting, To troubleshoot the issue. 1. Connect to SSMS 2. Right click on SQL Server Agent  -- Properties 3. In General section there is path for SQL Server Agent.out error log file. 4. Open the file in notepad and verify the error, I have the following error in my agent.out file Unable to connect to server '(local)'; SQLServerAgent cannot start SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\SYSTEM'. [SQLSTATE 28000] Logon to server '(local)' failed (DisableAgentXPs) SQLServerAgent terminated (normally) 5. To fix this I have added NT Authoriy\System to SQL Security, (The cause of...