Upgrading our RAC database from 12.1 to 12.2.  Problems every step of the way from the very beginning.  Current issue while trying to apply patch: 2125537,

   PRCH-1000:  Failed to stop resources running from Oracle home
   PRCR-1132:  Failed to stop resources using a filter
   CRS-2529:     unable to act on 'ora.oper.db' because that would require stopping or relocating 'ora.oper.oper.svc', but the force optin was not specified

Please help, really struggeling to make progress with this upgrade.  BTW, O/S is Solaris.   Any suggestions and or recommendations appreciated.

I'm trying to list the relevant  regulations/acts that are applicable to

a) a CRM (Customer Relationship Mgmt) system : guess PDPA (Personal
    Data Protection Act) is applicable;  if it contains a US customer's data,
    guess GDPR is applicable.   What else?

b) for a procurement system,  Goods & Services Tax Act  is applicable.
    What else?

c) for a HR/Payroll,  "Computer Misuse Act" & what else?  Guess PDPA
    is not applicable for Payroll but applicable to HR (as Date of Birth
    & NRIC# is there)

Excel Table Support.
I have created a Table in an excel worksheet where users will be expected to add new rows manually. Note that this document will be a shared document on Sharepoint - so I cannot use any VBA etc.

I have created a number of other tables in the workbook that act as Data Validation lists. The data validation etc is working fine.

However - this is my problem. The user only has to enter two pieces of information in the table - and both pieces of data are entered into the first two cells/columns of the table. Normally this works perfectly - you just go to the first row under the table and begin typing - and when you tab to the next cell - the table automatically expands to add the row etc.
However, the first column (and second column) are both controlled by a Data Validation list.

The issue is - if you click on the cell below the table - the data validation is not available yet (as the table has not expanded) - so the person cannot "Select" from the list. If they attempt to type something - if they get it wrong and tab to the next column then they will of course get an error - because the table will expand and the cell now contains validation - so they either have to retry or cancel - both of which "remove" the new table row added - so the validation goes away - so they cannot select from the drop list (as it no longer exists on the cell).
So I am kind of between a rock and a hard place. I want to make it as simple as possible - basically being able …

My client lost email history and notes within his  Goldmine Premium Edition version 2017.1.0.422. I have image backups running. If I grab an earlier copy of the data base, he will lose data he has entered for the last 7 to 10 days (since he noticed the issue). Is it possible to just restore the missing email history/notes without having to resort to an older GB DB copy?

When I load up Outlook I get the following error message. The Act address book service is not properly configured or the configured database is locked. How do you uninstall this

Hi Experts

What is the Best Practice re IIS & RDS services?

We have 2 VMs on a HyperV: DC + RDS (both WIndows 2016)
Our CRM, ACT! from Sage,  is currently installed on the RDS but is only used internally.
We need to install a IIS / Web Server to give remote access to ACT! via the web

Can I use the RDS to install these additional components? My instinct is to build a new VM and install ACT! on that VM.

What says you?

Alex

Below mentioned script fine. I am trying to sort-object -descending the lastlogondate but output not getting as expected, getting output in  generic   .

Can any one assist to sort the lastlogondate in to – descending.

Thanks in advance

$DCs = 'DC01','DC02'

$ADObjects = @{}
ForEach ($DC in $DCs) {
	Write-Host "Processing logons at $($DC) ..."
	Get-ADComputer -Filter * -Property lastLogon -SearchBase "DC=test,DC=com" -Server $DC | ForEach-Object {
		If ($ADObjects.ContainsKey($_.SamAccountName)) {
			If ($ADObjects[$_.SamAccountName].LastLogon -lt $_.lastLogon) {
				$ADObjects[$_.SamAccountName].LastLogon = $_.lastLogon
				$ADObjects[$_.SamAccountName].LastLogonAt = $DC
			}
		} Else {
			$ADObjects.Add($_.SamAccountName, ($_ | Select-Object SamAccountName, Name, LastLogon, @{Name='LastLogonAt'; Expression={$DC}}))
		}
	}
}
$ADObjects.Values |
	Sort-Object Name, SamAccountName, @{Name='Last Logon Date'; Expression={If ($_.lastLogon) {[datetime]::FromFileTime($_.lastLogon)} Else {'None'}}}, LastLogonAt |
	Export-CSV C:\temp\LastLogonReport.csv -NoTypeInformation

Select all Open in new window

I currently have an SBS2011 running domain1.com in native mode (i.e. mx records domain1.com->public IP, ptr -> domain1.com) and I have another two domains which I've added as authoritive domains and use SBS POP3 connector to get email for them.

Lately one of the domains has been losing email and I want to make it native with the current host as a backup using mx records. To do this I've thought of the following:

1. mx records domain2.com -> public IP priority 0
    mx records domain2.com -> current host priority 100
2. Change current host to act as backup in case public IP goes down and forward email to it once it comes back up.
3. Make PTR changes.

Now my main issues are 2 and 3. Will I need to use cpanel to create the exchange email accounts in the current host or will it keep the email in a general store and send them to the correct recipients once the public IP comes back on. And will I need to make any changes to PTR? Some say yes others just say that I need to make changes to the SPF to allow sending from public IP. Will multiple PTR pointing to one public IP mess things up?

Hi Experts, I'm not able to  get Act to work on my new server Windows 2016. It’s version 16. The message is: “Unable to connect to the database. Please verify the Act17 SQL instance is running.”

It's working on my old server which is still online. I'd like to get some help on resolving this. I have the database in the old server too invade I need to do something their or invade i didn't back it up correctly please advise on how to.

Hi experts, I have a client looking to move to RDS on premise or azure solution. This is because they are taking more and more remote workers on. Currently they have domain controller with ACT on it. Server 2008.
“ACT. The database sits on there DC server at present. Related to this is how Microsoft Query will work extracting data from the ACT database. If we move ACT onto RDS server (either on premise or Azure) and add Office 365 Pro so they can use remotely.
There are some custom reports in excel which use Microsoft query to look up on the ACT database directly and return the information to excel when we refresh the report in excel. First question is: does office 365 still offer this functionality (or the Microsoft query add on)?
Second Question: if query works with office 365 will it work if the ACT database is housed on the Azure cloud

there are about 13 users.
cheers for advance

Third Question: if all is set up here will the remote working setup still be able to use query with logging on remotely?

Hi Experts!

Is there a way I can have a proper invoice number on my invoice report , my invoice report is generated from the following tables :

(1) tblInvoice
(2) tblLinedatails

Currently I'm using PK number to act as an invoice number from tblinvoice, what I want is something like "Year & 000000 & PK number ) example something like ( 2017 000001) assuming the 1 represent the tblinvoice PK


Regards

Chris

Hi Experts, we are looking to introduce a remote desktop server , RDS 2016 , this will provide ACT and Office ,
their setup is as follows 1 x server 2008 (will upgrade eventually) ,20 users in house and 5-10 users remoteing in.
Their main applications are ACT on premise and office. They currently have hosted exchange but we will move them to office 365 eventually. Some of the users access from Africa and even a hotspot in Africa.
Just wondering what type of HP rack server I should be looking at, ideal Raid configuration, memory ?
thanks in advance.

We are planning on standing up 2 Exchange 2016 servers. One in the Americas and one in Asia that would also act as failovers.
How can I setup the 2 IronPorts to differentiate between the two locations? Both would be serving the same domain.