Go Premium for a chance to win a PS4. Enter to Win

x

Operating Systems

34K

Solutions

36K

Contributors

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi! To avoid going via a OS file, I want to write my Oracle script's output directly to the OLEDBDATAAdapter system.data.datatable from Oracle OraOLEDB.Oracle.

When I send a regular SELECT...someting, it is returned fine. However, I need to do some additional tweaking after that, so I am using a procedure and some additional code in SQL to achieve this. Creating an OS-file and send the result out there, works fine. But rather than doing that, it would be much more convenient and secure to do it directly into the system.data.datatable of OLEDBDATAAdapter.

Can anyone give any advice as how to achieve this? As you probably understand, this isn't my main area of expertise :-)

Thanks for any help!

Brgds
IVer in Oslo
0
 
LVL 63

Expert Comment

by:☠ MASQ ☠
Iver, use this link and ask a question of our Oracle experts
https://www.experts-exchange.com/askQuestion.jsp
0
Free Tool: Port Scanner
LVL 11
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

2
What’s the first thing you install—or uninstall—on a new system?
The first thing I install on a new PC system (other than OS & drivers) is usually a tie between the Chrome browser and Blizzard's Battle.net client, closely followed by Adobe Lightroom and Photoshop. On my Mac, I skip straight to Lightroom and Photoshop, since I'm happy with Safari and don't try to game much on that system (that's what the PC is for ;-)

As for uninstalling, usually nothing... My last PC was a custom build so there wasn't any junk on it and Macs are great about not having anything I don't want.
3
 
LVL 7

Author Comment

by:Brian Matis
Yeah, definitely got to take care of all the OS and driver patches first! What do you do after all that?
0
 
LVL 33

Expert Comment

by:shalomc
I don't install PCs for a living, and only do that for select family members: myself, children, wife and mother in law.
Everybody gets Chrome, Office and Adobe Acrobat reader.
Then for each their tools of trade. This is the list of first installations as happened during the past year.

For me:
* Virtual box, Git, JDK, Python, Jetbrains IDE, curl, whois, dig, jq, notepad++, skype, mumble and Eve Online

For my mother in law:
* OE Classic

For my wife:
* Photoshop, Invision, Premiere

For my son:
* Minecraft, Netflix

For my daughter:
* Matlab, Netflix
1
What’s the first thing you install—or uninstall—on a new system?
Install - Chrome
Uninstall - Nothing.  I don't buy pre-loaded software machines; I install my own OS.
5
 
LVL 99

Expert Comment

by:John Hurst
I do not have any issue at all with Windows 10 Pro preinstalled OEM by Lenovo. BIG HUGE waste of time to blow it away and spend a day redoing it for nothing.

Latterly only one piece of Lenovo software bit the dust (Lenovo Solution Center) which was replaced with a better piece of software. Voluntary (optional) Lenovo software need not be installed and I do not.
1
 
LVL 11

Expert Comment

by:Maclean
It is a personal preference really in the end. It does not bug some as much as others,
One might have plenty of resources and decide that it has little to no impact on their experience.
So whether it is a waste of time depends on what one wants from their system.
Personally I prefer max performance and security. The fewer 3rd party apps or vendor apps, the better.

Lenovo is not as bad as some other firms with their own apps but has also been tapped by for example Duo due to big security vulnerabilities in software allowing hackers to bypass protection software and take over control.
Being security focused this translates into my person preferences.

In the end a full system rebuild takes me between 1.5-2 hours average including patches & configuring things plus transferring data where applicable. (Talking SSD. SATA takes more time indeed)
e.g. if I buy HP, Dell, Lenovo OEM I would first need to upgrade to Creator update, then remove optional SW, Trials, Games and more.
That update process itself takes me as long as simply having the ISO already and doing it from scratch.
That was where my point of view comes from :)
1
UpdateGood morning, EE!

Today is the release of macOS High Sierra, the OS that many of us Apple geeks want on our Macs as of yesterday. It will be available for download at 1 PM EST, so make sure that you have your ducks in order before you make the switch.

Here is a short list of things to consider before upgrading:

1) Update your antivirus application and perform a full scan. What? Your Mac doesn't have an antivirus? Well, then you might be carrying malware with you to the new OS. Even if your Mac hasn't been showing the classic signs of being infected, you might be smuggling Windows viruses into your new operating system. (No, Windows viruses don't infect Macintosh computers, but that's no reason to keep them around.)

Side note: It's important to know that malware is growing for Mac with no end in sight. While some purists believe that it's still fine to run Macs without antivirus, there are more of us security guys/gals sounding the alarm that times have changed and Macs are no longer impervious. Lastly, if you use your Mac for any business related functions, you're more likely than not sharing documents with your colleagues who are using Windows systems. Meaning that you don't want to be the person who hands them a work altering piece of malware.

2) Make a Time Machine backup.

3) Manually move significant folders onto an Ext HDD in case your Time Machine backup fails at some point in the future. This extra step ensures that you're …
4
 
LVL 7

Expert Comment

by:Brian Matis
Happy to say that my upgrade went smoothly last night!
1
Here's a simple security tip: lock your computer when you're away! An unlocked work station leaves you ridiculously vulnerable and it's a simple thing to avoid.  Just get in the habit of hitting Ctrl-Alt-Del and choosing Lock every time you get up (for Windows anyway, adapt as needed for your specific OS choice).

You wouldn't leave your front door wide open when you're not at home, right? Same principle here :-)
0
 
LVL 10

Expert Comment

by:Brandon Lyon
There was a person who used to work here who would prove that point by using unlocked computers to send a random silly email to everyone
2
 
LVL 7

Author Comment

by:Brian Matis
@Brandon: I've also seen people get a browser extension installed that would cause Guy Fieri to start showing up on webpages they'd visit. (Note: I don't really endorse these sorts of shenanigans—it can be easy to accidentally take it too far and inadvertently do something actually malicious—but I will admit to getting a good chuckle out of them.)
1
Here is a tip for faster linux software updates: make sure your software sources mirror lists are ranked and optimized. The link below explains how to do that with Arch based distros like Manjaro.

https://wiki.manjaro.org/index.php?title=Pacman_Tips#Ranking_mirrors
0
Good to know - The upcoming Windows update, Redstone 3, will patch the vulnerability that enables EternalBlue exploits. Not all SMB version are that vulnerable as compared to SMBv1.
Microsoft doesn't recommend disabling SMBv2 or SMBv3 for Windows client and server operating systems. Disabling SMBv3 will deactivate encryption that provides protection from eavesdropping on untrustworthy networks. Organizations should proceed with caution when disabling either protocol as a temporary troubleshooting measure.
http://searchsecurity.techtarget.com/answer/Stopping-EternalBlue-Can-the-next-Windows-10-update-help?
0
SysAdmin Day is this Friday! If you have a story of a time when your technical skill and expertise saved the day comment here. You can also message us!

Looking forward to reading more of your experiences!
3
A recent post by Brian Matis motivated me to make this alternate post to see what sort of reaction others might have about these recent revelations.

A recent article on The Verge claims that "The older operating system was less vulnerable that anyone expected"

Windows XP computers were mostly immune to WannaCry

Another article from the same source claims "Windows XP was ‘insignificant,’ researchers say" with regards to helping the WannaCry outbreak spread.

"Almost all WannaCry victims were running Windows 7"

Lots of folks (from their perspective) with a genuine need to keep running on Windows XP suffered a lot of grief in Tech forums as being one of the root causes of giving WannaCry a platform to spread and thrive from, yet now it appears all the criticism may have been a little premature and unjustified.

For the record, I personally don't condone anyone using unsupported operating systems and actively encourage everyone I deal with to get themselves up to date, but I am also sympathetic to those who feel they have a genuine need to do that, so also think they shouldn't be …
0
 
LVL 30

Expert Comment

by:Thomas Zucker-Scharff
We have too many XP computers at my institution (some with only SP2) - mostly due to budgets and instrumentation.
0
 
LVL 12

Author Comment

by:Andrew Leniart
Hi Thomas,
Have you considered purchasing an XP Updates agreement with Microsoft? Might be an easier solution if budget restraints prevent you from upgrading? I wouldn't feel comfortable with a lot of XP machines in an environment as it would be a case of when, not if, it will come back to bite you.  Patches are available, just at a cost.

Incidentally, SP3 for XP is still provided by Microsoft - why not install it?

Steps to take before you install Windows XP Service Pack 3

How to obtain Windows XP Service Pack 3 (SP3)

Cheers..
0
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

We are invested in giving our community the opportunity to continue their education! May's Course of the Month is available for 13 more days. Premium Members, Team Account members, and Qualified Experts can enroll the CompTIA A+ course until May 31st for free and have 30 days to complete the course. Get started today!

https://www.experts-exchange.com/courses/1001/CompTIA-A-220-901-220-902.html?cid=Social_OnsiteEE_PostCourseOfTheMonth_May_19
7
Using 2003 or XP?  Something older?  I have little sympathy for you.  Things get old.  Software is constantly evolving and those creating it utilize new features and capabilities that (in theory) bring you more capabilities and ease of use.  It's impossible for any software developer to support everything they've ever created indefinitely.  Their abilities to continue innovating would grind to a halt.  Even for the largest of companies, like Microsoft.  They MUST cut off support at some point.  Microsoft has, it would seem, set this standard to 10 years.  Given how long that is and the advancements that can be done in 10 years, in my opinion, that is reasonable.  XP and Server 2003 are now 14+ years old.  WELL BEYOND their support life.  

Now I'm confident Microsoft doesn't actively seek to "break" their newer products ability to connect to the older, now unsupported ones, but I would say it's reasonable to EXPECT they no longer test and see if a Windows 10 computer can connect to a 2003 domain.  They MAY, at points, decide to remove functionality from 10 but I'm confident they do so to improve security.  And if that aspect that is removed happens to be the "main" way something was done in an older version that is no longer supported? Well, they warned you!

Ten years is a reasonable time frame.  If you're using what is now antiquated technology, I have little sympathy.

"Fine Lee, but what about me - I use a program that controls a device that requires it run on …
3
 
LVL 58

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
I suppose in the end that what it boils down to is whether you consider safety a function of software or not.  I would say not.  

 But if you do, the problem is in measuring how safe it is and I don't think you ever can.   You can throw a battery of tests at it, but what's safe today may not be safe tomorrow.

 On the flip side, upgrading is no guarantee of being safe either.   To use your car analogy, if my new vehicle uses a Takata air big, then I'm not very safe am I despite that I now have an air bag.  

 So do I use "safety" as a measure in the decision to upgrade or not?   I don't see how you can.

 One could even make the argument in general that by upgrading into a situation with more complexity then what I currently have, I will probably be less safe than I am now (more complexity = more potential holes).    So in regards to safety, not upgrading may be a better choice.    Sometimes, the Devil you know is better than the one you don't.  

 To wrap this up,  I don't think there are any simple answers here of course, but I don't hold it against people for not wanting to upgrade.  I also don't think software vendors should sunset support for products they release.    If someone calls me on something I wrote 15 years ago, I'm not going to say "sorry, can't support that" just because it's old and they decided to keep it.
0
 
LVL 96

Author Comment

by:Lee W, MVP
Funny, as I was formulating my response to you yesterday, I was going to include a reference to the Takata airbag thing - any time you add new capabilities, you get more complicated and though overall safety can improve, it can also, in some circumstances, become less safe.  I believe there is a net benefit (both with airbags and with new software's increasing complexity).

I guess it depends on how you value things.  To me, safety (security) is extremely important.  And I think most people should feel that way.  As such, people need to take responsibility for their continued existence and accept how technology generally (and technology companies) generally work and the economics attached to it.
0
ransomwareEmail2.png Friday, May 12th, a new Ransomware threat named WannaCry came onto the scene, affecting organizations in over 150 countries. Damage includes more than 200,000 people infected with the malware and roughly $28,463 paid in bitcoin to decrypt files. That number may only rise unless companies act to mitigate the threat.
Though WannaCry wasn’t a targeted attack on any particular company, institutions using Microsoft operating systems no longer supported by Microsoft security updates found themselves affected by the fast-moving malware.
For a more in-depth look at this attack, check out the following resources:
1. Learn how to prevent this threat without paying a dime.
2. Explore ways to plan ahead and prevent against possible future ransomware attacks.
3. Mitigate damage with these tips if your organization has been affected, and more.
6
While we're all running around getting things patched and making sure our clients know how to keep from getting ransomware, let's also take a minute to disable SMBv1 as well. Patching will help this time, but you *know* someone is going to try to find another huge hole in SMBv1 to exploit. No Windows OS after Windows XP uses SMBv1, but MS had to include it in their newer OSes for compatibility. All the OSes that only use SMBv1 have been EOL for years. Let's just get future SMBv1 exploits off the table now, shall we?

https://blogs.technet.microsoft.com/filecab/2016/09/16/stop-using-smb1/
7
What have we learnt today about the WannaCry ransomware attack, what you should do.

1. do not block the URL KILLSWITCH - This will stop the spread in your network.

2. Make sure your Anti-Virus Definitions are up to date. 30% of Vendors had definitions updated by end of play Friday 15th May. This will stop trojan exeuting.

3. Patch Risky OS first e.g. Windows 2003 and XP, there are PATCHES available! - This will stop the payload exploit getting into the server.

4. Patch Windows 7, 8, 10, 2008, 2012 and 2016.  Check for a Security Rollup since March 2017.
5
2
10
5
 
LVL 14

Author Comment

by:Justin Pierce, CEH
Great Scott!

Alright, that was an 80's interjection but I still used it right through the 90's (I'm a geek, so give me a break).  ;)

I do remember the Zip Drive (one is lurking somewhere in my attic).

Touching upon your story, that's pretty awesome! Finding Mac malware back then would have been like finding a golden Easter egg containing Willy Wonka's golden ticket (I know it was a candy bar and not an Easter egg, lol), or the ever elusive star on the Native American's bow and arrow on the Tootsie Pop wrapping. Remember when you could turn those in for another Tootsie Pop?

During your travels did you happen to run into an old TRS-80? Besides the Apple II, I loved/hated that old monchrome beast.

All of this said, you make a good point in that malware for Macs has always been around (albeit in smaller numbers).

Now I have Huey Lewis & The News stuck in my head. Thanks Brian! Lol. Hip to be Square!
1
 
LVL 17

Expert Comment

by:Kyle Santos
thisisfine.png
3

Operating Systems

34K

Solutions

36K

Contributors

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.