CREATE SYNONYM [dbo].[tbl1] FOR [db1].[dbo].[tbl1] The above code, if run on db2, would create an object tbl1 which would behave as a table under the dbo schema in db2, but would actually reference [db1].[dbo].[tbl1]. If you are on 2000, then no, it’s fully qualified names or nothing, I’m afraid. Nota: –>Ubicarse en la base donde… Leer más »
Make some first indexing, updatedb note. you’ll have to use ‘slocate’, not ‘locate’ Oracle Solaris 11 configuration and administration Introduction See http://pbraun.nethence.com/doc/sysutils_solaris/network.html for network configuration. Vmware tools on solaris https://kb.vmware.com/kb/1023956 http://prefetch.net/blog/index.php/2011/09/28/getting-vmware-tools-to-configure-on-solaris-10-guests/ System configuration Disable graphical login, svcadm disable gdm Mount an NFS share, cd /etc/ vi vfstab nfssrv:/path/to/share – /mnt/mountpoint nfs – no ro,soft If… Leer más »
Install cacertificates on Solaris 10 and 11: pkgadd -d http://get.opencsw.org/now /opt/csw/bin/pkgutil -U /opt/csw/bin/pkgutil -y -i cacertificates /usr/sbin/pkgchk -L CSWcacertificates # list files
Before restarting the AdminServer, in order to rule out an issue with a java Ipv6 not releasing ports properly so it ends up with being owned by kernel: Edit DLC/properties/AdminServerPlugins.properties under the [PluginPolicy.Progress.AdminServer] section and add the following to the end of the current jvmargs line: -Djava.net.preferIPv4Stack=true -Djava.net.preferIPv6Addresses=false
This a quick cheat sheet of the commands that can be used when using zones (containers), for a more complete guide see solaris zones. Zone States Configured Configuration has been completed and storage has been committed. Additional configuration is still required. Incomplete Zone is in this state when it is being installed or uninstalled. Installed… Leer más »
https://blogs.oracle.com/mandalika/entry/solaris_10_zone_creation_for chmod 700 /desm chmod 700 /desm/zoneoe zlogin zoneoe shutdown -i 0 zoneadm -z zoneoe halt zoneadm -z zoneoe uninstall zoneadm list -cv zonecfg -z zoneoe ——————————- create -b set zonepath=/desm/zoneoe set autoboot=true set ip-type=shared add net set address=192.168.1.205 set physical=e1000g0 set defrouter=192.168.1.1 end remove inherit-pkg-dir dir=/usr remove inherit-pkg-dir dir=/sbin remove inherit-pkg-dir dir=/lib remove inherit-pkg-dir… Leer más »
For Progress 9.1D and later, the method for using the secondary login broker for SQL connections has changed. Databases that have both Progress ABL and SQL clients simultaneously connected should use a secondary login broker to avoid the following limitations caused by the use of a single login broker: The need to establish the maximum… Leer más »
I use postfix with MailScanner and that’s why I cannot use: /^Received:/ IGNORE in my header_checks file, because i use: /^Received:/ HOLD (see http://www.sng.ecs.soton.ac.uk/mailscanner/install/postfix.shtml ) But it’s no problem, because it’s possible to remove mail headers also with MailScanner. Example: ======== You want to remove information about your LAN structure from mail headers sent from… Leer más »
http://blog.datencamp.org/2012/08/howto-trick-nmaps-service-detection/
http://knowledgebase.progress.com/articles/Article/P119452 For the purposes of this solution examples will be made referring to database1, database2 and database3 which are all copies of the sports2000 database. All databases must be started with separate TCP/IP ports. The primary database (database1) should not be included within the database1.oesql.properties file mentioned below. In the directory where database1 resides create… Leer más »