Solved Error: ORA-12154: TNS:could not resolve the connect identifier specified

Solved Error: ORA-12154: TNS:could not resolve the connect identifier specified

Here I am going to discuss about the specific error”ORA-12154: TNS:could not resolve the connect identifier specified” when user tries to connect to the database from 10g FORMS & REPORTS DEVELOPER.The problem can be solved by doing a little work, in a few steps, as illustrated below. 

After installing the oracle developer suite 10g, I tried to connect to the local database(10g) previously installed on my pc,but I end with the error”ORA12154:TNS:could not resolve the connect identifier specified” and can`t connect to the database,it was because when we install the database 10g a net service name “orcl” is automatically created and is used to connect to database through listener,the listener identifies the specific net service name(connect identifier) and establishes theconnection from where it is initialized, but what happen when we try to connect to database through FORMS & REPORTS DEVELOPER SUITE is the listener cannot identify the net service name(connect identifier),because it is being initialized from and by the FORMS & DEVELOPER SUITE ,To solve the problem and to connect to the database there are two ways

1) To Reconfigure the NET SERVICE NAME from the developer suite 10g.

2) To follow the following steps.

STEP 1

Navigate to the path where you installed database 10g >oracle>product>10.2.0(version)>db_1>network>admin

Eg: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN 

(Note here C:\ is my installation drive) 

There you will find a file named as “tnsnames.ora” copy that file

STEP 2

Navigate to the path where you have installed 10g developer suite>network>admin

Eg: C:\DevSuiteHome_1\NETWORK\ADMIN

and paste the file “tnsnames.ora” 

Then try to connect to the database

Connected

FREE DOWNLOAD DICTIONARY

WordWeb is a one-click English thesaurus and dictionary for Windows that can look up words in almost any program. It works off-line, but can also look up words in web references such as the Wikipedia encyclopedia. Features of the free version include:

Definitions and synonyms Related words 5000 audio pronunciations 65 000 text pronunciations

150 000 root words 120 000 synonym sets Look up words in almost any program

Millions of people from all over the world use this top-rated software.

INSTALL ANY OPERATING SYSTEM VIRTUALLY IN WINDOWS 8 WITHOUT ANY VIRTUALIZATION SOFTWARE

HYPER-V IS A FEATURE OF WINDOWS SERVER EDITIONS AND NOW IT IS INTRODUCED IN WINDOWS 8

Before you start make sure that your machines supports Hardware Server Virtualization and that it has has been enabled in the BIOS

GO TO ->CONTROL PANEL->PROGRAMS->

Once the Programs and Features dialog opens, select the Turn Windows features on or off link on the left hand side.

When the Windows Features open, check the Hyper-V option. Then click Ok.

Windows will now add the Hyper-V binaries to your Windows installation.

To begin, just press the [Windows] key to bring up the Start Screen. Then, type Hyper and press [Enter] when Hyper-V Manager appears

After you launch the Hyper-V Manager, navigate to the Actions pane and select the New | Virtual Machine command. When the first screen of the New Virtual Machine Wizard appears, just click the Finish button

When you see the new virtual machine appear in the Virtual Machines list, right click the name and rename it to something like XP Virtual Machine, then go back to the Actions pane and click the Settings command

When the Settings window appears, you’ll see that there are a multitude of settings that you can configure to customize how your virtual machine will work. For the purposes of this article, I’ll just cover the basic settings that you need to get started with your Windows XP virtual machine.

Because Windows XP is an old operating system, it isn’t compatible with Hyper-V’s network adapter. As such, the first thing that you will need to do is add a legacy network adapter. Select the Legacy Network Adapter item and click the Add button.

When you do, Hyper V will add the Legacy Network Adapter to the Hardware list and immediately take you to that section. Since I already created a virtual switch for my last article, I’ll select the Test 1 Virtual switch from the virtual switch drop down Then, click Apply to save your changes. If you haven’t already set up a Virtual switch for the Network Adapter, you can do so at any time.

Now, move up the Hardware list and select the Memory section. I’m going to specify 1GB of RAM for my XP Virtual Machine. As you can see , I’ve specified 1024 in the Startup RAM text box and left the Enable Dynamic Memory check box unselected. Even though the text box is titled Startup RAM, in the case of the Windows XP operating system, this will be the total amount of available RAM.

In other words, it will essentially be static memory. Being an older operating system, Windows XP is not supported by Hyper-V’s Dynamic Memory feature, so you’ll need to leave that check box unselected. The Memory Weight slider is designed to allow you to prioritize memory usage but it is related to the Dynamic Memory feature and so in the case of Windows XP we’ll just leave it as it is in the middle.

To continue, go ahead and click Apply to save your settings. Then move down to the IDE Controller 0 | Hard Drive section.

When you arrive at the Hard Drive section, as shown, the only thing that you may want to do is increase the size of the hard disk. By default, the hard disk is set to 127GB in size. For this example machine, I want to increase the size of the hard disk to 500GB. To do so, click Edit button.

Installing Windows XP : 

Installing Windows XP in a Hyper-V virtual machine is easy. To begin, insert the Windows XP CD in the drive, go back to the Actions pane in the Hyper-V Manager, scroll down to the virtual machine section and click the Connect command. When you do, you’ll see a virtual machine window that tells you that the machine is turned off. At this point, just click the Start button on the menu bar, as shown 

Click the Start button on the virtual machine window’s toolbar.

You’ll then see the installation begin the Windows XP Setup screen.

Seeing the basic looking Windows XP Setup screen in Windows 8 is quite a stark picture.

Once the installation is complete, you’ll see the Windows XP desktop in a virtual machine in Windows 8, as shown 

TOAD Connection Error:- "ORA-12154 TNS:could not resolve the connect identifier specified" or "ORA-06413: Connection not opened" or "Can't initialize OCI. Error -1" Solved

Tool for Oracle Application Development

Error connecting to database after installing on Windows 64-Bit OS

Problem Description

Any of the following errors can occur when attempting to connect to an Oracle database when installed on a Windows 64-Bit OS:

"ORA-12154: TNS: could not resolve the connect identifier specified."

"ORA-06413: Connection not opened"

"Can't initialize OCI. Error -1"

Cause

 

This could be caused by an Oracle 10g client defect on Windows 64-bit. Oracle 11g is not affected. According to Oracle Metalink, Doc ID 334528, there is a network issue for any application that is installed into a path with a parenthesis using the 10g client on Windows 64-bit.

For example, C:\Program Files(x86)\Quest Software\

Resolution

RESOLUTION 1:

If you are running Oracle 10g please install your Quest application into 'C:\Quest Software' and not 'C:\Program Files (x86)\Quest Software.'

Note: If you are trying to install Toad into 'C:\Program Files\Quest Software', Windows will detect it as a 32-bit Program and install it back to 'C:\Program Files (x86)\Quest Software'

RESOLUTION 2:

If you want to keep your install into C:\Program Files (x86)\ Quest Software, then upgrade your client to Oracle 11g 32-bit as the issue is resolved there.

Note: Toad 10.1 to Toad 11.0.1 does support Windows 64-bit but the Oracle client still must be 32-bit.

source:https://support.quest.com/SolutionDetail.aspx?id=SOL12495

Even after you have done the above things sometimes you will get the below error on WINDOWS 7 & WINDOWS 8 64BIT Pcs.

"Can't initialize OCI. Error -1"

Then do the following things:

Right click on the Toad shortcut -> Go to -> Compatibility Mode -> check the box -> Run this program in compatibility mode for "Windows XP(Service Pack 3) & check the box -> Run this program as administrator.

In most cases problem will be Solved

WINDOWS 8 MOST USEFUL SHORTCUTS

Press (Windows) to enter the tiled Start screen.

(Windows) + M minimizes everything that's showing on the desktop.

(Windows) + E opens Explorer for quick access to folders.

On the Start screen, press (Windows) + D to instantly get to the desktop.

(Windows) + Tab opens a list of currently running programs.

(Windows) + Print Screen takes a screenshot and saves it in a Screenshots folder nested in your Pictures folder. 

To take a screenshot on a Windows 8 tablet, simultaneously press the Windows button and the volume-down button on the tablet chassis.

(Windows) + Q opens a global search menu. Type what you're looking for and where you would like to look.

(Windows) + W opens a search in your system settings to quickly locate and change system properties.

(Windows) + F opens a file and folder search.

(Windows) + Pause opens the system properties page to show you a quick rundown of your specs.

(Windows) + "," (that's the comma sign!) makes all current windows transparent, giving you a peek at the desktop as long as you hold down (Windows).

(Windows) + "." (the period) snaps a window to the right or left side (toggling each time you press ".").

(Windows) + R prompts the Run commanduseful for quickly launching apps and other routines with a command prompt.

(Windows) + X opens the Quick Access Menu, exposing system functionality such as the Command Prompt, Disk Management, File Explorer, Run, and more. It's perfect for people who Start Menu. 

Alternately, you can right-click on the bottom right corner of the screen to spawn the Quick Access Menu.

(Windows) + I opens the settings menu, giving you quick access to the Control Panel, Personalization, and your Power button, among other features.

(Windows) + O locks orientation on devices with an accelerometer.

How To Install DOT NET FRAMEWORK 3.5(including 3.0 & 2.0) from Windows 8 installation Disc or Image

                                                  

Insert Windows 8 DVD in DVD drive and open command prompt with  admin privileges (Means holding the ctrl key when opening CMD or right click on cmd ->run as administrator) and type the following command.

Dism /online /enable-feature /featurename:NetFx3 /All /Source:x:\sources\sxs /LimitAccess

Another method:

If you open CMD.EXE with Administrative Privileges i.e. at elevated level & run the this DISM command dism /online /get-features you will see that from the State that .NET Framework is not part of the Operating System.

So the first thing you need to do is to copy the required package to local machine before you run the command to install .NET Framework. To do that use Windows 8 ISO/DVD/USB Media. You need to copy SXS folder to local machine located at D:\sources\sxs (In this case D: your drive letter on which you have loaded Windows 8 Media)

You can also use the following command to copy this folder locally. xcopy d:\sxs\*.* c:\sxs /s

Once completed, in order to install this feature you can run the following command dism /online /enable-feature /featurename:NetFx3 /All /SourceC:\sxs /LimitAccess  and hit Enter

After completing the installation of .NET Framework 3.5 you can see that the feature is enabled in the Control Panel –> Program and Features

Bingo. Now you can enable .NET Framework feature on Windows 8 without needing of an internet connection.

Driver Robot

With Driver Robot, you never need to worry about installing an incorrect or out-of-date driver - Driver Robot's scan engine and database ensures you always get the latest official driver. Driver Robot's massive database, perfect scan, and guaranteed driver availability means that you only have to press one button to Download All of the correct drivers for your system. Stop doing it the hard way - let Driver Robot update your system automatically.

Perfect scan.
Driver Robot has the industry's best hardware detection. It correctly identifies 100% of all consumer hardware devices. If it's in your computer, Driver Robot can see it. With its perfect hardware scan, Driver Robot ensures you always get the right driver.

Huge database.
The Driver Robot database contains more than 100,000 entries. It's guaranteed to automatically download the latest drivers for your PC. Because it supports such a massive breadth of devices, Driver Robot is the best way to get driver updates for your machine.

Best in class.
The benchmarks are clear: Driver Robot is more accurate, has more drivers, and better download performance than any of its competitors. But don't take our word for it - download it now for yourself. In just 2 minutes, you'll have the most recent driver releases that perfectly match your operating system and hardware.

Driver Robot updates:

• Sound card drivers
• Printer drivers
• Video card drivers
• Motherboard drivers
• Webcam drivers
• Wireless drivers
• Bluetooth drivers
• FireWire drivers
• Ethernet drivers
• Windows XP drivers
• Windows Vista drivers
• USB drivers
• Chipset drivers
• AC97 drivers
• DVD drivers
• Router drivers

PHOTO TO SKETCH SOFTWARE-AKVIS Sketch

AKVIS Sketch converts photos into pencil sketches (black and white or in color) and watercolor paintings. It can also convert a photo into a drawing in charcoal or pastel styles. The program enjoys increasing popularity with professionals and amateurs alike as it comes so close to the work of a human artist. In contrast to standard filters (like the built-in filters in Photoshop or PSP) that offer an approximate sketch, AKVIS Sketch comes very close to the hand-drawn works of a human artist. Getting a similar result with the standard tools would require expertise in image editing and extensive manipulation with layers, masks, brushes and applying filters

iPhone Ripper-Portable Joboshare iPhone Rip v3.0.1.0324

Joboshare iPhone Rip is an amazing handy iPhone rip, manager, transfer tool that can fast rip, copy and transfer your music, movie, photo, ePub, pdf, audiobook, Voice Memo, Camera Roll (iOS 4 above), ringtone, Podcast, TV Show, SMS, Contact, Call List from iPhone to computer with ease. Moreover, Joboshare iPhone Rip is the ideal iPhone manager to transfer music/video to your computer, match your iPhone, iPhone 3G, iPhone 3GS, iPhone 4 contents to iTunes and seamlessly copy files from computer to your iPhone, iPhone 3G, iPhone 3GS, iPhone 4.

Joboshare iPhone Rip now supports the latest iOS 4.3 and iTunes 10.2. With Joboshare iPhone Rip, you can transfer multimedia files in your Computer to iPhone for viewing and playing. Besides music, videos, photos synchronization, you can even treat your iPhone, iPad or iPod touch as a portable hard disk after Joboshare iPhone Rip is installed. 

 

Joboshare iPhone Rip also supports all types of iPhone/iPod/iPad including iPhone, iPhone 3G, iPhone 3GS, iPhone 4, iPod classic, iPod shuffle, iPod shuffle 6G, iPod nano, iPod nano 5G, iPod nano 6G, iPod touch, iPod touch 4, iPad, iPad 2 and so on. Joboshare iPhone Rip transfers music, videos, photos and so on between your iPod and iPhone.

The newest features

• Fully support the latest iTunes 10.2 and iOS 4.3
• Transfer SMS from iPhone to Computer as .txt file
• Transfer Call List from iPhone to Computer as .txt file
• Transfer Contact from iPhone to Computer as .txt and .csv files