Hi,
I need somebody here to help me to start my Oracle listener for my
Oracle server was power off this morning. Here, when I run the lsncrtl
start, I get an error message. Please see the following message:
# ./lsnrctl start
LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003
In your listener.ora file add the line logging_listener=off. Otherwise make sure
$ORACLE_HOME/network/log exists and is writable by the Oracle user.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, July 18, 2003 4:10 PM
To: Multiple recipients of
In OH/network/log is there a listener.log file? Who owns it? Who are you
starting the listener as and does that ID have rights to write to the
listener.log?
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 7/18/2003 3:09 PM
Hi,
I need somebody here to help me to start
] On
Behalf Of Goulet, Dick
Sent: Friday, July 18, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: urgent Help!! FYI
In your listener.ora file add the line
logging_listener=off. Otherwise make sure
$ORACLE_HOME/network/log exists and is writable by the Oracle user
Dick,
Before this morning power off, everything is fine with my Oracle server. I think this
might be something related to autostart because my solaris server is
down. But I will try it. Thanks!
Don
Goulet, Dick wrote:
In your listener.ora file add the line logging_listener=off. Otherwise
Dick,
It works now after I change the $ORACLE_HOME/network/log/listener.ora to like
following:
$ls -al listener.log
-rw-rw-rw- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log
But before the parameter is like following:
$ls -al listener.log
-rw-rw-r-- 1 oracle oinstall 1732613 Jul 18
Freeman,
Before I change it, listener.ora property is like the following:
$ls -al listener.ora
-rw-rw-r-- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log
After I change it by the following steps, it works fine.
$chmod 666 listener.ora
lsnrctl start
Now Oracle listener starts up. Thank
:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: urgent Help!! FYI
In your listener.ora file add the line
logging_listener=off. Otherwise make sure
$ORACLE_HOME/network/log exists and is writable by the Oracle user.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i
Issue a
ps -ef|grep tns
Command.
Who owns the process? Root?
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 7/18/2003 4:09 PM
Dick,
It works now after I change the $ORACLE_HOME/network/log/listener.ora to
like following:
$ls -al listener.log
-rw-rw-rw- 1
, February 20, 2003 2:58 AM
Hi Gurus,
I need a urgent help.
I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a
sequence. [ The column name is USERNO ]
This table is quite heavy and the current situation is USERNO have reached
it's maximum value i.e. 9
Hi Gurus,
I need a urgent help.
I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a
sequence. [ The column name is USERNO ]
This table is quite heavy and the current situation is USERNO have reached
it's maximum value i.e. 9.
No more records can be inserted
ALTER TABLE user_details MODIFY (column_name NUMBER);
Regards
Naveen
-Original Message-
Sent: Thursday, February 20, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I need a urgent help.
I have a table e.g. USER_DETAILS with a column NUMBER(9), populated
-Original Message-
Sent: Thursday, February 20, 2003 12:59 PM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I need a urgent help.
I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a
sequence. [ The column name is USERNO ]
This table is quite heavy
i think altering the table will be the only solutionalter the size of
the column to 10 or 11 depending on the requirement.
santosh
-Original Message-
Agrawal
Sent: Thursday, February 20, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I need a urgent help.
I have
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Urgent - Help
ORACLE-L
Hi Gurus,
I need a urgent help.
I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a
sequence. [ The column name is USERNO ]
This table is quite heavy and the current situation is USERNO have
reached
it's maximum value i.e. 9.
No more records can be inserted
Objects are using %TYPE then they will work fine otherwise
in forms, reports u have to change...
Please revert back in case of any confusion.
Cheers,
Ajay Kumar
-Original Message-
Sent: 20 February 2003 08:59
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I need a urgent help.
I have
20, 2003 2:59 AM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I need a urgent help.
I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a
sequence. [ The column name is USERNO ]
This table is quite heavy and the current situation is USERNO have reached
it's maximum value
by: Subject: Urgent help needed, gurus
[EMAIL PROTECTED]
om
I checked it.
The problem is that he has chr(10) (newline) in his data so the output is
truncated.
Using select replace(field,chr(10),'') instead of select field make the
problem go away.
BTW - I also tested doing the replace on numeric fields and it comes out ok.
No need to check if the field
Thanx Guys.
I used a combination of repalce/translate to remove the unwanted
characters.it worked out.
thanx everybody.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: oraora oraora
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
oraora oraora wrote:
Guys,
i want to export table data into a CSV file.
i am using the script below to do the same.
--
set wrap off
set linesize 2000
set feedback off
set pagesize 0
set verify off
set termout off
Oracle 817 on W2k:
SELECT FUNCTION(X) FROM TABLE works fine.
SELECT COUNT (*) FROM
(SELECT FUNCTION(X) FROM TABLE) where the function and the table are the
same as above, takes hours and hours, without any result, and I have to stop
it. There is NO ERROR MESSAGE.
The same story (no result,
What does the session statistics say when you are running the query?
Do an explain plan of both the queries and see the difference. Check the
session statistics for both the queries.
Regards
Naveen
-Original Message-
Sent: Tuesday, December 24, 2002 2:34 PM
To: Multiple recipients of
syntax similar to this.
-Original Message-
From: oraora oraora [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 23, 2002 11:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Migrate table data to CSV file - Urgent help !!!
Guys,
i want to export table data into a CSV file
Guys,
i want to export table data into a CSV file.
i am using the script below to do the same.
--
set wrap off
set linesize 2000
set feedback off
set pagesize 0
set verify off
set termout off
spool ytmpy.sql
prompt prompt
Title: RE: urgent help: replication, shareplex
I suggest you take a peek at the waits for the Shareplex process on the source system. We found that the sp_ordr processes query the source tables via the rowid mined out of the redo stream. Sp_ocap also issues queries as well as perform DML
Hi All,
I needed some help here involving shareplex.
We run two databases (an OLTP type, and a repository type) on the same E10K
domain
which has 8 CPUs and 8GB of RAM, using Hatachi SAN (RAID 5). Shareplex is
being used
to replicate a table from the OLTP type to the repository. The current
recipients of list ORACLE-L (E-mail)
Subject: urgent help: replication, shareplex
Hi All,
I needed some help here involving shareplex.
We run two databases (an OLTP type, and a repository type) on the same
E10K domain
which has 8 CPUs and 8GB of RAM, using Hatachi SAN (RAID 5). Shareplex
Hi,
Has anybody installed Oracle 8i silent installation on sun
Solaris, I am trying to do custom installation on 20 servers in which I do not
want apache and Enterprise manager, but whenever I try to install without these
components it fails.
Can you please let me know how to install the
Hi All,
I've currently been working on loading many external binary files (PDF) intoBLOB column. After some digging, I learn that the SQL*LOADER can be used to load data from external files into table. I also got help from another forummate mentioning to use PL/SQL procedure to do so. Since I have
Hi,
I've worked on loading data into the database. By mistake, I havea typo intable attribute that needs to be fixed.
Please help me how to write an sqlplus to correct my misspelled word or delete the generl_description attribute not the whole table.
Here is an example of my table PART
Part_id
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: URGENT Help on tracking unauthorized login to Oracle
)
Subject: RE: URGENT Help on tracking unauthorized login to Oracle
Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
To
track users who tried and logged into the database :
SQL
audit session;
I
don't know in which section you can find that in the Administrator
Guide.
Rivaldi
-Original Message-From: Mandal, Ashoke
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
The
SQL reference has some information...
http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074
HTH
Tim
-Original Message-From: Behar, Rivaldi
[mailto:[EMAIL PROTECTED
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Hi all,
I have never done this particular activity but by following the clues given
in this
thread AND BY reading the documentation I was able to make this work. The
steps I followed were.
1. change the initializaion
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Hi
everybody,
Finally it worked for me.
Thanks
for all your help.
Ashoke
-Original Message-From: orantdba
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 12, 2002 1:02
PMTo: Multiple recipients
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Hi
Revaldi and Joe (Testa),
I went
through the followingAdministrator's guide.
Oracle8i Administrator's
GuideRelease 2 (8.1.6)Part Number
A76956-01
I could
only see chapter 24 on 'Auditing database Use' and under
Greetings,
We have a database with very sensitive data. Our management wants me to find out the
way to secure this data from unauthorized login and track these users who tried to
login to this database.
Is there any way we can track the unauthorized users, who try to login to an oracle
Administrators guide
chapter on auditing.
joe
Mandal, Ashoke wrote:
Greetings,
We have a database with very sensitive data. Our management wants me to find out the
way to secure this data from unauthorized login and track these users who tried to
login to this database.
Is there any way
Joe,
We referred the auditing option. My understanding is that you can track the oracle
users using database auditing feature once the users are logged into the database.
But my requirement is to track the users who tried to login to the database but could
not login due to wrong password.
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
I have an idea for a poor man's version of what you are looking for. Turn on listener logging to a level high enough where you can see the text of the net traffic. With some creativity or a copy of Sed Awk you'll
I stand by my original statement, look at auditing unsuccessful connections.
joe
Mandal, Ashoke wrote:
Joe,
We referred the auditing option. My understanding is that you can track the oracle
users using database auditing feature once the users are logged into the database.
But my
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Administrators guide.
Chapter on auditing.
Audit session.
Rivaldi
-Original Message-
From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 12:54 PM
To: Multiple recipients of list
Hi,
I'm in the middle of a conversion and something is holding the conversion
program:
v$session_wait:
Enter value for sid: 285
SUBSTR(EVENT,1,20) SUBSTR(P1TEXT,1,30)SUBSTR(P2TEXT,1,20)
--
SUBSTR(P3TEXT,1,30)
Jeroen
it might indicate that your batch program is busy and
doing stuff. the wait event you have mentioned is a
idle wait event. In your next run, i would recommend
that have breakpoints coded in the batch that writes
into a error/log table about status and where the pgm
has reached. also write
Hi All,
I am facing a very different problem.
I am using Oracle as a XA Resouce Manager for Encina.
The Encina applications built using Oracle 8.0.6 are working fine. When we moved
the Oracle version to
Oracle 8.0.6.3 the applications are not able to connect to the database.
It gives the
Hi All,
I am facing a very different problem.
I am using Oracle as a XA Resouce Manager for Encina.
The Encina applications built using Oracle 8.0.6 are working fine. When we moved
the Oracle version to
Oracle 8.0.6.3 the applications are not able to connect to the database.
It gives the
by: Subject: urgent help need please
[EMAIL PROTECTED
all,
our company just installed the virtual private network equipment
(Enterasyss Network), then suddenly peoplesoft application can not login to
the oracle database any more, came back with ora 12203, then I tries tnsping
nothing works either, however I can do sqlplus user/password@tns and it
: Thursday, May 17, 2001 10:56
PM
Subject: RE: How to downgrade database
from 8.1.5 to 8.0.6 - Urgent Help P
The
safest way is to do a full database export, to create a new 8.0.6 database
instance and to import the datain the new database. You have to
see for inter-version specifics
Hello:
Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.
I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5.I have to install 8.0.6.(new one) Then I
Hello DBAs:
Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.
I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5. I have to install 8.0.6.(new one) Then
/password file=p_expimp buffer=1024000 OtherParameters
Djordje
-Original Message-From: Helen rwulfjeq
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 17, 2001 12:16
PMTo: Multiple recipients of list ORACLE-LSubject: How
to downgrade database from 8.1.5 to 8.0.6 - Urgent Help
Please
Export/Import
this was actually mentioned in chapter 3 in the Oracle8i Migration Release
(A76957-01)
Hello:
Please help me on this crisis! What is the steps and safe procedures to
downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon
today.
I have database 8.1.5
Dear Experts
I am using Oracle version 7.3.2.
I want to send the output of Reports thru mail.
From the doc, I came to know that I should install Oracle*Mail.
Where can I get this product ORACLE*MAIL ?
Can I download somewhere ? any links
It is not available in the original CD which is
Title: RE: Urgent - Help needed - Reports
Hi,
Thanks for ur reply.
The printer drivers are installed on the server, is there any specific settings/configuration to be done on report server/builder?
-Original Message-
From: Dasko, Dan [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 16
Title: Urgent - Help needed - Reports
C:\RWCLI60 REPORT=d:\oracle\oas408\report60\test.rdf [EMAIL PROTECTED] server=rep60_mp5main destype=Printer desname=\\RRSRV\RR_Printer,172.17.1.204: schedule=every_1_minute_from_now Jobname=testjob05
When i execute the above statement, i get
Title: Urgent - Help needed - Reports
I
would agree with that, is it a networked PC that is being shared? If
so, then the drivers need to be installed on the
server.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Dasko, DanSent:
Friday
PROTECTED]]
Sent: Tuesday, February 13, 2001 8:02 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Urgent Help me !!!**
You will have to use your last Hot Backup file set and
create a new database (use the alter database backup controlfile to trace
of list ORACLE-L
Subject: Re: !! Urgent HELP (Table Deleted In Production )
Hi Saroj,
If the table data isn't updated too often you can go back to an older
export and import the table. If not, are you in archive log mode? Check
your alert.log file for errors on the system
Dear All,
In one of database the developer had deleted a table and
commited it.
database is in online backup but no export backup or table backup
Please tell me how can I recover the the table .
please guide me the exact detailed ed steps to recover the table .
We have online backup
Saroj
(CAP,CEF)" To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
Saroj.Dash@geca cc:
pital.com Subject: ********Urge
Did you restore the data files from the last hot backup?
Praveen
"Dash, Saroj (CAP,CEF)" wrote:
Dear All,
In one of database the developer had deleted a table and
commited it.
database is in online backup but no export backup or table backup
Please tell me how can I recover the the
You will have to use your last Hot Backup file set and
create a new database (use the alter database backup controlfile to trace
for the create db statement). Then apply all the arch. redo files since
THAT backup, UPTO the point before
the Table was dropped. Then extract the Table data and
Dear Friends
In product databace one of the developer had deleted a table and commited it
,
database is in online backup but no export backup or table backup
Please tell me how can the table be recovered
please guide me the exact detaied steps torecover the table
After getting the reply i
Hi Saroj,
If the table data isn't updated too often you can go back to an older export and import the table. If not, are you in archive log mode? Check your alert.log file for errors on the system datafile and let us know the status of your database to provide an accurate answer.
-Rocky
"Dash,
68 matches
Mail list logo