Cannot Connect After Install

Nov 1, 2011

I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files.

tnsnames.ora
CODEXE =
(DESCRIPTION =

[Code]....

View 1 Replies


ADVERTISEMENT

Client Tools :: Able To Connect From SQL-Assistant BUT Unable To Connect From SQL Developer

Jul 7, 2012

I have been troubling with this issue for the last two weeks...tried so much, but could not able to resolve....

sqlplus username/password@IPAddress:port/ServiceName

I am able to connect to DATABASE from SQLAssistant only when I provide string like ABOVE........If I dont mention the SERVICE, m unable to connect to DB.Now the biggest issue is with SQL Developer.....m not at all able to connect to DB using SQL Developer.

View 3 Replies View Related

Client Tools :: Connect Oracle Developer 6i Without Connect String

Aug 17, 2010

I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.

View 1 Replies View Related

Connect Oracle Database From Delphi - Could Not Resolve Connect Identifier Specified

Oct 6, 2010

I have the following computer/setup:

Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)

I cannot can't to the Oracle database from Delphi. The error I keep getting is:

Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.

Here's what I've done:

1. Create an ODBC connection to my Oracle database

- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.

2. Open Delphi and drop a TDatabase component on my main form.

- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".

Alternatively, I tried using the Delphi ADO components (the dbGo components).

- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".

Again the same error.

My questions are:

1. Can Delphi work with Oracle XE (Express Edition)?

2. If so, then do I need to install the "Instant Client"?

3. Will the instant client for Oracle 10g work with Oracle 10g XE?

4. Do I need to install any additional ODBC driver(s)?

5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?

6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?

View 2 Replies View Related

Oracle10g Install On Z/OS

Apr 22, 2011

I am having a rough time trying to install Oacle 10.2.0.3.0 on Z/OS 1.7.

Since my installation does not allow us to use X Windows nor Telnet, I have been forced to try to install using a silent install response file. The install does not seem to get very far and throws out an informational message, but no actual errors. All this is being done via OMVS on USS (UNIX system services).

The message I am getting is:

INFO: INFO: Unable to read the list of homes from the inventory.

I think it may be a permissions issue, and the support people are pursuing this avenue as well, but so far, no concrete answers.

I execute ./runInstaller -silent -responsefile <my responsefile.rsp>

The above INFO message comes out.

The user I am logged in with has the following:

uid=1212 (HPCGBE) gid=101(OINSTALL) groups=102(ORADBA)

One problem is that there is a superuser account called BPXOINIT that is the group owner on some of the directories that I need to access:

uid=0 (BPXOINIT) gid=1(BPXOINIT) groups=101(OINSTALL),102(ORADBA)

View 2 Replies View Related

How To Install Oracle On Linux

Feb 25, 2012

how to install oracle on Linux.

View 2 Replies View Related

Install Oracle 9i In Windows XP

Mar 11, 2004

I wanted to install oracle 9i in windows xp.My configuration is intel celeron,2.5ghz,256 mb ram ,5.5 gb of free hard disk space.I do no anything about the oracle ,was trying to install oracle on redhat 9 but had some problems..I just wanted the step by step documentation of installing oracle 9i in xp.

View 2 Replies View Related

Install And Remove Oracle 10 G

May 26, 2008

I install oracle 10 g but I don't remember password . so I then remove oracle 10 g by select Universal Installer and click Deinstall and then reinstall but I can't reinstall because I don't remove/delete oracle_home I then delete folder in path C:Oracle and reinstall Question

1.in this remove oracle 10 g method true or wrong if wrong , How effect on my computer
2.why after reinstall my computer is very slow.

View 5 Replies View Related

Install OracleASM In CentOS 6?

Apr 19, 2012

Can I install the oracleASM in centOS 6?

My kernel version is 2.6.32.

And the last version for oracleasm release is 2.6.18-308.1.1.el5. [URL] And they aren't compatible...

Are there any way to install these lib with this kernel version? (2.32...)?

View 1 Replies View Related

Windows :: How To Install 10gr2 In Win 7

May 1, 2010

Is it possible to install 10gr2 in windows 7?

View 12 Replies View Related

RAC & Failsafe :: Can Just Install CRS Only If OS Crashed

Aug 3, 2012

we have RAC database on two node here on windows server 2008 unfortunately today morning my one my one node os crash its on windows server 2008 my other node its working ok so my database is accessible so i just want to ask if i install again this os on node -1 system so i just want to install only again crs only.because my database is accessible through my other node-2

View 6 Replies View Related

Windows :: Install Oracle In XP?

Sep 7, 2010

I've dual booting (Ubuntu and xp). I've already installed oracle 9i in xp. And planning to install 10g in Ubuntu soon.

1) How to check the os block size whether it is 32 or 64bit before installing 10g on XP?

2) (eventhough not necessary) is it possible to have 9i and 10g in a same XP platform?

3) Can I change the bit size between 32 and 64 bit while installing a new oracle software?

View 2 Replies View Related

Windows :: Install Oracle 10g In 7?

Nov 1, 2010

I have dell inspiron 15R model N5010 laptop, I have windows 7 64 bit operating system, intel i5 processor, 4 gb ram,500gb hdd. how does install oracle 10g in my system.

View 1 Replies View Related

Installation :: Not Install 100% Oracle 8i

May 2, 2013

Caused our sql 8i not install 100%, while we are using windows 7.

View 2 Replies View Related

XE :: Install Oracle 10g With Different Database

Feb 4, 2013

Oracle database 10g Express Edition...I need to install "Oracle database 10g Express Edition" with different database name example dev but it is taking default name that is XE and there is no option come during installation where i can put the name of database as per my desire.

And also explain why we use "Oracle database 10g Express Edition" instead of Oracle database 10g. what is the meaning of Express Edition.

View 2 Replies View Related

Installation :: Install On SAN Vs Blade?

Aug 21, 2013

, We are doing a fresh setup on new hardware.  On the old hardware Oracle is installed on the SAN and all data files are on there as well.  Our new blades are Dell M620 with 2 mirrored 500GB drives and our SAN is Dell Complaint Storage and Complaint TLS Controller.  The SAN uses hybrid SSD storage so it keeps the most used data cached. 

 I'm feeling it would be best to install the Oracle Server on the SAN.  On top of that we have a single 620GB fusion IO NAND flash card in the mix.  I am still researching the configuration of that.

View 0 Replies View Related

Migrate Install From RHEL4 To RHEL5

Oct 14, 2010

I need to build a new server for my Oracle 10gR2 due to compatibilities with the new storage system that we have purchased, this server will run RHEL5 x64 and will replace a RHEL4 x64. Since doing an upgrade poses greater risk as the upgrade may fail, I am thinking about building a new server with RHEL5 x64 doing all the config/tuning and then simply running the same Oracle installation (after a full backup) which I was running on the RHEL4 x64.

For this to work I will just need to mount the SAN drives on the new server but and this may be a big but, considering that some versions of some libraries will change do I need to relink anything in my Oracle? I have never manually relinked anything but Oracle may have done so during the initial install.

View 7 Replies View Related

Possible To Install Oracle Grid Infrastructure

Jan 11, 2012

I'm trying to install Grid Infrastructure for Oracle RAC 11g. I followed each step of pre installation tasks, but when I run run Installer it blocks without any error message.

What I see on my shell is this:
./runInstaller
Avvio di Oracle Universal Installer in corso...

Verifica dello spazio Temp: deve essere maggiore di 120 MB. Effettivi 17276 MB Superato
Verifica dello spazio di swap: deve essere maggiore di 150 MB. Effettivi 23999 MB Superato
Verifica del monitor: deve essere configurato per visualizzare almeno 256 colori. Effettivo 16777216 Superato
Preparazione per l'avvio di Oracle Universal Installer da /tmp/OraInstall2012-01-11_03-35-57AM. Attendere...[oracle@ssts2cora1 grid]$

Everything seems ok. But the window of oracle installation does not appear. The java process is active:

[oracle@ssts2cora1 grid]$ ps -ef | grep java
oracle 4553 1 0 03:35 pts/0 00:00:00 /tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre/bin/java -Doracle.installer.library_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui/lib/linux -Doracle.installer.oui_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui -Doracle.installer.bootstrap=TRUE -Doracle.installer.startup_location=/home/software_ssts/grid/install -Doracle.installer.jre_loc=/tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre -Doracle.installer.nlsEnabled="TRUE" -Doracle.installer.prereqConfigLoc= -Doracle.installer.unixVersion=2.6.32-100.34.1.el6uek.x86_64 -mx150m -cp
[code]....

but it does nothing!! Nothing appears to me. I attach the log file generated by the installation process.

Using paramFile: /home/software_ssts/grid/install/oraparam.ini

Checking Temp space: must be greater than 120 MB. Actual 17276 MB Passed
Checking swap space: must be greater than 150 MB. Actual 23999 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

The commandline for unzip:

/home/software_ssts/grid/install/unzip -qqqo ../stage/Components/oracle.jdk/1.5.0.17.0/1/DataFiles/\*.jar -d /tmp/OraInstall2012-01-11_03-35-57AM
Verr� utilizzato il valore di umask '022' disponibile in oraparam.ini

Execvp of the child jre : the cmdline is /tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre/bin/java, and the argv is
/tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre/bin/java
-Doracle.installer.library_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui/lib/linux
-Doracle.installer.oui_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui
-Doracle.installer.bootstrap=TRUE
-Doracle.installer.startup_location=/home/software_ssts/grid/install
-Doracle.installer.jre_loc=/tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre
[code].......

View 2 Replies View Related

Windows :: Install Forms And Reports 11g

Nov 1, 2011

Ar you have manual to install oracle forms and reports on windows seven

View 2 Replies View Related

Windows :: Install Oracle R12 On Computer?

Sep 18, 2012

I need steps to install Oracle R12 on my Windows computer.

View 1 Replies View Related

Forms :: Install Oracle 11g Client

Aug 20, 2012

I just installed WEBLOGIC server on linux with oracle forms 11g builder and report builder on the server.

On the client machine , i have probleme to intsall oracle forms 11g , in one of the steps it asks me to enter the absolute location of server weblogic , i enter the location of the weblogic on the server , but it dosent' work. is it mean that i have to install the weblogic on the client machine too!! if not to install forms builder 11g on the client

View 2 Replies View Related

Windows :: Unable To Install Oracle 10g On Win 7

Jan 8, 2011

Is oracle 10g availble for Windows 7, I downloaded oracle 10g from ORACLE'S website. The name of the file is "10203_ vista_ w2k8_ x86_ production_ db.zip" but when I m installing it, I m getting error at the very beginning regarding the system requirements failure.

below is the message which i receive at the PRODUCT-SPECIFIC PREREQUISITE CHECK
======================================
Checking operating system requirements ...

Expected result: One of 5.0,5.1,5.2,6.0
Actual Result: 6.1
Check complete. The overall result of this check is: Failed <<<<
Problem: Oracle Database 10g is not certified on the current operating system.
Recommendation: Make sure you are installing the software on the correct platform.
=======================================================================
[code]....

View 6 Replies View Related

Windows :: Does Win 7 Support Oracle 11g To Install

Nov 16, 2011

that windows7 will support oracle 11g and oracle 10 g

View 1 Replies View Related

Windows :: Install Oracle Database 11g.2?

Aug 6, 2011

I am trying to install oracle database 11g.2 on windows 7. bu I received error in configuration database step.error is attached to this topic. installed database on windows so far.the emca text is below .....

-----
@echo off
setlocal
set OH=E:appproduct11.2.0dbhome
set JRE_JAVA=%OH%jdkjreinjava

[code]...

View 10 Replies View Related

Install RAC Cluster Onto Linux Server

Apr 1, 2011

What I wanted to know was the steps to place a RAC cluster onto a brand new Linux server.

Step 1 - Install Cluster Software , CRS & Voting Disks
Step 2 - VIPCA - VIP Config (VIP, GSD, ONS) Resouce Apps
Step 3 - Create ASM Instance
Step 4 - Install Grid Infrastructure
Step 5 - Install RAC
Step 6 - Create Cluster DB - using DBCA with Enterprise Manager

This will be a 2 node RAC cluster going onto a Redhat 5 Linux box

View 2 Replies View Related

SQL & PL/SQL :: How To Install Excel Document Type

Feb 15, 2013

We are trying to develop one excel sheet from PL/SQL. But the requirement is that we want specific colors and fonts for specific rows and columns. For that purpose, we are using Excel Document Type. But we are getting error that Excel Document Type should be declared.How can we get rid of this error?

View 2 Replies View Related

Install SQL Developer / Set A Path To Java

Oct 16, 2012

i try to install the sql developer, and i need to set a path to java it show: "Enter the full pathname for java.exe"

View 4 Replies View Related

Client Tools :: Can Install Toad In Mac OS

Mar 2, 2010

whether we can install Toad in Mac OS.

View 6 Replies View Related

Installation :: Oracle 11g Client Install

Jul 2, 2012

I rarely do client installs. I have not downloaded upgrades on a couple of years. I have been doing other stuff and oracle supports patching page has changed.

Need to install 11.2 on HP Itanium 64 bit. I can get 11.2.0.1 from otn.oracle.com.

1. I downloaded the 11.2.0.1 client from otn. I want to see if there is an 11.2.0.2 or 11.2.0.3 patch on Oracle support. I can only find upgrades that are specifically for the databsae server. Do I use this? See below for the notes I used so far. Note: Oracle Database Upgrade Path Reference List [ID 730365.1]

Which leads me to the following patch below. However, this download is much larger than the client download on otn. It also says 'database server' and does not break out to 'database client'.So not sure if this is what I use to patch the client or not. This upgrade is also much larger than the straight client download. So not sure if this is what I use to just upgrade the client.

Patch:10404530 Description 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER
Product Oracle Database Family

This upgrade seems to be for the whole database and not just for the client install.

2. Do you apply PSU's to the client? I see them listed for the 'database'. Not sure if you apply to a separate client install.
3. We use the proC pre-compiler. When I look in the instant client download section, I see a seperate section for the proC pre-compiler download. I don't see that for the full blown client. Does the regular client download include the proC pre-compiler?

View 2 Replies View Related

Security :: How To Install Wallet In Oracle 11g

Oct 6, 2012

how to install wallet in Oracle 11g and chek if it is installed? Extra cost is involved for liscencing ?

Does it ask for any option while installing Oracle Software?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved