Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Last Activity:: Jan 22, 2019 at 8:52 PM

Joined:: Oct 22, 2008

Messages:: 2,656

Likes Received:: 375

Trophy Points:: 1,430

Documents:: 2

Following 1

Sadik

Followers 24

Show All

Home Page:: http://dfitzjarrell.wordpress.com/

Location:: Aurora, CO

zargon

Moderator, from Aurora, CO

Community Moderator Forum Guru

zargon was last seen:: Jan 22, 2019 at 8:52 PM

1. Sparamanga
  Hi Zargon, thanks for your help with my queries I have posted. I have a job where I am flitting between different projects so when i return to using PL/SQL i often need refreshing of my knowledge. I wondered if you would be interested in providing some mentoring which I would pay for to help get me up to speed?
  
  Thanks,
  
  Rob.
  
  Dec 5, 2017
2. Ramji
  Zargon,
  
  I am in Denver now. World is a small place. Maybe we can meet up.
  cheers
  Ramji
  
  Apr 10, 2016
3. NARESH GAMANLAL
  Help me looking for AGIS TE 40 - test scripts
  
  Mar 9, 2016
4. Threexbeta
  Am working with oracle price list for the 1st time and i need assistance with:
  1. how to update my item pricing
  2. how to delete one item which is a duplicate.
  
  Sep 15, 2015
5. zargon
  You need to set up an entry in your tnsnames.ora file that looks like this, presuming the Gateway listener is listening on port 1521:
  
  SQLSERVER =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)
  (HOST = myserver.whatever.com)
  (PORT = 1521)
  )
  (CONNECT_DATA = (SID = SQL_Server))
  (HS=OK)
  )
  
  You should also edit the listener.ora file to remove the localhost reference and put in the actual server name or IP address.
  
  Please stop sending me private messages on this; I don't look for them and it's likely they will not be answered. This is EXACTLY what forum threads are for.
  
  Oct 15, 2013
6. SWankhede
  If connector means dg4odbc , or dg4msql or hsodbc then I am using dg4odbc. Actully I am not aware about connector , can you elaborate what is connector and for what perpose it is use and how it configure.
  please focuse on it and help me to solve this issue.
  
  Oct 15, 2013
7. SWankhede
  Please see my second reply. for following error.
  ORA-28584:heterogeneous apply internal error.
  ORA-02063: Preceding line from SQLSERVER
  
  I want to insert,update,delete record through SQL DEVELOPER and Yes , I have Insatlled oracle gateway , but in that gateway there is no tnsnames.ora only listener.ora is present and it is as follows.
  SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = CLRExtProc)
  (ORACLE_HOME = D:\product\11.2.0\tg_1)
  (PROGRAM = extproc)
  (ENVS = "EXTPROC_DLLS=ONLY:\app\AdminValuD-17\product\11.2.0\dbhome_1\bin\oraclr11.dll")
  )
  (SID_DESC =
  (SID_NAME = SQL_Server)
  (ORACLE_HOME = D:\product\11.2.0\tg_1)
  (PROGRAM = dg4odbc)
  (ENVS = "EXTPROC_DLLS=ONLY:\app\AdminValuD-17\product\11.2.0\dbhome_1\bin\dg4odbc.exe")
  )
  )
  LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  # (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )
  )
  
  ADR_BASE_LISTENER = D:\product\11.2.0\tg_1
  
  Oct 14, 2013
8. SWankhede
  Please see my second reply. for following error.
  ORA-28584:heterogeneous apply internal error.
  ORA-02063: Preceding line from SQLSERVER
  
  I want to insert,update,delete record through SQL DEVELOPER and Yes , I have Insatlled oracle gateway , but in that gateway there is no tnsnames.ora only listener.ora is present and it is as follows.
  SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = CLRExtProc)
  (ORACLE_HOME = D:\product\11.2.0\tg_1)
  (PROGRAM = extproc)
  (ENVS = "EXTPROC_DLLS=ONLY:\app\AdminValuD-17\product\11.2.0\dbhome_1\bin\oraclr11.dll")
  )
  (SID_DESC =
  (SID_NAME = SQL_Server)
  (ORACLE_HOME = D:\product\11.2.0\tg_1)
  (PROGRAM = dg4odbc)
  (ENVS = "EXTPROC_DLLS=ONLY:\app\AdminValuD-17\product\11.2.0\dbhome_1\bin\dg4odbc.exe")
  )
  )
  LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  # (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )
  )
  
  ADR_BASE_LISTENER = D:\product\11.2.0\tg_1
  
  Oct 14, 2013
9. SWankhede
  Actully I am daily online from 10:30 AM to 7:00 PM (India time) how we can communicate to each other to solve following issue. I am facing some problem which was I have post under the title as follows.
  ORA-28584:heterogeneous apply internal error.
  ORA-02063: Preceding line from SQLSERVER (i.e SQLSERVER is my database link name).
  can u focus on it and guide me. and tell me your time when your online I will also try to online on same time.
  Thanks in Advance
  
  Oct 12, 2013
10. SWankhede
  are you online now ? if not,
  on what time you are online ?
  
  Oct 11, 2013
11. ac.arijit
  Hi zargon,
  
  Plz have a look on this thread .. if u got something to offer !!
  http://www.club-oracle.com/forums/thread-problem-while-refactoring-t7378/
  Regards
  Ari
  
  Dec 20, 2012
12. sandip.senmajumder
  Hi all,
  I am one day old baby to this forum.I must say one line "OH GOD YOUR SEA(ORACLE) IS SO GREAT BUT OUR BOAT(ME) IS SO SMALL".......
  
  Jan 28, 2011
Show Ignored Content
Loading...
Loading...
About

Home Page:

http://dfitzjarrell.wordpress.com/

Location:

Aurora, CO

Job Title:

Senior Member Technical Staff

Company:

Delphix

Specialties:

Oracle ACE

I have over 26 years of administration experience with various releases of the Oracle DBMS. I have installed the Oracle software on many platforms, including UNIX, Windows and Linux, and I have experience in proactive monitoring of such installations to ensure potential issues do not become problems. I also have experience conducting database performance tuning and capacity planning procedures for production and test environments. I work well with application and technical operations teams to ensure production SLAs are met and can suggest methods and techniques to improve process flow and improve the overall quality of the production environment. I have also administered Oracle on Windows servers so that environment is familiar to me.

I am knowledgable in the traditional tools for performance tuning – the Oracle Wait Interface, Statspack, event 10046 and 10053 traces, tkprof, explain plan and autotrace – and have used these to great advantage at sites where I have worked to increase throughput and improve the quality of the production system. I have set up scripts to regularly monitor available space and set thresholds to notify DBAs of impending space shortages before they affect the production environment. These scripts generate data which can also used to trend database growth over time, aiding in capacity planning. I am versed in TOAD and OEM. Additionally I am familiar with AWR and ASH reports and how to use them to pinpoint and correct potential problem areas.

I have used RMAN , Streams and Data Guard in Oracle installations to ensure full recoverability and failover capabilities in the event disaster strikes. I have configured a 'cascading' set of DR databases using the primary DR databases as the source, managing the archivelog transfers manually and montoring, through scripts, the health of these secondary DR databases. I have used ASM, ASMM and ASSM to improve performance and manage storage and shared memory.

I am the principal author of "Oracle Exadata Survival Guide" from Apress.

SpecialtiesTuning, backup and recovery, replication, installation and configuration of Oracle databases.

Music, art, science
Interact
Content:

Find all content by zargon

Find all threads by zargon
AIM:

dfitzjarr

Windows Live:

oratune@msn.com

Yahoo! Messenger:

oratune@yahoo.com

Skype:

david.fitzjarrell
Signature

David Fitzjarrell
Loading...

Log in or Sign up

Following 1

Followers 24

zargon

About

Interact

Signature