Any Oracle DBAs here?
- Thread starter tedski
- Start date
I'm taking this class for Oracle Developer and they provided me with disks to install the 10g database and the developer on my PC. Unfortunately, the release they provided is only good for install under Windows 2000 or XP. I tried installing on my work laptop (XP), but the install conflicted with access to some of my main work resources ... so I uninstalled.
My home PC runs Vista, so I downloaded the new release (10.2.0.3) from the Oracle website. This is certified to run under Vista. Then according to the install notes, I had to manually define an ORACLE_HOSTNAME variable in the system environment as well as a loopback adaptor in the network setup. The database install seemed to finish without any problems, but when I attempt to login to the database via SQL*PLUS, I receive the following error:
ORA-12154: TNS : Could not resolve the connect identifier specified
I've rebooted my system after each change, including when the install finished, but still cannot connect to the database. The Post Install instructions advised me to go to the Oracle MetaLink website (metalink.oracle.com) to download the latest patches, but I cannot login as you must be a registered user. So I tried following the new registration process, but I don't have a valid Support Identifier ... so I struck out there.
The remaining install notes require that I connect via SQL*PLUS, but as I cannot connect, I'm basically at an impasse. I've asked the instructor for assistance, but she is not skilled in DBA knowledge.
Any help would be appreciated.
My home PC runs Vista, so I downloaded the new release (10.2.0.3) from the Oracle website. This is certified to run under Vista. Then according to the install notes, I had to manually define an ORACLE_HOSTNAME variable in the system environment as well as a loopback adaptor in the network setup. The database install seemed to finish without any problems, but when I attempt to login to the database via SQL*PLUS, I receive the following error:
ORA-12154: TNS : Could not resolve the connect identifier specified
I've rebooted my system after each change, including when the install finished, but still cannot connect to the database. The Post Install instructions advised me to go to the Oracle MetaLink website (metalink.oracle.com) to download the latest patches, but I cannot login as you must be a registered user. So I tried following the new registration process, but I don't have a valid Support Identifier ... so I struck out there.
The remaining install notes require that I connect via SQL*PLUS, but as I cannot connect, I'm basically at an impasse. I've asked the instructor for assistance, but she is not skilled in DBA knowledge.
Any help would be appreciated.
I had a similar problem not to long ago and followed these steps, even though 10.2.0.3 is supposed to run on vista it did not seem to work until we changed the compatibillity mode, you probably already tried this, I think I found this after googleing the problem, but it worked for me.
Step 1: Disable DEP
Click Start
Click All Programs
Click Accessories
Right Click on Command Prompt
Left click on Run as Administrator
Click the Allow button if it asks you for permission
Type or past the following into the command prompt window:
bcdedit.exe /set {current} nx AlwaysOff
Hit enter and you should see the confirmation: Operation Completed Successfully
Reboot and DEP should be off.
Step 2: Set Windows XP Compatibility Mode
Right-click the setup executable setup.exe and choose Properties from the context menu that appears
Click on the Compatibility tab
Check the [ ] Run this program in compatibility mode for: box and select Windows XP (Service Pack 2)
Check Disable visual themes
Check Disable desktop composition
Check Disable display scaling on high DPI settings
Under privilege level check Run this program as an administrator
Click Apply
Click OK
Note: we had to uninstall and reinstall using these steps for it to work...
Edit - http://www.psoug.org/reference/vista.html
I found the link I found this information at.
Step 1: Disable DEP
Click Start
Click All Programs
Click Accessories
Right Click on Command Prompt
Left click on Run as Administrator
Click the Allow button if it asks you for permission
Type or past the following into the command prompt window:
bcdedit.exe /set {current} nx AlwaysOff
Hit enter and you should see the confirmation: Operation Completed Successfully
Reboot and DEP should be off.
Step 2: Set Windows XP Compatibility Mode
Right-click the setup executable setup.exe and choose Properties from the context menu that appears
Click on the Compatibility tab
Check the [ ] Run this program in compatibility mode for: box and select Windows XP (Service Pack 2)
Check Disable visual themes
Check Disable desktop composition
Check Disable display scaling on high DPI settings
Under privilege level check Run this program as an administrator
Click Apply
Click OK
Note: we had to uninstall and reinstall using these steps for it to work...
Edit - http://www.psoug.org/reference/vista.html
I found the link I found this information at.
It's not our fault everything in our business has really really long names, so we need lot's of acronyms.
I'll help you out....
DBA - Guy in the back room who get's yelled at when someone can't explain why an application does not work.
11G - This is version 11 G. It means they screwewd up a-f, and they were ok with G. This does not mean it does not have bugs, just the bugs are elusive enough that they don't have to take all the blame. And most people will find a work around, before accepting there is a bug.
SQL Server - Direct Competitor to Oracle. SQL Server is by Microsoft, cheaper, and easier to use. Oracle has better commercials though.
Tegu's Insturctions... screw it... I have no idea how to make a joke out of that.
I'll help you out....
DBA - Guy in the back room who get's yelled at when someone can't explain why an application does not work.
11G - This is version 11 G. It means they screwewd up a-f, and they were ok with G. This does not mean it does not have bugs, just the bugs are elusive enough that they don't have to take all the blame. And most people will find a work around, before accepting there is a bug.
SQL Server - Direct Competitor to Oracle. SQL Server is by Microsoft, cheaper, and easier to use. Oracle has better commercials though.
Tegu's Insturctions... screw it... I have no idea how to make a joke out of that.
