Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Hardware dummy trying to set up Unix workstation for Oracle at home for practice! Post 11374 by LivinFree on Tuesday 4th of December 2001 03:24:57 AM
Old 12-04-2001
Well, if you wanted to run SQLServer (I am assuming Microsoft SQLServer), you could dual-boot, but keep in mind you would not be able to run them at the same time, generally speaking. Normally, when you dual boot, you are working with one OS, or the other. There are certain solutions (I think VMWare could do something like this), but keeping costs, details, and simplicity in mind, it's probably not the best solution.

If you accepted beforehand that you could only work with one at a time, it could be a very viable solution... Also, you could run multiple Unix SQL databases on the same machine at once (MySql, Oracle, PostgreSQL, etc...) without having to reboot to switch operating systems, although you would take somewhat of a performance hit running so much at once... Yet another twist on the latter option would be to have the databases set up, just turn each one on as you use it, and off again when you're done.

Lots of choices!
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Set up the own Unix ENvironment at home

Hello! All Unix Expert, I just graduated from college with Bachalor degree in Computer Information System, and decided to start my career in Unix System. I am trying to set up my own unix Environment at home so that I can get more hand on experience since the class offered by unix vendors are... (1 Reply)
Discussion started by: jung1975
1 Replies

2. UNIX for Advanced & Expert Users

How to set up dummy printer on UNIX

Hi, I work at IT department of a home furnishing company in Canada. Presently we are working on printer issue on UNIX system and we like to set up a dummy printer on the system. We are not much sure about the procedure to try it and it woul dbe great if we get some advice to go ahead. Thanks... (3 Replies)
Discussion started by: srabanti
3 Replies

3. UNIX for Dummies Questions & Answers

VMWare Workstation for home lab

I was wondering if anyone has used VMWare Workstation? I wanted to practice and learn Unix in a networking environment and have my own home lab. However room and money prevent me from buying several computers to do so. Any input would help thank you. (0 Replies)
Discussion started by: vedder191
0 Replies

4. Shell Programming and Scripting

$HOME Not Getting Set for Oracle Scheduler Script at Runtime

We are researching the possibility of using Oracle 10g Scheduler on Solaris 10 to launch scripts at our site, and the script that I am testing does not get $HOME (and other environment variables) set correctly. Here is the Korn shell script (show_info.ksh): #!/usr/bin/ksh id env | sort Here... (4 Replies)
Discussion started by: shew01
4 Replies

5. Solaris

free software to test the hardware of a sun workstation specially the RAM how about f

hi can anybody give me a site that provide a free software for sun solaris workstation to test above title. i downloaded this RUMT-0.2 sofware in the net but it doesn't work after i try. thnks a lot for any help. (1 Reply)
Discussion started by: jao_madn
1 Replies

6. UNIX for Dummies Questions & Answers

To practice Unix at home

Hi Everyone, Gud Afternoon. Myself Amol working on unix (vi editor ). I want to practice shell scripts and vi editor command at home. So can anyone guide me, if there is any standalone application or some software like vi editor which can be installed at my home PC and i can... (9 Replies)
Discussion started by: Amol_Dicholkar
9 Replies

7. Solaris

Sun Workstation Hardware - Is it broken?

Hi everyone! I have an odd question - If a sun workstation (Blade 2000) boots up into a login prompt, is there any chance that it could have hardware issues? Or once it gets that far is it 100% working. I cant play with it before buying, so was interested to see if anyone could shed some... (4 Replies)
Discussion started by: ajdiamond
4 Replies

8. UNIX for Dummies Questions & Answers

Newbie Wants Hardware For Practice?

I want a cheap dedicated machine to install a flavour of unix on and try to learn this OS. I know nothing about unix, just gone out and bought some books etc. Should I just get the cheapest old laptop off Ebay to install it on? What type of unix OS should I install?...a version of... (5 Replies)
Discussion started by: IBMPBC
5 Replies

9. UNIX for Dummies Questions & Answers

Unix set home directory

Hi I've just made a directory, what command do I use to now make it the base directory? Thanks!!!!!!!!!!!!!!! (1 Reply)
Discussion started by: beckywatson
1 Replies

10. Shell Programming and Scripting

Bash set dummy ?

Could somebody please provide me with verbatim description / purpose of the following ? set dummy $ac_prog; ac_word=$2 set dummy $ac_tool_prefix; ac_word=$2 could it be written set dummy $ac_prog; ac_word=$2 set dummy $ac_tool_prefix; ac_word=$2 (9 Replies)
Discussion started by: anne
9 Replies
OCI_SET_CLIENT_IDENTIFIER(3)											      OCI_SET_CLIENT_IDENTIFIER(3)

oci_set_client_identifier - Sets the client identifier

SYNOPSIS
bool oci_set_client_identifier (resource $connection, string $client_identifier) DESCRIPTION
Sets the client identifier used by various database components to identify lightweight application users who authenticate as the same database user. The client identifier is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement is executed. The identifier can subsequently be queried, for example with SELECT SYS_CONTEXT('USERENV','CLIENT_IDENTIFIER') FROM DUAL. Database admin- istration views such as V$SESSION will also contain the value. It can be used with DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE for tracing and can also be used for auditing. The value may be retained across page requests that use the same persistent connection. PARAMETERS
o $connection -An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3). o $client_identifier - User chosen string up to 64 bytes long. RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 Setting the client identifier to the application user <?php // Find the application user's login name session_start(); $un = my_validate_session($_SESSION['username']); $c = oci_connect('myschema', 'welcome', 'localhost/XE'); // Tell Oracle who that user is oci_set_client_identifier($c, $un); // The next roundtrip to the database will piggyback the identifier $s = oci_parse($c, 'select mydata from mytable'); oci_execute($s); // ... ?> NOTES
Caution Roundtrip Gotcha Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is enabled. SEE ALSO
oci_set_module_name(3), oci_set_action(3), oci_set_client_info(3). PHP Documentation Group OCI_SET_CLIENT_IDENTIFIER(3)
All times are GMT -4. The time now is 08:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy