Oracle 10g On Linux System - ORA 12560 Error On Client Side?

Jan 2, 2011

i have installed oracle 10g on linux system. and i am using xp as a client when i use this

cmd>conn scott/tiger@database at client side i receive ora-12560 error

while my database is up and listener and tnsping also working at server side.

View 3 Replies


ADVERTISEMENT

Express Edition (XE) :: Oracle 11g On Linux Mint - MEMORY_TARGET Not Supported On This System

Feb 5, 2013

I decided to use Oracle 11g XE on Linux Mint. I read this tutorial Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto included the seventh part. However, I did a minor change in the script given. Indeed, since Ubuntu 12.04, a bug appeared. So I use the following script :

cat > /etc/init.d/oracle-shm <<-EOF
#! /bin/sh
# /etc/init.d/oracle-shm
#
#
case "$1" in
start)

[code]...

I already uninstalled and reinstalled Oracle 3-4 times, but nothing else happened. When I want to configure oracle-xe, I have a such message :

Starting Oracle Net Listener...Done
Configuring database...
Database Configuration failed.  Look into /u01/app/oracle/product/11.2.0/xe/config/log for detailsAnd this is the content of the file postDBCreation.log :
begin
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

[code]...

View 3 Replies View Related

Application Express :: How To Protect Oracle Application From Code Edit On Client Side Installation

Sep 12, 2013

We have developed an application for our clients,planning to deploy it in client server soon. we have plans to support the application in future,so we want to restrict the clients from any modifications. By Doubt is, 'build_status=Run only' alone,cannot protect our application from client developers to edit our application,

Because though we install our application as 'Run Only' at the time of installation in client instance,we can still import the original application and change the type to 'Build and Run Application',and run the new application as 'Build and Run'.(which is not supposed to) we want to make sure,if there is any way we can protect our application from modifications after client side installation.  

View 1 Replies View Related

Oracle 11g Client Linux 32 Bit

Nov 18, 2012

share with me a linnk of oracle 11g client on RHEL 5 32 bit due to i search in oracle web site and found only 64 bit URL.....share with me a link of installation guide of this client?

View 4 Replies View Related

Forms :: Run Adobe Acrobat In Client Side Using 10g

May 10, 2010

How i can run adobe acrobat in the client side and maximize it ?

Note: i am using oracle 10g.

View 8 Replies View Related

Security :: Query Regarding Client Side Wallet

Jul 11, 2012

I need few clarifications regarding oracle wallet.

db version: 11.2.0.3.2 (Enterprise Edition)

We have a requirement to run shell scripts calling stored procedures for specific activities, which are run on database server. We do not want to store passwords in shell scripts and decided to use Secure External Password Store for hiding passwords instead of os authentication method. need few clarifications on the below.

1) Currently, we are creating oracle wallet entry on db server and making modifications in sqlnet.ora file accordingly. Is it good to use like this or we should do this only on a client machine?
2) Do we need any licensing to use this option?
3) Any knows issues with using oracle wallet?
4) Can we use orapki for creating oracle wallet instead of mkstore?
5) Any knows issues we face during startup and shutdown of db activities?

View 1 Replies View Related

Client Tools :: Migration From Windows Mssql To Linux Oracle

Dec 10, 2012

Env destination-linux:2.6.18-308.13.1.el5,oracle:10.2.0.1 ,source:windows.mssql v:8.00760

I was try migrate one sample database from mssql "Pubs" using Oracle SQL Developer Tool.

After migraton i've got prefixes in tables like MD_<table_name> but i can not see tables from Pubs only a lot of tables like :

MD_COLUMNS
MD_GROUPS
etc...

View 10 Replies View Related

Sqlplus Is Not Working After Oracle 10g Client Installation On Linux Server

Oct 11, 2012

just now i installed oracle 10.2.0.1 client version in one my linux server. after successfully installation sqlplus is not working .

below are my .profile details.

# Set up the shell variables:
EDITOR=vi
export EDITOR
### Set the umask
umask 022
### Set ulimit

[code].....

View 4 Replies View Related

Installation :: Unable To Install Oracle Database Client On Linux?

Jan 4, 2013

I have installed Oracle virtual box on windows host and have created Oracle Linux virtual machine as guest. I have installed the database server on my host machine but rest of the things(Peoplesoft peopletools etc....) on Oracle Linux guest.Now, I am trying to installed database client on guest machine which is Linux so that I can connect to DB server running on host, but having difficulties in doing so.

, I am following the installation instruction given in the doc docs.oracle.com/cd/E11882_01/install.112/e24322.pdf, but when I finally run command runInstaller.sh doesn't happen anything.Actually, to install other software's I just double clicked the .sh file and it automatically started the installation process on a terminal window but when I clicked runInstaller.sh to install DB client, it didn't do anything.

Also, when I run the same command runInstaller.sh from command line after navigating to the directory where this file is present, It throws me error saying "no command found".By the way, why the steps given in doc are so complex, I wish If I could just double click runInstaller.sh just like others and it start the installation process.

View 22 Replies View Related

Monitoring Script From Client Side (no Access To Server)

Sep 12, 2012

We are on oracle 11.2.0.2 on Solaris 10. I dont have acces to the db server but connect to the db from the client side using sqlplus. though I have dba privilege (at oracle level) but no access to db server at os level. I also dont have access to enterprise manager console where such information is available.

I want to set up monitoring so that I can get a mail when the space falls below some threshold like say tablespace is 90% full. Is it possible to get mail from pl/sql script for example?

View 1 Replies View Related

TNS Protocol 12560 Error?

Aug 7, 2013

I have toad on my machine and it connects to oracle fine using TNS but when I open sqlplus via start, i gives me a TNS Protocol error ORA-12560. Now, when I open up cmd and login like this: sqlplus user/pass@omp1, it logs in, why doesn't it login via the sqlplus program from start menu though?

 Here is my tns file:  JUNCORA=  (DESCRIPTION=    (ADDRESS=      (PROTOCOL=TCP)      (HOST=105.68.14.82)      (PORT=1521)    )    (CONNECT_DATA=      (SID=orcl)    )  )  OMP1=  (DESCRIPTION=    (ADDRESS=      (PROTOCOL=TCP)      (HOST=105.1.12.190)      (PORT=1521)    )    (CONNECT_DATA=      (SID=OMP1)    )  )  OMP2=  (DESCRIPTION=    (ADDRESS=      (PROTOCOL=TCP)      (HOST=105.1.12.193)      (PORT=1521)    )    (CONNECT_DATA=      (SID=OMP2)    )  )   here is the listener file: # listener.ora Network Configuration File: C:appRpatelproduct11.2.0client_1NETWORKADMINlistener.ora# Generated by Oracle configuration tools.  LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = Rpatel-PC)(PORT = 1521))      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )  )  ADR_BASE_LISTENER = C:appRpatel 

I tried to change to host to OMP1 but that did not work either

View 7 Replies View Related

Networking And Gateways :: TNS 12537 - Connection Closed On Client Side

Jan 12, 2011

I am getting below error while tnsping from client

C:Program FilesMicrosoft Visual Studio 9.0VC>tnsping xpcdev

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 12-JAN-2011 21:35:03

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.102)(PORT = 1524))) (C
xpcdev)))
TNS-12537: TNS:connection closed

on server side listener is up also I am able to tnsping without any error.

contents from sqlnet.ora

Quote:NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10i

I am getting below error on listener log file

Quote:12-JAN-2011 10:04:56 * 12546
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied

View 9 Replies View Related

Oracle Error In Linux Fedora

Nov 20, 2006

I get this error when trying to log in to SQLPlus in Oracle

ERROR:

ORA-12516: TNS:listener could not find available handler with matching protocol stack

View 1 Replies View Related

Windows / .NET :: Oracle ODBC Drive In Linux Client To Connect With Mono Application

Aug 6, 2012

I am creating a cross platform database application using Mono. It uses oracle database as back end. I used ODBC drive to connecting database. I can connect to database using this following connection string in my windows machine

Driver={Oracle in OraDb11g_home1};Server=localhost;Uid=system;Pwd=manager

For Linux I uses Linux Oracle OS for Database server. I installed oracle client in my fedora OS. and cofigure the client using net cofiguration assistant tool with oracle client. client connection working OK. Then I try to connect with my mono application using the following connection string

Driver={Oracle ODBD Drive};Server=orcl;Uid=system;Pwd=manager

but the above connection string not worked.I am using Oracle 11g version. Do I need to install any other ODBC driver to access oracle database

View 1 Replies View Related

ORA-12560 Protocol Adapter Error

Nov 15, 2010

I try to mount the database and login as an administrator to open SQLPLUS I get the following error:

C:\>sqlplus
SQL*PLUS release date.... Oracle. ALL rights reserved.
Enter username: system@oracle10 as sysdba
password:.....
ERROR:
ORA-12560: TNS: protocol adapter error

I did as some forums said: oracle_sid=oracle10 & looked in the listener that the SID is written.I made sure that the oracle.exe is running from services but still i continue to have this error.

View 1 Replies View Related

Forms :: 10g - ORA-12560 TNS Protocol Adapter Error?

Jan 3, 2013

While running oracle forms builder 10g,am facing error " ORA-12560: TNS:protocol adapter error ".

View 2 Replies View Related

Server Administration :: ORA-12560 - TNS Protocol Adapter Error

Apr 20, 2011

We installed Oracle 11g on solaris machine but some of the configuration failed.

When verified in tracelog we are finding below error message:

PRCT-1003 : Failed to run "getcrshome" on node "localnode"
at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:423)
at oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:546)
at oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:606)
at oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:347)
at oracle.sysman.assistants.dbca.ui.DBCAWizard.<init>(DBCAWizard.java:452)
[code]....

We then tried to create instance but came up with below error:

ORA-12560: TNS Protocol Adapter Error..We have another database version 10.2.0.3 running on the same server and needs to be continued.

View 3 Replies View Related

Networking And Gateways :: ORA-12560 Protocol Adapter Error

Feb 16, 2010

I am trying to connect via SQLPLUS to the standalone oracle database i have installed details as follows:

Host DT1089.myname.local
Database emrep.myname.local
Instance emrep
In EM database is up and running OK
Tnsnames is located at C:OracleHomesdb10gNETWORKADMIN

[code]...

I try to log on with command line

C:> sqlplus system/***** @ emrep
**** = password for user system

but get the following error:

ORA-12560 Protocol Adapter error

View 7 Replies View Related

TNS-12560 Protocol Adapter Error / Connection Closed

Aug 25, 2010

I'm using Oracle 11. I'm currently having some problem to start my Oracle database after database restore, hence unable to start my SAP application too.

> lsnrctl start
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 25-AUG-2010 23:49:20
Copyright © 1991, 2007, Oracle. All rights reserved.
Starting /oracle/PRD/102_64/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
HPUX Error: 29: Illegal seek

View 3 Replies View Related

Server Administration :: ORA-12560 / TNS / Protocol Adapter Error

Nov 27, 2010

When connecting to Oracle Db as sysdba the following error message occurs.

-bash-3.00$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 27 00:34:55 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/sys as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

View 5 Replies View Related

Networking And Gateways :: ORA-12560 / TNS / Protocol Adapter Error

Jan 9, 2012

I installed local database on my laptop that pc is inside a domain when i remove the network cable and connect using the sid defined in the tnsnames sys/sys@ora10g as sysdba it gives me that errors

ORA-12560: TNS:protocol adapter error

to resolve this problem i should connect like that sys/sys as sysdba without the sid but i don't want to connect in this way because i have work must be done from home on that local database so i don't want to connect with network sys/sys@ora10g as sysdba and without network sys/sys as sysdba.

i want to be always connect sys/sys@ora10g as sysdba.

View 14 Replies View Related

Networking And Gateways :: Getting ORA-12560 - TNS - Protocol Adapter Error?

Oct 30, 2012

Getting error ORA-12560: TNS:protocol adapter error

My database is PACKS and user ID is PACKS .

Below tnsnames.ora

# tnsnames.ora Network Configuration File: C:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

STOREDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mst009.stc.corp)(PORT = 1521))
(CONNECT_DATA =

[code]...

View 9 Replies View Related

Server Administration :: Create New Database - Error Ora-12560?

Dec 20, 2011

i want to create new database in oracle 10g, i follow following steps.

C:ORACLE_SID=ALI

THEN create passwordfile

orapwd file=orapwdALI.ora password=ali entries=6

then create oracle instance

C:Oradim -new -sid ALI -STARTMODE AUTO

after that i use

SQLPLUS /NOLOG

THEN i write the command to connect to user ali but

CONNECT SYS/ali as sysdba

it display following message.
Error
ORA-1256: TNS: protocol adapter.

i also check the oracle services from "services.msc", where oracle instance is "start".

View 9 Replies View Related

SQL & PL/SQL :: Printing Tables Side By Side

Mar 8, 2012

Here i am displaying the multiplication tables by given number...the problem is the tables are displaying one after another...i need to print it by side by side like..

1*1=1 2*1=2 3*1=3
` ` `
` ` `
` ` `
1*10=10 2*10=20 3*10=30
....

the written code is

declare
a number:=1;

[Code]....

View 9 Replies View Related

PL/SQL :: Updating 2 Tables Side By Side

Apr 4, 2013

sqlplus experts,

How do I update Table2(idno) with values of Table1(idno)? By the way there are other columns which i do not want to be touched. This is just to create a match parent-child table test data.

Example:

Table1

idno
===
100
101
102
103

Table2

idno
===
any no
any no
any no
any no

I want all idno values in Table2 to be identical with Table1. It can be any order as long as the value is 1 to 1. I just want it populated for test data purposes.

View 28 Replies View Related

Server Administration :: Unable To Connect To Database / ORA-12560 / TNS / Protocol Adapter Error

Feb 7, 2013

In one machine I have windows xp with Oracle 11.2.0.2 database installed and I am able to connect to the database using both sql developer and sql plus.

In another machine I have windows 7. I installed Oracle client 11.2.0.1, then using Net configuration tool, I installed both listener.ora and tnsnames.ora files.

Now, I want to connect to the database which is installed on windows xp from windows 7 using the oracle client. When I tried to connect, I got the following error :

ERROR:ORA-12560: TNS:protocol adapter error

In order to rectify the above error, I was making sure that ORACLE_HOME AND ORACLE_SID were properly set in the regedit file (under HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE). The ORACLE_HOME was set properly. But I found ORACLE_SID missing. So I added ORACLE_SID environment variable in the registry and re-tried connecting to the database. But I am not able to connect. What else should I do in order to connect?

View 6 Replies View Related

Networking And Gateways :: ORA-12560 - TNS - Protocol Adapter Error In Windows Server 2003

Nov 4, 2010

I installed Oracle 10g (10.1) in Windows Server 2003 and i am able to connect to oracle using using SQL net. But when I tried to connect this using SQL Net from Windows XP, I am getting ORA-12560: TNS:protocol adapter error. But when I tried to connect as SYSDBA user, I am able to login in SQL plus. But for a normal user, not able to log in.

View 1 Replies View Related

Upgrade Server-Side - Oracle DB JVM?

Sep 28, 2012

how to upgrade Oracle SERVER jvm version

View 2 Replies View Related

Client Tools :: What Is Best Pl Sql Editor For Linux OS

Jun 7, 2011

What is the best pl sql editor for Linux OS?

View 10 Replies View Related

Forms :: How To Run Client Side Forms

Apr 13, 2010

Oracle developer suite 10g i am installing 10 developer in server can you explain me how to run client side forms and report web-throw witch address i tel him to client.

View 2 Replies View Related







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