Exadata Database Machine X3-2 Data Sheet New 10/29/2012
Up to 18 racks can be connected without requiring additional InfiniBand switches.
Exadata Database Machine X3-8 Data Sheet New 10/24/2012
Scale by connecting multiple Exadata Database Machine X3-8 racks or Exadata Storage Expansion Racks. Up to 18 racks can be connected by simply connecting via InfiniBand cables. Larger configurations can be built with additional InfiniBand switches.
You want access to Oracle Technology Network updates from a mobile device, you say? Well you can have that today.
The official Oracle app for iOS, Android, and BB is useful for many things, but my personal favorite is the "Developers" channel:
From there, it's trivial to consume links to things tagged by the OTN team - which may include "home" content or curated links from other places:
All in all, it's a good way to stay in touch!
<b>Serverwatch:</b> "Based on Oracle's recent actions, it seems the company is hell-bent on driving as many of its potential customers as possible away from the UNIX offerings it acquired from Sun and into the arms of Red Hat and other enterprise Linux vendors."
The popular PTS (Platform Technology Services) technical trainings for partners now include a workshop on Big Data.
First workshop will take place in Milan on July 10-12. (You can register by clicking the link below)
Oracle Big Data
Technical
Workshop
July
10-12,
2012: Cinisello Balsamo, Milan, Italy
For more info contact [email protected]
In a prior article on Oracle's Block Browser and Editor tool (BBED), the installation of the tool was covered. In this article, we'll look at starting a session using a simple database and see how to view data.
I use my laptop TOSHIBA, 4gig RAM, more 40gig free disks spaces and Vista Home Premium 64bits with service pack 2.
I installed Oracle VM VirtalBox with success, after I installed UBUNTU version 8 with success !
I need to transfer files between Vista and UBUNTU on the same laptop, how I can do that ?
Can I use SAMBA ? I try to use SAMBA but it is not success ! How I can install SAMBA on UBUNTU v.8 ?
hi, i am making a database for an accounting/sales type system similar to a car sales database and would like to make some transactions for the following real world actions
salesman creates new product shipped onto floor (itempk, car make, year, price).
salesman changes price.
salesman creates sale entry for product sold (salespk, itemforeignkey, price sold, salesman).
salesman cancels item for removed product.
salesman cancels sale for cancelled sale
the examples i have found online are too generic...like this is a transaction... i would like something resembling what i am trying to do to understand it.
anybody have some good similar or related sql examples i can look at to design these? do people use transactions for sales databases? or if you have done this kind of sql transaction before could you make an outline for how these could be made? thanks
my thread so far on stack overflow...
http://stackoverflow.com/q/4975484/613799
A few years ago I was speaking at a conference in Raleigh, NC where Ted Neward and I found a fun way to promote a Java vs. .NET debate that was planned one evening. We stood in the middle of a crowd during one of the breaks and starting “arguing” about Java vs. .NET with one another. Our voice levels quickly raised and we ended it by slapping each other across the face with a glove to request a challenge. It was a great way to segue to our announcing of the actual debate planned later that evening....(read more)
What is the best way to build an open source database?
I would like to build a database of all vehicles and the related maintenance information (i.e Oil Weight, Quantity, Tire Pressure, Windshield wipers etc). Currently this information is fragmented or just not put on line in an open way. Once collection began I would want to import into a DB and then be able to distribute freely.
Is there a process (site or group) that I can start gathering this information in a reliable and verifiable way?
Is there any issues that I should watch out for?
Hello All,
I am using NetBeans IDE 7.0.1 on Windows 7 very first time for my php. Actually in my company there is a local server ( 192.168.1.99) where all projects resides and we access phpmyadmin of that local server, Although I have added my project folders with NetBeans (this was also very hectic) but now I am having problem to connect database of my local server as I can see 192.168.1.99/phpmyadmin through my browser.
I have set below value
Server Host : localhost,
Server port number : 3306,
Administrator username : keshav
Administrator password : ******
and when i click on connect, a popup error windows appears with below text
Unable to connect to the MySQL server:
org.netbeans.api.db.explorer.DatabaseException:
org.netbeans.api.db.explorer.DatabaseException: java.sql.SQLException: Access denied
for user 'keshav'@'localhost' (using password: YES).
The server may not be running or your MySQL connection properties
may not be set correctly. Do you want to edit your MySQL connection properties?
Please help me out.
Thanks
Big Data stellt die nächste große Herausforderung für die IT-Branche dar: Massen von Daten aus immer mehr Quellen – aus sozialen Netzwerken, Telekommunikations- und Weblogs, RFID-Lesern etc. – müssen logisch verknüpft, in Echtzeit integriert und verarbeitet werden. Doch wie sieht es mit der praktischen Umsetzung aus? Eine europaweite Studie von Steria Mummert Consulting zeigt: Lediglich 28 % der Unternehmen haben bereits heute eine übergreifende, abgestimmte Business-Intelligence-Strategie implementiert. Vorherrschend sind BI-Insellösungen, die schon jetzt an den Grenzen ihrer Kapazität arbeiten. Daten werden also bisher nur eingeschränkt als wertschöpfende Ressource genutzt! Das Ergebnis der Studie klingt erschreckend, doch Unternehmen können es zu Ihrem Vorteil nutzen: Wer jetzt das Thema Big Data anpackt, kann sich einen gewinnbringenden Vorsprung vor dem Wettbewerb sichern.
Wie sieht die Analyse-Umgebung der Zukunft aus?
Wie und wo kann Big Data für den Geschäftserfolg genutzt werden?
Antworten darauf liefert die Kunden-Event Reihe von Oracle und dem Oracle Platinum Partner Steria Mummert Consulting: Hier werden Strategien entwickelt, wie Unternehmen mit Information Discovery ihr BI-Potenzial auf dem Weg zur Big Data Schritt für Schritt ausbauen können.
Highlights aus München
Durchweg positives Feedback haben wir aus München, der ersten Station der Eventreihe am 23.7., erhalten: Nicht nur die tolle Location, das "La Villa" im Bamberger Haus, überzeugte. Die 31 Teilnehmerinnen und Teilnehmer konnten auch inhaltlich eine Menge mitnehmen – unter anderem einen konkreten Vorschlag für ihre eigene Roadmap in Richtung Big Data. Die Ausgangsfrage des Tages lautete – einfach und umfassend zugleich: Wie können wir den Überblick in einer komplexen Welt behalten? Den Status quo in Europa für Business Intelligence präsentierte Steria Mummert Consulting entlang der Europäischen biMA®-Studie 2012/13. Anhand von Anwendungsbeispielen aus ihrer Praxis präsentierten die geladenen Experten von Oracle und Steria Mummert Consulting verschiedene Lösungsansätze. Eine sehr anschauliche Demo zu Endeca zeigte beispielsweise, wie einfach und flexibel ein Dashboard sein kann: Hier gibt es keine vordefinierten Reports, stattdessen können Entscheider die Filter einfach per Drag & Drop verändern und bekommen so einen individuell sturkturierten Überblick über ihre Daten. Einen Ausblick bot die Session zu Oracle Business Analytics für mobile Anwendungen und Real-Time Decisions. Fazit: eine gelungene Mischung aus Überblicks-Informationen und ganz konkreten Ideen für die spezifischen Anwendungsbereiche der Kunden.
Die Eventreihe „BI goes Big Data“ macht im August in Hamburg und Frankfurt Station. Die kostenfreie Veranstaltung findet zusammen mit Steria Mummert Consulting statt und richtet sich an Endkunden. In Hamburg am 14.8.2013 – zur AnmeldungIn Frankfurt a.M. am 20.8.2013 – zur Anmeldung
I'm currently discussing with my Oracle DBA Collegue that request a root access on our production servers.
I'm not so hot to let him use the root access on our production servers.
He is arguing that he need it to perform some operations like restarting the server and some other obscure arguments.
The point is that I'm not agree with him because I've set him a Oracle user/group and a dba group where Oracle user belong. Everything is running smoothy and without any root permissions for now.
I also think that all administrative tasks like scheduled server restart and so one need to be operated by the proper administrator (The Systems administrator on our case) to avoid any kind of issues related to a misunderstanding of the infrastructure interactions.
So, I need the help of both, sysadmins and Oracle DBAs to lead me on the correct direction.
If my collegue really need this rights I'll give him, but I'm just basically quite affraid of that because of security and integrity concerns.
I know that my collegue is really good as a Oracle DBA and he know is work very well, but I also know that I've very few cases where a software and its admin really need root access.
Once again, I'm not looking for pros/cons but rather an advice on the way that I should take to deal with this situation.
Mike and I are really looking forward to our trip to Japan next week, not least because we will have the opportunity to visit the Japan Oracle User Group for a Tech Talk. You can find all of the details about this event here:
JPOUG Tech Talk, Tuesday, 12-NOV-2013
The topic for our talk will be "Different ways to Upgrade, Migrate, and Consolidate with OracleDatabase 12c."We will discuss changes and enhancements to database upgrade, how to move into a multitenant database environment, and new features that make database migration easier and faster than ever.
Thank you to our friends at the JPOUG for making this event possible!
It has been a while since I last posted a utility query, and today, to avoid other work I am supposed to be doing, I decided to go ahead and work on another post. Today, I went ahead and worked on a server configuration type query. One query I find I use pretty often is the following one that lists the files in the database. In this blog I will include 3 queries. The first will deal with files and databases, and the second runs in a database to see the files and their filegroups (If there...(read more)
Oracle annonce les premières spécifications de Java9
Jigsaw reste une priorité mais n'est pas encore làÀ moins de deux ans de sa date de sortie prévue, Java9 commence à voir le jour grâce à l'annonce récente de la première série de propositions d'amélioration connue aussi sous le nom de JEP (Java Enhancement Proposals).Pour rappel, les JEP sont les nouveaux processus permettant le développement et le test de fonctionnalités relatives au langage Java ou à sa machine virtuelle, sans recourir au processus...
A few years ago we decided to increase our investments in documenting retail processes and architectures. There were several goals but the main two were to help retailers maximize the value they derive from our software and help system integrators implement our software faster. The sale is only part of our success metric -- its actually more important that the customer realize the benefits of the software. That's when we actually celebrate.
This week many of our customers are gathered in Chicago to discuss their successes during our annual Crosstalk conference. That provides the perfect forum to announce the release of the Oracle Retail Reference Library. The RRL is available for free to Oracle Retail customers and partners. It contains 1000s of hours of work and represents years of experience in the retail industry. The Retail Reference Library is composed of three offerings:
Retail Reference Model
We've been sharing the RRM for several years now, with lots of accolades. The RRM is a set of business process diagrams at varying levels of granularity. This release marks the debut of Visio documents, which should make it easier for retailers to adopt and edit the diagrams. The processes represent an approximation of the Oracle Retail software, but at higher levels they are pretty generic and therefore usable with other software as well. Using these processes, the business and IT are better able to communicate the expectations of the software. They can be used to guide customization when necessary, and help identify areas for optimization in the organization.
Retail Reference Architecture
When embarking on a software implementation project, it can be daunting to start from a blank sheet of paper. So we offer the RRA, a comprehensive set of documents that describe the retail enterprise in terms of logical architecture, physical deployments, and systems integration. These documents and diagrams describe how all the systems typically found in a retailer enterprise work together. They serve as a way to jump-start implementations using best practices we've captured over the years.
Retail Semantic Glossary
Have you ever seen two people argue over something because they're using misaligned terminology? Its a huge waste and happens all the time. The Retail Semantic Glossary is a simple application that allows retailers to define terms and metrics in a centralized database. This initial version comes with limited content with the goal of adding more over subsequent releases. This is the single source for defining key performance indicators, metrics, algorithms, and terms so that the retail organization speaks in a consistent language.
These three offerings are downloaded from MyOracleSupport separately and linked together using the start page above. Everything is navigated using a Web browser. See the Oracle Retail Documentation blog for more details.
Oracle’s Specialization Program is a trusted status and brand, which allows our
most experienced and committed partners to differentiate themselves in the
marketplace and gain a competitive edge by spotlighting their strengths and
special skills.Partners can choose where they want to specialize from a
wide range of Specializations from Oracle’s growing product portfolio.
Click here to read more.
Hi, everyone:
By now, I hope you would have a chance to review the sample
applications and try to deploy it. This is a great way to get
started on learning ADF Mobile. To help you getting started,
here is a central list of "steps to get up to speed on ADF Mobile" and
related resources that can help you developing your mobile application.
Check out the ADF Mobile Landing Page on the Oracle
Technology Network.
View this introductory video.
Read this Data Sheet and FAQ on ADF Mobile.
JDeveloper 11.1.2.3 Download.
Download the generic version of JDeveloper for
installation on Mac.
Note that there are workarounds required to install JDeveloper on a Mac.
Download ADF Mobile Extension from JDeveloper Update
Center or Here.
Please note you will need to configure JDeveloper for
Internet access (In HTTP Proxy preferences) in order the install the
extension, as the installation process will prompt you for a license
that's linked off Oracle's web site.
View this end-to-end application creation video.
View this end-to-end iOS deployment video if
you are developing for iOS devices.
Configure your development environment, including
location of the SDK, etc in JDeveloper-Tools-Preferences-ADF Mobile
dialog box. The two videos above should cover some of these
configuration steps.
Check out the sample applications shipped with
JDeveloper, and then deploy them to simulator/devices using the steps
outlined in the video above. This blog entry outlines all
sample applications shipped with JDeveloper.
Develop a simple mobile application by following this tutorial.
Try out the Oracle Open World 2012 Hands on Lab
to get a sense of how to programmatically access server data.
You will need these source files.
Ask questions in the ADF/JDeveloper Forum.
Search ADF
Mobile Preview Forum for entries from ADF Mobile Beta Testing
participants.
For all other questions, check out this exhaustive and
detailed ADF Mobile Developer Guide.
If something does not seem right, check out the ADF Mobile Release Note.
Thanks,
Oracle ADF Mobile Product Management Team
When restoring a database backup, by default, SQL Server places the database files in the master database file directory. In this example, that location is in L:\MSSQL10.CHTL\MSSQL\DATA as shown by the issuance of sp_helpfile Hence, the restored files for the database CHTL_L2_DB are in the same directory Per SQL Server best practices, the log file should be on its own disk drive so that the database and log file can operate in a sequential manner and perform optimally. The steps to move the log file is as follows: Record the location of the database files and the transaction log files Note the future destination of the transaction log file Get exclusive access to the database Detach from the database Move the log file to the new location Attach to the database Verify new location of transaction log Record the location of the database file To view the current location of the database files, use the system stored procedure, sp_helpfile 1: use chtl_l2_db
2: go
3:
4: sp_helpfile
5: go
Note the future destination of the transaction log file
The future destination of the transaction log file will be located in K:\MSSQLLog
Get exclusive access to the database
To get exclusive access to the database, alter the database access to single_user. If users are still connected to the database, remove them by using with rollback immediate option. Note: If you had a pane connected to the database when the it is placed into single_user mode, then you will be presented with a reconnection dialog box.
1: alter database chtl_l2_db
2: set single_user with rollback immediate
3: go
Detach from the database
Now detach from the database so that we can use windows explorer to move the transaction log file
1: use master
2: go
3:
4: sp_detach_db 'chtl_l2_db'
5: go
After copying the transaction log file
re-attach to the database
1: use master
2: go
3:
4: sp_attach_db 'chtl_l2_db',
5: 'L:\MSSQL10.CHTL\MSSQL\DATA\CHTL_L2_DB.MDF',
6: 'K:\MSSQLLog\CHTL_L2_DB_4.LDF',
7: 'L:\MSSQL10.CHTL\MSSQL\DATA\CHTL_L2_DB_1.NDF',
8: 'L:\MSSQL10.CHTL\MSSQL\DATA\CHTL_L2_DB_2.NDF',
9: 'L:\MSSQL10.CHTL\MSSQL\DATA\CHTL_L2_DB_3.NDF'
10: GO
One might expect Oracle to be doing everything in its power to discourage customers from moving away from UNIX. Yet the company seems determined to hawk Linux.
We have a set of automated tests that restore a database then run some .net code against the database. Sometimes after the database is restored the login from Ado.net fails. If I re-run the test, then the restore and login works OK. The restored database looks OK when viewed with Management Studio.
This is only an problem on some machines.
We are using SQL server 2008.
Is there a known issue with a database restore “returning “ a very short time before the restored database is up and running.
For a majority of software developers little time is spent understanding the inner workings of the database management systems (DBMS) they use to store data for their applications. I personally place myself in this grouping. In my case, I have used various versions of Microsoft’s SQL Server (2000, 2005, and 2008 R2) and just recently learned how valuable they really are when I was preparing to deliver a lecture on "SQL Server 2008 R2, System Databases".
Microsoft Sql Server 2008 R2 System DatabasesSo what are system databases in MS SQL Server, and why should I know them? Microsoft uses system databases to support the SQL Server DBMS, much like a developer uses config files or database tables to support an application. These system databases individually provide specific functionality that allows MS SQL Server to function.
Name
Database File
Log File
Master
master.mdf
mastlog.ldf
Resource
mssqlsystemresource.mdf
mssqlsystemresource.ldf
Model
model.mdf
modellog.ldf
MSDB
msdbdata.mdf
msdblog.ldf
Distribution
distmdl.mdf
distmdl.ldf
TempDB
tempdb.mdf
templog.ldf
Master DatabaseIf you have used MS SQL Server then you should recognize the Master database especially if you used the SQL Server Management Studio (SSMS) to connect to a user created database. MS SQL Server requires the Master database in order for DBMS to start due to the information that it stores.
Examples of data stored in the Master database
User Logins
Linked Servers
Configuration information
Information on User Databases
Resource DatabaseHonestly, until recently I never knew this database even existed until I started to research SQL Server system databases. The reason for this is due largely to the fact that the resource database is hidden to users. In fact, the database files are stored within the Binn folder instead of the standard MS SQL Server database folder path. This database contains all system objects that can be accessed by all other databases. In short, this database contains all system views and store procedures that appear in all other user databases regarding system information. One of the many benefits to storing system views and store procedures in a single hidden database is the fact it improves upgrading a SQL Server database; not to mention that maintenance is decreased since only one code base has to be mainlined for all of the system views and procedures.
Model DatabaseThe Model database as the name implies is the model for all new databases created by users. This allows for predefining default database objects for all new databases within a MS SQL Server instance. For example, if every database created by a user needs to have an “Audit” table when it is created then defining the “Audit” table in the model will guarantees that the table will be located in every new database create after the model is altered.
MSDB DatabaseThe MSDBdatabase is used by SQL Server Agent, SQL Server Database Mail, SQL Server Service Broker, along with SQL Server. The SQL Server Agent uses this database to store job configurations and SQL job schedules along with SQL Alerts, and Operators. In addition, this database also stores all SQL job parameters along with each job’s execution history. Finally, this database is also used to store database backup and maintenance plans as well as details pertaining to SQL Log shipping if it is being used.
Distribution DatabaseThe Distribution database is only used during replication and stores meta data and history information pertaining to the act of replication data. Furthermore, when transactional replication is used this database also stores information regarding each transaction. It is important to note that replication is not turned on by default in MS SQL Server and that the distribution database is hidden from SSMS.
Tempdb DatabaseThe Tempdb as the name implies is used to store temporary data and data objects. Examples of this include temp tables and temp store procedures. It is important to note that when using this database all data and data objects are cleared from this database when SQL Server restarts. This database is also used by SQL Server when it is performing some internal operations. Typically, SQL Server uses this database for the purpose of large sort and index operations.
Finally, this database is used to store row versions if row versioning or snapsot isolation transactions are being used by SQL Server.
Additionally, I would love to hear from others about their experiences using system databases, tables, and objects in a real world environments.
“With Oracle’s end-to-end hardware and software solutions, we seamlessly migrated 22 applications from the legacy platform to the new platform in just seven weeks. Thanks to Oracle, we gained an integrated view of enterprisewide data across 49 locations and increased storage capacity by 25%, enabling us to improve service delivery and support our revenue-growth target.” - Ved Prakash Nirbhya, CIO, Tech Mahindra Limited
Read full story details here