1. Create unit file in the /etc/systemd/system/ directory and make sure it has correct file permissions. Execute as root:
[root@em12c ~]# touch /etc/systemd/system/Oracle_Listener_LISTENER.service
[root@em12c ~]# chmod 664 /etc/systemd/system/Oracle_Listener_LISTENER.service
2. Add the following content to the file: /etc/systemd/system/Oracle_Listener_LISTENER.service
[Unit]
Description=Oracle Listener (LISTENER)
After=network.target
[Service]
Type=forking
PIDFile=/home/oracle/scripts/LISTENER.pid
ExecStart=/bin/su - oracle -c "/home/oracle/scripts/lsnrstart.sh LISTENER"
ExecReload=/bin/su - oracle -c "/home/oracle/scripts/lsnrshut.sh LISTENER;/home/oracle/scripts/lsnrstart.sh LISTENER"
ExecStop=/bin/su - oracle -c "/home/oracle/scripts/lsnrshut.sh LISTENER"
[Install]
WantedBy=multi-user.target
3. Execute the following commands to reload the configuration and start the custom service:
[root@em12c ~]# systemctl daemon-reload
[root@em12c ~]# systemctl start Oracle_Listener_LISTENER.service [root@em12c ~]# systemctl enable Oracle_Listener_LISTENER.service
4. Create unit file in the /etc/systemd/system/ directory and make sure it has correct file permissions. Execute as root:
[root@em12c ~]# touch /etc/systemd/system/Oracle_Instance_orcl.service [root@em12c ~]# chmod 664 /etc/systemd/system/Oracle_Instance_orcl.service
5. Add the following content to the file: /etc/systemd/system/Oracle_Instance_orcl.service
[Unit]
Description=Oracle Instance (orcl)
After=network.target
Wants=Oracle_Listener_LISTENER.service
[Service]
Type=forking
PIDFile=/home/oracle/scripts/orcl.pid
ExecStart=/bin/su - oracle -c "/home/oracle/scripts/dbstart.sh orcl"
ExecReload=/bin/su - oracle -c "/home/oracle/scripts/dbshut.sh orcl;/home/oracle/scripts/lsnrstart.sh orcl"
ExecStop=/bin/su - oracle -c "/home/oracle/scripts/dbstart.sh orcl"
[Install]
WantedBy=multi-user.target
6. Execute the following commands to reload the configuration and start the custom service:
[root@em12c ~]# systemctl daemon-reload
[root@em12c ~]# systemctl start Oracle_Instance_orcl.service
[root@em12c ~]# systemctl enable Oracle_Instance_orcl.service
7. Check the service status:
[root@em12c ~]# systemctl |grep -e Oracle -e DESCRIPTION
UNIT LOAD ACTIVE SUB DESCRIPTION
Oracle_Instance_orcl.service loaded active running Oracle Instance (orcl)
Oracle_Listener_LISTENER.service loaded active running Oracle Listener (LISTENER)
[root@em12c ~]# systemctl list-unit-files|grep -e Oracle -e STATE
UNIT FILE STATE
Oracle_Instance_orcl.service enabled
Oracle_Listener_LISTENER.service enabled
[root@em12c ~]# systemctl status Oracle_Instance_orcl.service
Oracle_Instance_orcl.service - Oracle Instance (orcl)
Loaded: loaded (/etc/systemd/system/Oracle_Instance_orcl.service; enabled)
Active: active (running) since Thu 2015-10-29 00:15:20 SGT; 14s ago
Process: 15214 ExecStart=/bin/su - oracle -c /home/oracle/scripts/dbstart.sh orcl (code=exited, status=0/SUCCESS)
Main PID: 15295 (ora_smon_orcl)
CGroup: /system.slice/Oracle_Instance_orcl.service
‣ 15295 ora_smon_orcl
Oct 29 00:15:13 em12c.dbaglobe.com systemd[1]: Starting Oracle Instance (orcl)...
Oct 29 00:15:13 em12c.dbaglobe.com su[15214]: (to oracle) root on none
Oct 29 00:15:20 em12c.dbaglobe.com systemd[1]: Started Oracle Instance (orcl).
Thursday, October 29, 2015
Saturday, October 24, 2015
How to Configure hostname in Oracle Linux 7
Set the hostname:
[root@localhost ~]# hostnamectl set-hostname em12c.dbaglobe.com[root@localhost ~]# hostnameem12c.dbaglobe.com
Re-login terminal session:
login as: oracleoracle@192.168.56.130's password:
Last login: Sat Oct 24 17:44:29 2015 from 192.168.56.1
[oracle@em12c ~]$ hostnamectl status
Static hostname: em12c.dbaglobe.com
Icon name: computer
Chassis: n/a
Machine ID: 15d9d5269a7143d5b035b02bf229b005
Boot ID: 5253a1c387ef488aa662eec3b7d52f39
Operating System: Oracle Linux Server 7.1
CPE OS Name: cpe:/o:oracle:linux:7:1
Kernel: Linux 3.10.0-229.14.1.el7.x86_64
Architecture: x86_64
Friday, October 23, 2015
Fix 3 installation issues on OEM12c Cloud Control on OL7 (RHEL7)
Issue 1: cannot find crt1.o
INFO: 10/23/15 9:55:05 PM SGT: m12c/middleware/oms/sqlplus/bin/sqlplus32 -L/u01/em12c/middleware/oms/sqlplus/lib32/ -L/u01/em12c/middleware/oms/lib32/ -L/u01/em12c/middleware/oms/lib32/stubs/ /u01/em12c/middleware/oms/sqlplus/lib32/s0afimai.o -lsqlplus -lclntsh `cat /u01/em12c/middleware/oms/lib32/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/em12c/middleware/oms/lib32/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lztkg11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lm
INFO: 10/23/15 9:55:05 PM SGT: m -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/em12c/middleware/oms/lib32/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/em12c/middleware/oms/lib32/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lcli
INFO: 10/23/15 9:55:05 PM SGT: ent11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/em12c/middleware/oms/lib32/sysliblist` -Wl,-rpath,/u01/em12c/middleware/oms/lib32 -lm -lpthread `cat /u01/em12c/middleware/oms/lib32/sysliblist` -ldl -lm -lpthread -L/u01/em12c/middleware/oms/lib32
INFO: 10/23/15 9:55:05 PM SGT: /usr/bin/ld: cannot find crt1.o: No such file or directory
/usr/bin/ld: cannot find crti.o: No such file or directory
/usr/bin/ld: cannot find -lclntsh
/usr/bin/ld: skipping incompatible /usr/lib64/libc.so when searching for -lc
/usr/bin/ld: cannot find -lc
/usr/bin/ld: cannot find crtn.o: No such file or directory
INFO: 10/23/15 9:55:05 PM SGT: make[1]: Leaving directory `/u01/em12c/middleware/oms/sqlplus/lib'
INFO: 10/23/15 9:55:05 PM SGT: collect2: error: ld returned 1 exit status
make[1]: *** [/u01/em12c/middleware/oms/sqlplus/bin/sqlplus32] Error 1
make: *** [newsqlplus32] Error 2
INFO: 10/23/15 9:55:05 PM SGT: End output from spawned process.
INFO: 10/23/15 9:55:05 PM SGT: ----------------------------------
INFO: 10/23/15 9:55:05 PM SGT: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'install' of makefile '/u01/em12c/middleware/oms/sqlplus/lib/ins_sqlplus.mk'. See '/u01/app/oraInventory/logs/installActions2015-10-23_09-52-50-PM.log' for details.
Exception Severity: 1
INFO: 10/23/15 9:55:05 PM SGT: POPUP WARNING:Error in invoking target 'install' of makefile '/u01/em12c/middleware/oms/sqlplus/lib/ins_sqlplus.mk'. See '/u01/app/oraInventory/logs/installActions2015-10-23_09-52-50-PM.log' for details.
Click "Retry" to try again.
Click "Ignore" to ignore this error and go on.
Click "Cancel" to stop this installation.
How to fix:
[root@localhost /]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-devel
glibc-devel-2.17-78.0.1.el7 (x86_64)
[root@localhost /]# yum search glibc-devel
Loaded plugins: langpacks
================================================================= N/S matched: glibc-devel ==================================================================
glibc-devel.i686 : Object files for development using standard C libraries.
glibc-devel.x86_64 : Object files for development using standard C libraries.
[root@localhost /]# yum install glibc-devel.i686
Issue 2: cannot find -lclntsh
gcc -m32 -o /u01/em12c/middleware/oms/sqlplus/bin/sqlplus32 -L/u01/em12c/middleware/oms/sqlplus/lib32/ -L/u01/em12c/middleware/oms/lib32/ -L/u01/em12c/middleware/oms/lib32/stubs/ /u01/em12c/middleware/oms/sqlplus/lib32/s0afimai.o -lsqlplus -lclntsh `cat /u01/em12c/middleware/oms/lib32/ldflags` -lnc
INFO: 10/23/15 10:06:26 PM SGT: rypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/em12c/middleware/oms/lib32/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lztkg11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/em12c/middleware/oms/lib32/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/em12c/middleware/oms/lib32/ldflags` -lncry
INFO: 10/23/15 10:06:26 PM SGT: pt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/em12c/middleware/oms/lib32/sysliblist` -Wl,-rpath,/u01/em12c/middleware/oms/lib32 -lm -lpthread
INFO: 10/23/15 10:06:26 PM SGT: `cat /u01/em12c/middleware/oms/lib32/sysliblist` -ldl -lm -lpthread -L/u01/em12c/middleware/oms/lib32
INFO: 10/23/15 10:06:26 PM SGT: /usr/bin/ld: cannot find -lclntsh
collect2: error: ld returned 1 exit status
INFO: 10/23/15 10:06:26 PM SGT: make[1]: Leaving directory `/u01/em12c/middleware/oms/sqlplus/lib'
INFO: 10/23/15 10:06:26 PM SGT: make[1]: *** [/u01/em12c/middleware/oms/sqlplus/bin/sqlplus32] Error 1
make: *** [newsqlplus32] Error 2
How to fix:
[oracle@em12c bin]$ pwd
/u01/em12c/middleware/oms/bin
[oracle@em12c bin]$ export ORACLE_HOME=/u01/em12c/middleware/oms
[oracle@em12c bin]$ ./genclntsh
[oracle@em12c bin]$ ls -l /u01/em12c/middleware/oms/lib32//libclntsh.so
lrwxrwxrwx. 1 oracle oinstall 17 Oct 23 22:16 /u01/em12c/middleware/oms/lib32//libclntsh.so -> libclntsh.so.11.1
Issue 3: libwebcache.a(wxsmdms.o): undefined reference to symbol 'yodSensorInvalidate'
gcc -o webcached -L/u01/em12c/middleware/Oracle_WT/webcache/lib/ -L/u01/em12c/middleware/Oracle_WT/lib/ -L/u01/em12c/middleware/Oracle_WT/lib/stubs/ main.o libwebcache.a -Wl,-rpath,/u01/em12c/middleware/Oracle_WT/lib -liau -lnnz11 -lxml11 -lclntsh -lcore11 -lunls11 -lnls11 /u01/em12c/middleware/Oracle_WT/lib/liboraz.a -ldmsapp -lons `cat /u01/em12c/middleware/Oracle_WT/lib/sysliblist` -lrt -Wl,-rpath,/u01/em12c/middleware/Oracle_WT/lib -lm `cat /u01/em12c/middle
INFO: 10/23/15 10:23:56 PM SGT: ware/Oracle_WT/lib/sysliblist` -lrt -ldl -lm -L/u01/em12c/middleware/Oracle_WT/lib
INFO: 10/23/15 10:23:56 PM SGT: /usr/bin/ld: libwebcache.a(wxsmdms.o): undefined reference to symbol 'yodSensorInvalidate'
/usr/bin/ld: note: 'yodSensorInvalidate' is defined in DSO /u01/em12c/middleware/Oracle_WT/lib/libdms2.so so try adding it to the linker command line
/u01/em12c/middleware/Oracle_WT/lib/libdms2.so: could not read symbols: Invalid operation
collect2: error: ld returned 1 exit status
INFO: 10/23/15 10:23:56 PM SGT: make: *** [webcached] Error 1
INFO: 10/23/15 10:23:56 PM SGT: End output from spawned process.
INFO: 10/23/15 10:23:56 PM SGT: ----------------------------------
INFO: 10/23/15 10:23:56 PM SGT: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'install' of makefile '/u01/em12c/middleware/Oracle_WT/webcache/lib/ins_calypso.mk'. See '/u01/app/oraInventory/logs/cloneActions2015-10-23_10-23-38-PM.log' for details.
Exception Severity: 1
INFO: 10/23/15 10:23:56 PM SGT: POPUP WARNING:Error in invoking target 'install' of makefile '/u01/em12c/middleware/Oracle_WT/webcache/lib/ins_calypso.mk'. See '/u01/app/oraInventory/logs/cloneActions2015-10-23_10-23-38-PM.log' for details.
Click "Retry" to try again.
Click "Ignore" to ignore this error and go on.
Click "Cancel" to stop this installation.
How to fix: (add -ldms2 to sysliblist)
[root@localhost trace]# cp -p /u01/em12c/middleware/Oracle_WT/lib/sysliblist /u01/em12c/middleware/Oracle_WT/lib/sysliblist.orig[root@localhost trace]# vi /u01/em12c/middleware/Oracle_WT/lib/sysliblist
[root@localhost trace]# diff /u01/em12c/middleware/Oracle_WT/lib/sysliblist /u01/em12c/middleware/Oracle_WT/lib/sysliblist.orig
1c1
< -ldl -lm -lpthread -lnsl -lirc -lipgo -ldms2
---
> -ldl -lm -lpthread -lnsl -lirc -lipgo
Thursday, October 22, 2015
Linux kernel parameters set by “oracle-rdbms-server-12cR1-preinstall”
[oracle@localhost /]$ rpm -qa|grep preinstall
oracle-rdbms-server-12cR1-preinstall-1.0-4.el7.x86_64
[oracle@localhost /]$
[oracle@localhost /]$ cat /etc/sysctl.conf
# System default settings live in /usr/lib/sysctl.d/00-system.conf.
# To override those settings, enter new settings here, or in an /etc/sysctl.d/<name>.conf file
#
# For more information, see sysctl.conf(5) and sysctl.d(5).
# oracle-rdbms-server-12cR1-preinstall setting for fs.file-max is 6815744
fs.file-max = 6815744
# oracle-rdbms-server-12cR1-preinstall setting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128
# oracle-rdbms-server-12cR1-preinstall setting for kernel.shmmni is 4096
kernel.shmmni = 4096
# oracle-rdbms-server-12cR1-preinstall setting for kernel.shmall is 1073741824 on x86_64
kernel.shmall = 1073741824
# oracle-rdbms-server-12cR1-preinstall setting for kernel.shmmax is 4,398,046,511,104 on x86_64
kernel.shmmax = 4398046511104
# oracle-rdbms-server-12cR1-preinstall setting for kernel.panic_on_oops is 1 per Orabug 19212317
kernel.panic_on_oops = 1
# oracle-rdbms-server-12cR1-preinstall setting for net.core.rmem_default is 262144
net.core.rmem_default = 262144
# oracle-rdbms-server-12cR1-preinstall setting for net.core.rmem_max is 4194304
net.core.rmem_max = 4194304
# oracle-rdbms-server-12cR1-preinstall setting for net.core.wmem_default is 262144
net.core.wmem_default = 262144
# oracle-rdbms-server-12cR1-preinstall setting for net.core.wmem_max is 1048576
net.core.wmem_max = 1048576
# oracle-rdbms-server-12cR1-preinstall setting for net.ipv4.conf.all.rp_filter is 2
net.ipv4.conf.all.rp_filter = 2
# oracle-rdbms-server-12cR1-preinstall setting for net.ipv4.conf.default.rp_filter is 2
net.ipv4.conf.default.rp_filter = 2
# oracle-rdbms-server-12cR1-preinstall setting for fs.aio-max-nr is 1048576
fs.aio-max-nr = 1048576
# oracle-rdbms-server-12cR1-preinstall setting for net.ipv4.ip_local_port_range is 9000 65500
net.ipv4.ip_local_port_range = 9000 65500
Wednesday, October 21, 2015
Adding SSRS instances without configuring scale-out (in Standard Edition Scenario)
Below are steps to manually configure SSRS failover to alternative instances based on Standard Edition, lab experimental only, use in production at your own risk.
1. Below Key operations added to Keys table during the Report Server DB configuration
declare @p5 int
set @p5=NULL
exec AnnounceOrGetKey @MachineName=N'VMMSQL02',@InstanceName=N'SE',@InstallationID='74706FB6-0740-4F57-931E-54702B387643',@PublicKey=0x0602000000A40000525341310008000001000100C1284D20B9F13FD33C12CEF6E791A238B78472AB467F32CC4B9B12537F7BAE4FF8D369C75039503EA55AC461C79E9482CBAB08242E6FB67A12596C52A0BD8AED961C1D0175557826388F8B9E1E92FD36EE4BB5DDB46320BD990C928D3D46AAD344015478957CBA0EFB692019DE1215696AF72B5E8AA6C419D1C7CC881F4399FE69F03995AEEFAA9DCDB108F6022428942C05E4405C80E8198584C4D564100DC5F8A39D844A0C68546E9E9E36623604990E7792DDD62919729C2CCCF800995880EEFFBF9E994A196824DBBF41B79A04E8C1FB8FCF87AA7D18EA50BD874D140BF8B2E7D79196FD2FBC14C7FF3AB8D574C3A0298C95BC17D216BA403D272556EABA,@NumAnnouncedServices=@p5 output
select @p5
go
2. On VMMSQL01 (original), the “Test Report” runs without problem, but failed on VMMSQL02.
| library!ReportServer_0-1!9f0!10/21/2015-23:06:31:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerNotActivatedException: , Microsoft.ReportingServices.Library.ReportServerNotActivatedException: The report server installation is not initialized.; |
3. Manually Restore the encryption key to VMMSQL02
4. VMMSQL02 still failed to render report due to feature limitation of Standard Edition
5. Manually removed the SSRS instance (VMMSQL01) from KEY table, Reports worked on VMMSQL02
select *
into [ReportServer].[dbo].[Keys_BAK]
from [ReportServer].[dbo].[Keys]
GO
delete from [ReportServer].[dbo].[Keys] where MachineName='VMMSQL01'
GO
6. In the event of failback required, manually insert the KEY for VMMSQL01 SSRS instance again
insert into [ReportServer].[dbo].[Keys]
select * from [ReportServer].[dbo].[Keys_BAK] where MachineName='VMMSQL01'
GO
delete from [ReportServer].[dbo].[Keys] where MachineName='VMMSQL02'
GO
Machine related configuration during SSRS DB creation
declare @p5 int
set @p5=NULL
exec AnnounceOrGetKey @MachineName=N'VMMSQL01',@InstanceName=N'SE',@InstallationID='1E40A75C-0BE4-4D7C-A0AC-F0746AC8BC9B',@PublicKey=0x0602000000A400005253413100080000010001008D3BDCD0EEC49331A789635C801D03D655D47209A1B950842F1E5A377C151DE87D85C93DF5CDA47F60F06B68D5713B9AFE8E6DC31FF473888C6DFEDE810D4339FD24349E274DF4DCF5295CC75E3DB1064E3F01B1DE49DB4196CA4B342941FD0AF273B11A575D7B3721460D07C56B30AB082E3C07A6F70FC789EF7C14AFB57D7B2B4E506FA5DE32B7586CF813A19D6AADCE36D341596E645840AB3489B7AE91A70E4E827CB160388DF97B76E2171D5D771D1099A9C40EE2E38359B2D369C4B554215368AA8C909327397E60310FFB900C0C7DDF23144B0F33DCA2AC51D12EBAC014419E1616DD2F3997660C95D9602312E97E5186CBD912659A6B9197ADC8AEF2,@NumAnnouncedServices=@p5 output
select @p5
go
exec SetKeysForInstallation @InstallationID='1E40A75C-0BE4-4D7C-A0AC-F0746AC8BC9B',@SymmetricKey=0x010200000366000000A40000237C083E606AE3E4B5D3D2A181B74FE287BB57603AEBC7BD9297020A42825D57304A6983D49EB729FF2A39CD0D86E87401FEA56CAE657C0446910771B23FCFE64B3FC08FD1DF6D547CDEDC3D1676B3D254532F363FABD395ECD93ECD6F202C4FD5DA060C6D4310402281834E41F112CAFF7DB05F90955652968F7E565E483675101DAFEE9E932C9425DFE58FB886FD3FC162B75892CAFD7EBF92D37D25CFB84530437541A014A88AA1D3F7D6DCB9CEF4A68902DBE88142D50A4ED0462B9095F8B1397EC2F3DD9BCF182A9ABDD943F4DE9DE4613EED31E10B2E17B73282973AD0F9048DCCB68C64DBE7B9D95B0D15750C948E6E4303BAE7BAD80B3937A5E4C298,@PublicKey=0x0602000000A400005253413100080000010001008D3BDCD0EEC49331A789635C801D03D655D47209A1B950842F1E5A377C151DE87D85C93DF5CDA47F60F06B68D5713B9AFE8E6DC31FF473888C6DFEDE810D4339FD24349E274DF4DCF5295CC75E3DB1064E3F01B1DE49DB4196CA4B342941FD0AF273B11A575D7B3721460D07C56B30AB082E3C07A6F70FC789EF7C14AFB57D7B2B4E506FA5DE32B7586CF813A19D6AADCE36D341596E645840AB3489B7AE91A70E4E827CB160388DF97B76E2171D5D771D1099A9C40EE2E38359B2D369C4B554215368AA8C909327397E60310FFB900C0C7DDF23144B0F33DCA2AC51D12EBAC014419E1616DD2F3997660C95D9602312E97E5186CBD912659A6B9197ADC8AEF2
go
exec GetMyRunningJobs @ComputerName=N'VMMSQL01',@JobType=1
go
“The feature using other editions of sql server for report data sources and/or the report server database”is not supported in this edition of Reporting Services.
The feature: "The feature using other editions of sql server for report data sources and/or the report server database”is not supported in this edition of Reporting Services.
Step to fix:
Upgrade SQL Server to standard edition or enterprise edition
Subscribe to:
Posts (Atom)
