ailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other
Thank you Dennis...
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent:
Dear Gurus ,
I want to take a certification and I wonder
if brainbench and brainbuzz certifications will help me in my job search.
Are these really as valuable as to write to the CV.
Do you recommend them ?
Why I prefer these exams is cheaper price
..
Bunyamin K
I have 5 DBWR processes according to INIT.ORA on NT .. I see them on
V$SESSION but There is only one process ORACLE.EXE in the processes list of
NT still.
I do not understand the behaviour of ORacle on NT neither the Oracle I
think.
Bunyamin K. Karadeniz
Oracle DBA / Developer
Thank you Sergey ..
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
ured for 11000
times
"direct path write" occured for 6000
times
Are these values normal ? Will I try to make them 0
in the tomarrows report ?
How can I comment on the report ? Is there a link
you can tell me to understand the problems and will help me to read and action
about the probl
I have an idea ..
PGA = UGA(user_session_data + cursor state)+stack space
So Will it be enough or do I have to add sort_area_size to the value below?
select * FROM v$SESSTAT a ,v$STATNAME b WHERE a.statistic#=b.statistic#
and name like 'session pga memory' ;
Bunyamin K.
Title: executing a stored procedure at a certain time
I do it in this way ..
Firstly ,
dbms_job.submit giving the interval
..
then
dbms_job.next_date ...
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara
thank you all...
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree of normality in a database
is inversely proportional to that of its DBA.
- Original
, PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it
so big ? I know that it is because of SWAP . But I am sure that there must
not be swap since I have 8 GB ram and only 40 users use database for now. .
.
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT
Tried and does not work ..
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535
3357729
The degree of normality in a database is inversely proportional to that
of its
it impossible
to execute DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB , It did not
work too.
How can I do this?
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 53
stored procs ,functions are unavailable ..
Wonder if it has now..
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree of normality in a database
is inversely
SELECT
s.segment_name,s.segment_type,s.freelists,w.wait_time,w.seconds_in_wait,w.state
FROM dba_segments s , V$session_wait w WHERE s.header_file=w.p1 AND
s.header_block=w.p2;
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir
Dear Gurus,
SHARED_POOL_RESERVED_SIZE is for big database objects
(procedure,function,package) as far as I know.
I want to configure my database for pinning codes greater than 500K to
reserved pool , smallers to shared pool .
How Can I do that ?
Thank you
Bunyamin K.
Karadeniz
I have tried and entered to metalink too.
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree of normality in a database
is inversely proportional to that of its
lect
sys_context('userenv', 'client_info') from dual;
SYS_CONTEXT('USERENV','CLIENT_INFO')----REAL_USER_NAME
Hope this helps
Paul -Original Message-Fro
my mind
Any idea please ...
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535
3357729
The degree of normality in a database is
inversely proportional to that
We are searching about which unix is best ?
We will apply 9ias and 8.1.7 DB . plus Oracle
Portal.
Can you direct me to a link for comparison about
SOLARIS , AIX , HP-UX for performance and other options ..
Thank you ...
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian
Title: Message
Yes I am running 8.1.7.3 .. Is this a bug ?
What will I do then?
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535
3357729
The degree of normality
ytes=1, =0
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535
3357729
The degree of normality in a database is inversely proportional to that
of its DBA.
dbainblk.gif
D
I had taken the same error sometime ago and droped and recreated password
file .that is a solution 1 . Try logging as internal and change the password
of sys . then try again .
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
I tried What you said . but still no rows returns from dba_audit_trail
although failed login attempts occured.
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree
better..
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535
3357729
The degree of normality in a database is inversely proportional to that
of its DBA.
dbainblk.gif
log
mode parameters in the new init.ora file and created the control file
with these options: SET , RESETLOGS and NOARCHIVEMODE
Then every thing was ok . And then changed the new
db to archive llog mode.
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT
thank you ...
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree of normality in a database
is inversely proportional to that of its DBA
DATABASE "TEST2" RESETLOGS ARCHIVELOG
HTH
John
-Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent:
12 March 2002 11:48To: Multiple recipients of list
ORACLE-LSubject: problem in creating control
file?
I try t
ile 1 needs more recovery to be consistentORA-01110: data
file 1: 'D:\YEDEK123\SYSTEM01.DBF'SVRMGR>
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 /
am encountering the error
below.
CREATE CONTROLFILE DATABASE "TEST2" RESETLOGS
ARCHIVELOG*ORA-01503: CREATE CONTROLFILE failedORA-01161: database
name TESTDB in file header does not match given name of TEST2ORA-01110:
data file 1: 'D:\yedek123\SYSTEM01.DBF'
TESTDB is
Dear Gurus,
I am always making RBS and TEMP tablespaces set as Autoextensible=false.
Is it true ? or logical?
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535
This package(DBMS_SPACE_ADMIN ) does not allow changing dict. managed TS to
Locally managed ts.
It allows reverse.
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The
-
From:
Bunyamin K. Karadeniz
To: Multiple
recipients of list ORACLE-L
Sent: Monday, March 04, 2002 3:33
AM
Subject: replication question
Dear Gurus,
The clients will enter records to a database
all day and I will update the other database .
I
Dear Gurus,
I have made 10 tables as snapshots . And I want to
refresh them for specific intervals.
How can I do that ;
I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but
could not succeed .
How is it done ?
Bunyamin
Dear Gurus,
The clients will enter records to a database all
day and I will update the other database .
I need to replicate 10 tables in a database to
other database at a specific time.
Do I need Advanced replication or basic
replication . ?
How can I understand that replication is suppo
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the
I have oracle ent. edition on my machine (NT) but
do not have the link of adv. replication manager in start panel .
What is the name of exe starting the Replication
manager ?
thank you
bunyamin
want to take advice from these people if there
are.
Thank you ..
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 /
1217
--
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed fr
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bunya
---
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from
Title: Frequency of Analyze
It is due to your data change. If small number
of of data change occurs you may need to do it monthly . But
I have read somewhere that Analyze is recommended
for every week for oltp databases.
Bunyamin
- Original Message -
From:
Arslan
Da
dedicated session.
At peak time, our call rate is 25 user calls
per minute.
Hope this helps,
Paul
- Original Message -
From:
Bunyamin K. Karadeniz
To: Multiple
recipients of list ORACLE-L
Sent: Friday, February 08, 2002 11:08
AM
S
same time ) clients ?
> If yes , What is your DB Server OS ? DB Server RAM and CPU count?
> Are you using Parallel Server for load balancing or Do I need it for
> 1000 active users?
>
> Thank you So much ?
> Any idea will be very good for me?
>
> Bunyamin K. Karadeniz
?
Any idea will be very good for me?
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 /
1217
My question is
DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ON NT ?
I WILL TRY Multi Threaded Server BUT STILL I HAVE DOUBTS ? DO YOU HAVE LINKS
TO ADVICE ME TO READ ABOUT THIS POINT ? ( HIGH CONNECTION/TRANSACTION NUMBER
PER SECOND)
THANK YOU
Shibu ,
IF you type LSNRCTL HELP
YOU WILL SEE THE SET OPTION
THEN TYPE
HELP SET
you will see the log_status action ..
type show log_status . and be sure that
it is ON. Then try to make it OFF with the SET command ...
Bunyamin
- Original Message -
From:
[EM
that ?
Do you have links for me to read for a typical big
application ?
Thank you so much
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 /
1217
Jay ,
You need a java class loaded into database Which
runs OS Commands (or .bat file) . For this look at below... ...
Hope this helps . (But I could not manage to run OS
commands deleting files from network altough shared.But locally it works
fine.)
Bunyamin K.
Karadeniz
end the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joan Hsieh
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, Cali
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mai
My first question is , I need a database
where 1000 clients will work .Which is better ?
Dedicated Server Mode or Shared Server Mode
?
RAM : 8 GB
CPU : 8 * 1000 MHZ
WIN 2K
My second question is , I can not select more then
600 mb of RAM to be the buffer cache . How can I solve this?
Th
Again, it's interesting, what's been changed in
9i. Check the account used to run Oracle service.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Bunyamin K. Karadeniz
To: Multiple
recipients of list ORACLE-L
Sent: Thurs
OS : WINNT , DB : 8.1.7
I have a java class embedded in database and I am
calling it with a procedure.
The procedere executes a bat file .
In the bat file there 2 copy commands . First of
them copying a file from a local directory to another local directory.
Second command copy's a file
HAS anyone tried advanced security and tcp_ip with SSL?
We will make a project which will be on web. So we are searching for security
implementations.
What will we design for to stop hackers?
Database Now 8.1.7 but may be 9i if needed.
OS : WIN2K Advanced Server.
Can you direct me to sour
I have seen that There are some number of
chained rows in several tables of a schema in my database .
What is it done in such a situation ?
Thank you
Bunyamin
Regards
Lee
-Original Message-----From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent:
08 January 2002 09:55To: Multiple recipients of list
ORACLE-LSubject: URGENT , ORA-00600 WHEN DROPING A
PACKAGE
What can I do ? Urgent
please
SQL> drop
What can I do ? Urgent
please
SQL> drop package
wwsso_home; drop package wwsso_home*ERROR at line
1:ORA-00600: internal error code, arguments: [16201], [], [], [], [], [],
[], []
SQL> drop package body
wwsso_home; drop package body wwsso_home*ERROR at line
1:ORA-00600: interna
I have a trace file generated by the database. At the end of
the file you will see an error of
Session 10 exceeded soft sessionspace limit of 0x10 bytes.
What is this ? How can I handle that if needed ?
Thank you
bunyamin
Dump file G:\orafiles\uybs3\tracefiles\udump\ORA01216.TRC
Fri Ja
Ok . You are right .
Thank you.
bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, January 07, 2002 12:15 PM
> > "Bunyamin K. Karadeniz" wrote:
> >
> > Hi DBA's
> > The number of m
Hi DBA's
The number of max roles is 150 according to
init.ora . Is it possible to increase it ?
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 /
1681
1) %50 DBA , %50 Developer
2) Yes
5) all , Java and xml are more.
6) XML, VB
7) Yes , but I did not too.
8) Yes,OCP
9) Learning oracle will be enough to fill your all
time.
10) This email list
11) I am interested in the answer of this question
too.
12) I am interested in the answer of this qu
Does anybody know any websites of
Germany or England related with Oracle jobs ?
=1&p_showHelp=0
>
> NOTE: 109095.1
>
>
> > "Bunyamin K. Karadeniz" wrote:
> >
> > I want to write a procedure to run os commands . I have read somewhere
that
> > I must :
> > Compile the java program.
> > Load it to the DB using LOADJAVA.
I want to write a procedure to run os commands . I
have read somewhere that
I must :Compile the java program. Load it
to the DB using LOADJAVA. Create a function call spec to call the program.
Turn serveroutput and java output ON.
Question 1) What is loadjava? how is it used ?
Dear Gurus , I have a problem.
I have 2 databases on an win2000 machine and want
to create the third .
When I try to create a database with Database Conf.
Assistant , it creates the service and before creating datafiles it gives
error ORA-12545 and does not create datafiles although I ignore
ssage BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bunyamin K. Karadeniz
For me too..
- Original Message -
From:
Stephen Andert
To: Multiple recipients of list ORACLE-L
Sent: Monday, November 12, 2001 10:15
PM
Subject: Re: Oracle related docs/OCP
materials
Boy, this was sure a disappointment.
No white papers that I could fi
I WANT TO CREATE a dynamic trigger where
inside;
:new.column_name occurs and column_name
changes in a loop .
DECLARE
cursor c1 is select column_name from
arsiv.logged_columns where table_name = 'K_IMID_KURUM' ;kolon
c1%rowtype;
BEGINFOR kolon IN c1
LOOPye := :new.||kolon.column_name;
..
we are experiencing ora-03116 error (invalid
buffer length)
How can we solve this . ? Urgent please .
Thank you . Any Ýdea please ?
bunyamin
I can set a procedure to a block in Forms 6i . But
can not do it to a procedure in a package . IS IT POSSIBLE?
Thanks .
bunyamin
I have succesfully installed oracle 8.0.5 on LINUX
redhat 7.1 BUT
when I want to run sqlplus or lsnrctl it gives
SEGMENTATION FAULT error.
and creates core dump files.
Why does this occur? Has anyone experienced this
before ?
HOw doyou read the explain plan outout ? I format
it with a script and still do not know how to read it . Which line I must read
first?The output of my explain plan is below and how do you read this
output pleASE?
OPERATION
OPTIONS
OBJ
in the city of god there will be a great thunder, two brothers torn apart
by
chaos, while the fortress endures, the great leader will succumb" , "the
third big war will begin when the big city is burning"
nostradamus 1654
Sent by one of my friend . I hope this will not be true. For this
I HOPE BEST WISHES FOR ALL PEOPLE IN AMERICA .
WE TURKISH PEOPLE ARE ALL SORRY AND HOPE YOU
HEALTH.
BUNYAMIN
ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bunyamin K. Karadeniz
INET: [EMAIL PROTECTED]
Fat City Netwo
s mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other inf
I try to install oracle 805 on linux mandarake 7
but .
When installing the selected products it
gives the error below.
error : command : make -f ins_rdbms.mk
/u01/./rdbms/lib/psoliblist
sh : command not found
why can it be ?
Thank you
When I try to setup oracle on Linux Mandrake 7 , I
encounter an error.
When I try to run /mnt/cdrom/orainst/oratab.sh it
gives error GROUPS :readonly variable. Why can that be?
I run the script as the root user.
Bunyamin
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http:/
Y, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bunyamin K. Karadeniz
INET: [EMAIL P
My unix knowledge is low and I want to develop it .
But I search for a tutorial for Oracle People especially DBA's.
IS there a source on web including the directory
structure, oratab or other things to administer a database on Unix system
?
I' ll be so happy for your helps
.
Thank you
: INDEXLEME ONEMLI
Nope, I still don't understand it, even the second
time around. Like the Databored Administrator bit though
!!!
-Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent:
03 September 2001 09:20To: Multiple recipients of
Arkadaþlar ,
Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi
fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen
yazýn. Bu alanlarda index yaratýlacaktýr.
Form da blok propertilerinde order by yaparsanýz
onu da yazýn .
Bunyamin
Your Databored
Administrator
Arkadaþlar ,
Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi
fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen
yazýn. Bu alanlarda index yaratýlacaktýr.
Form da blok propertilerinde order by yaparsanýz
onu da yazýn .
Bunyamin
Your Databored
Administrator
Title: RE: tab ascii value
This script prints the ascii table
whole.
May be usefull.
Bunyamin
set serveroutput on size 10240
declare
i number;
j number;
k number;
begin
for i in 2..15 loop
for j in 1..16 loop
k:=i*16+j;
dbms_output.put((to_char(k,'000'))||':'||chr(k)||' ');
if k
d be all
set.
Good
Luck!
Tom Mercadante Oracle Certified Professional
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 28, 2001
3:45 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: creating the datab
Ok Thomas ,
thank you but another question rises here for me.
The drive of
soucedb is E but my targetdb will be on D drive. How will I manager that
?
And in
the control file backup , there is "reuse" keyword . will I neglect it?
Thank you
Bunyamin
I have a 8.1.6 database on NT on one machine . And
I want to create this database to another machine where oracle is installed but
there is no database. I have the back up of datafiles,control files and
redo log files and archieve files.
Can you tell What I will do step by step ? Is
ther
omacticly create your listener services.
"Bunyamin K. Karadeniz" wrote:
OS: NT 4.0 I need to delete the TNS Listener service . and
create a new one .How can I do that ? TIABunyamin
I am getting the below error where I run STAT
or STOP command of LSNRCTL on 8.1.7 on NT. Content of listener.ora is also
below.
Why is that ?
Note : I can remotely connect to this database from
client.
Connecting to
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))TNS-12541: TNS:no
listener TNS-125
OS: NT 4.0
I need to delete the TNS Listener service . and
create a new one .
How can I do that ?
TIA
Bunyamin
ww.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> --
I want to insert into a table and open a pdf and
word document. here is the table create script . And I do a FORM and
assign the blob field as OLE Conteiner and the problems start. And I can
not do that .
How do you do that ? Any idea please? Anyone
did something like this
Thank yo
de a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
no email comes from list to me?
Why can it be?
Bunyamin
I want to update referencing tables when the master
table is updated.
Does it have an easy way as in on delete
cascade or do I need to Write code?
Bunyamin
L PROTECTED]>
> Sent: Wednesday, August 08, 2001 8:45 PM
>
>
> >
> >
> > Because you are running this in the AT scheduler, it is not executing
> > with the same permissions.
> >
> > I'll bet that your batch script it not on the C: drive.
> >
&g
you sure your batch file runs? Do you create logs? If so, did you
check if log was created?
How
do you know it connects.
I
have similar batch files. They run either way with no
problems.
-Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent
UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bunyamin K. Karadeniz
INET: [EMAIL PRO
Dear Gurus , I have a question , In fact I wonder
if it is a bug of NT .
I want to close and reopen database with a .BAT
file .
When I execute the .bat file directly
it executes correctly . But When I execute it with a schedule with AT command
then it connects but does not close database
1 - 100 of 140 matches
Mail list logo