Turing's Man Blog

Part 11. Enabling hr user for connections with the Oracle Database 11gR2 and configuring tnsnames.ora for TNS connection type availability on the client side

We have created and configured the "basic" type connections for sys and system users in the part 10. This is required to unlock hr user, who is locked by default in each Oracle Database 11gR2 installation, and to set a password for him (in our case: turing$man). We will now take care about hr user and – also – we will configure TNS (ang. Transparent Network Substrate) interface for connections between client and server (with the usage of hr account, of course).

Read more...

Part 10. Configuring sys and system users' connections for SQL Developer in Oracle Database 11gR2 Client

We have successfully installed Oracle Database 11gR2 Client software in part 9. No matter that MS Windows 8 and JDK 7 are unsupported by this version of client software, it seems everything works good enough for our further explorations. Now, we should create and configure three basic connections in SQL Developer, respectively for the following users: sys, system and hr. Let's do that.

Read more...

Part 9. Oracle Database 11gR2 Client installation on – unsupported – MS Windows 8

Now, as we have our MS Windows 8 installed in Oracle VirtualBox (part 8), we can install Oracle Database 11gR2 Client. This will allow us to connect from MS Windows 8 to Solaris 11.1, where our Oracle Database 11gR2 is run. This part will be very straightforward, however, we have to remember that MS Windows 8 is not supported, hence not allowed in production environments (although such scenario is very possible in all kinds of development environments). It was said in previous parts, but... Anyway, we should remember this series is more about experiments than production systems. Let's go.

Read more...

Part 8. MS Windows 8 installation under Oracle VirtualBox

I prepared all the materials for this part more than two months ago. It will be an easy part. Firstly, we have to install MS Windows 8 on VirtualBox. Secondly, we will install Oracle Client 11g software and configure everything to connect to our Oracle Database 11gR2 we run on Solaris 11.1. Please note, MS Windows 8 is not supported by Oracle Client in this version yet, although, it's only more interesting to see how it works. All in all, we're not setting production environment, where all the components have to be certified and supported, but we are experimenting for fun.

Read more...

Part 7. Checkpoint for Oracle Database 11gR2 installation. Configuration files, basic tools and common issues

We had a short break after part 6 of this series. Believe it or not, there was a really important reason for me to stop writing for a while – although, this is quite a different story. Now, we're back to finish with our experiments with Oracle Database 11gR2 on Solaris 11.1. What was really nice, during the last two months I received some emails and comments with your suggestions and opinions on this series. Therefore, I would like to thank you all for positive feedback and additional inspiration. Now, we can come back to work.

Read more...