Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. The subject says it all What is the best way to determine the exact version of the oracle client Im running Our clients are all running Windows. I found one. Ive run into this error dozens of times Cause. Security permissions were not properly set when the Oracle client was installed on Windows with NTFS. Burleson Consulting is an altruistic company and we believe in sharing our Oracle extensive knowledge through publishing Oracle books and Oracle articles, video. Hi Tom, Is there anyway that I can just use SQL to do string concatenation on a VARCHAR2 field much the same way that a SUM function is used on a NUMBER field. 6 Supporting Platforms SAP can be installed on Microsoft windows 2000, win2k3 2008 is under evaluation. It can be installed on 32bit or 64bit operating systems. 64. VMware v. Sphere 5 makes it even easier to run ESXi on ESXi, and now supports 6. Running VMware ESXi inside a virtual machine is a great way to experiment with different configurations and features without building out a whole lab full of hardware and storage. Virtualization enthusiasts everywhere have benefited from the ability to run ESXi on ESXi, first introduced with the v. Sphere 4 release. VMware v. Sphere 5 makes it easier than ever to virtualize hypervisor hosts. With new capabilities to run nested 6. ESXi VMs, the sky is the limit for your cloud infrastructure development lab. Heck, you can even run Hyper V on top of v. Sphere 5 not that youd want to. Physical Host Setup. The physical host running VMware ESXi 5 requires just a few configuration changes here is a guide Install VMware ESXi 5 on a physical host and configure networking, storage, and other aspects as needed. I remember a tool called ODUMP when I was using Oracle 8i on NetWare. The following web page explains how to import and export data httpwww. orafaq. comwikiImport. Configure a v. Switch andor Port Group to have Promiscuous Mode enabled. Create a second Port Group named Trunk with VLAN ID All 4. VLANs on virtual hypervisors. Log in to Tech Support Mode i. LO or ssh and make the following tweak to enable nested 6. TRUE gt gt etcvmwareconfig. TRUE gt gt etcvmwareconfig. Virtual VMware ESXi Machine v. ESXi Creation. For various reasons, its not feasible to clone virtual ESXi VMs. As an alternative, create a fully configured shell VM to use as a template it can be cloned before ESXi is installed. Create a new VM with the following guidance Nested 6. Guests. With the release of VMware v. Sphere 5, nested guests can be 6. Just be sure to make the change to etcvmwareconfig on the physical host as indicated above. Nested guests can be migrated with v. Motion between virtual or physical VMware ESXi hosts this requires a v. Motion network and shared storage. Nested Hyper V Virtual Machines. It is possible to run other hypervisors as v. Sphere virtual machines, and even power on nested VMs. Here you can see Hyper V running a Cent. OS virtual machine all on VMware ESXi. Talk about disrupting the space time continuum A couple of extra tweaks are needed to enable this, and performance is not great. Nevertheless, an amazing feat of engineering from VMware Do the following to enable Hyper V on VMware ESXi Add hypervisor. FALSE to the VM configuration. Add h to the CPU mask for Level 1 ECX IntelFor another take, check out William Lams post on this topic. Parting Thoughts. Given the right hardware, it is possible to create a fully functional VMware test lab that is completely virtual. Go ahead and experiment with the Distributed Virtual Switch, v. Shield, v. Cloud Director, and everything else without deploying a ton of servers and storage. How are you taking advantage of a virtual v. Sphere environment Follow ericgray. Toad for Oracle Release Notes. Toadfor Oracle. Version 1. 1. 0. Release Notes. September 3. 0, 2. Contents. Welcome to Toad for Oracle. Toad for Oracle provides an efficient and accurate way for database professionals of all skill and experience levels to perform their jobs with an overall improvement in workflow and productivity. With Toad for Oracle you can Understand your database environment through visual representations. Meet deadlines easily through automation and smooth workflows. Perform essential development and administration tasks from a single tool. Deploy high quality applications that meet user requirements and perform reliably in production. Validate database code to ensure the best possible performance. Manage and share projects, templates, scripts, and more with ease. The Toad for Oracle solutions are built for you, by you. Over 1. 0 years of development and feedback from various communities like Toad World have made it the most powerful and functional tool available. With an installed base of over one million, Toad for Oracle continues to be the standard tool for development and administration. Toad for Oracle Editions. All commercial versions of Toad are bundled with additional Quest products, based upon the Edition that you purchased. For more information about the latest features in your Toad Edition and the bundled products, see the Toad Editions Release Notes. Back to Top. New in This Release. Review the following sections for new features in this release. All Toad Editions. General. The following features no longer require the DB Admin module, and are now available in the Base edition of Toad Oracle Parameters window Database Administer Oracle ParametersAltering audit options in the Schema Browser. Audit Objects window Database Administer Audit ObjectsAudit SQLSys Privs window Database Administer Audit SQLSys PrivsMaintaining the following object types in the Schema Browser Directories, Profiles, Resource Consumer Groups, Resource Plans, Roles, Rollback Segments, DBMSScheduler Objects, System Privileges, and Tablespaces. Toad now features a Rerun menu. It allows you to quickly re execute windows that were recently executed via a Toad Action. Select More on the menu to see all available actions. The Automation Designer has a new RexecSSH action. This allows you to execute a command on a remote server. It is available on the Utilities tab of the Automation Designer. The Automation Designer has a new Create Variable action. You can create a local variable temporary, only used for the execution of the app or a global variable permanent, saved in Toad Options and persists after execution. This action is available on the Control tab in the Automation Designer. Editor. You can now perform basic calculations on grid cells, such as finding the sum or average of the selected cells. To use this feature, select adjacent cells in the grid and click in the grid toolbar CTRLN. The calculations display in a new row below the grid. Idea Pond 7. 5. You can now save your settings in the Find and Replace window as a reusable macro. To use this feature, click. See Find and Replace Text in the online help for more information. Idea Pond 1. 33. To quickly reuse a macro, click the arrow beside on the Edit toolbar and select it from the list. You can easily execute a SQL statement embedded within PLSQL. To use this feature, place the cursor in the statement and press SHIFTF9. A new window displays with the extracted and reformatted SQL statement. You can export your saved SQL and import it back into Toad. Toad exports your history, personal, and named SQL statements from SQL Recall. To use this feature, open the SQL Recall pane F8, and click the Import or Export buttons on the SQL Recall toolbar. The Editor now helps you complete parameters by inserting the parameter signature. It creates placeholders for the parameter values, which you can type over and use TABSHIFTTAB to navigate between. You can also have Toad use a named notation this option can be enabled on the Toad Options Code Assistance page. Idea Pond 4. 11. Schema Browser Schema drop downs have been updated, and now it is easier to customize them by creating a list of favorites, hiding schemas, setting the default schema for connections, and other options. The changes apply to all windows with the schema drop down, such as the Editor and Schema Browser. See Customize Schema Browser Tabs in the online help for more information. Idea Pond 3. 2. When you view a tables data in the Schema Browser, you can split the window to also show child or parent tables in a new detail grid. You can also change the query for the detail grid. To use this feature, click the Show Detail Dataset button on the Data tab toolbar. If the table has a single foreign key, Toad automatically displays the related table. If there is more than one foreign key, click the arrow beside the ViewEdit Detail Query button on the detail grid toolbar and select the table. Toad remembers your selection. The History button has been replaced with forward and back buttons. History is still available as a drop down on the new buttons. Items will now only be added to history when you stop on them for at least one second. Consequently, holding the up or down arrow key to browse no longer fills your history with items you browsed past. Team Coding and Source Control. The source control setup process has been redesigned, and it is now much simpler to select a version control system VCS and set up Team Coding. To set up a VCS on its own, select View Toad Options Source Control. To set up Team Coding, select Utilities Team Coding Configure Team Coding. See Set Up Team Coding in the online help for more information. The source control toolbars have been combined and simplified. Now, you can perform all of your source control tasks from one toolbar, regardless of whether you use just Team Coding, just a VCS, or both. To view the toolbar, right click the menu area and select Team Coding. Source control now has a Check in All Files button on the toolbar, which lets you check in all files or objects which you currently have checked out. Code Control Groups have been replaced by Code Collections. Code Collections combine information in Code Control Groups and the Team Coding Mask in a single user view, thereby making it easier to set up groups for Team coding. See Create Code Collections in the online help for more information. Team Coding roles have been simplified, and now there is only one role TCADMINROLE. This helps simplify setting up Team Coding. All other users in the database can automatically use Team Coding with restricted privileges. See Team Coding Roles in the online help for more information. When a user with the TCADMINROLE sets up a VCS, Toad stores the server settings as the default for all Team Coding users. This makes it much easier to set up Team Coding for a group of developers. This feature only works with Microsoft Team Foundation Server, Perforce, and Subversion. Connections. You can now save database connection settings without connecting to the database. To use this feature, from the Database Login window click. See Create New Connections in the online help for more information. Idea Pond 2. 34. You can now easily edit saved database connection settings. To use this feature, select the connection in the Database Login window and click on the window toolbar.