Server Administration :: Identify Tnsnames.ora File?
Jun 10, 2011How to find out the database TNSNAMES.ora file if there are multiple .ora files with different names in Oracle_home/network/admin directory ?
View 6 Replies
ADVERTISEMENT
Server Administration :: ORA-01157 / Cannot Identify / Lock Data File 201
Aug 12, 2013Our server got crash in server1 and we recovered the same DB to server2 using RMAN back up. But while running our scheduler for email alert we got the error message as ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201: 'D:ORADATAKFDBTEMP01.DBF' Our temp file is already in E folder.
View 4 Replies View RelatedServer Administration :: Import Data To Production Database - Details Are Not In Tnsnames.ora
May 3, 2011I need to import data to production database. The database details are not in tnsnames.ora.
I am using easy connect method to connect to the database, since I am not able to edit tnsnames.ora.
Is there any way by which I can do the import ?
Can I do it like this
imp system/pwd@imp system/pwd@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1521)))(C
ONNECT_DATA=(SID=xx))' ......................
Server Administration :: ORA-01157 / Cannot Identify Datafile 1
Jun 28, 2010I have a database of branch A whose files are located in E: Drive. I want to download it in branch B.I placed all the files of Branch A in D: Drive of Branch B. When i start the database i was getting controlfle error. I made required corrections in initorcl.ora. Now when i start the Database,its mounted, but I am getting ORA-01157: Cannot identify datafile 1. I tried to rename the file, but the "alter database rename file1 to file2;" option is not working.
View 3 Replies View RelatedServer Administration :: Identify Condition To Rebuild Index
May 27, 2012In which condition it is required to rebuild the index and how can identified it?
View 12 Replies View RelatedServer Administration :: How To Identify Object Residing In Which Datafile In Tablespace
Mar 6, 2011I have create one table emp under scott schema, and this schemas default tablespace is USERS and this tablespace has 3 datafiles.
Now how do I identify the object EMP is residing on which datafile in USERS tablespace?
Server Utilities :: Data Pump Import - How To Identify Dump File Tablespaces
Jul 5, 2012I'm rying to import schema's from a dump file that came from a different environment.
What I have is:
1. dump file
2. log file of the export
I'm trying to import the file(containing three schemas) with remap_schemas, and it fails, gives a lot of ORA-00959: tablespace 'string' does not exist.
Now, I've read in OTN:
[URL]
that what you need to do in that case is to use the REMAP_TABLESPACE option,to redirect the objects to a different tablespace.
I don't see a name of the tablespace I'm getting the error for in the export log.I don't know if I have more tablespaces I have to redirect with REMAP_TABLESPACE.
I don't want to perform this 3 times, have an error, by that find out what's the next tablespace needing redirection and only then starting over...
How can I know from the dump file and the log file,what is the tablespace names i need for the redirection to my names? Or its just that the tablespace giving me the error is the only one in the dump file?
TNSNAMES Sub File Load Possible
Apr 22, 2013Possible to call a tnsnames file from master tnsnames like the principle of ifile in the init.ora...My primary tnsnames.ora has a lot of development entries which are repointed frequently, it would work with logistics if I could manage these in a second tns file and load from primary so when my dev instances are repointed I'm not editing the master tnsnames
View 4 Replies View RelatedAny Reasonable Maximum Size To TNSnames.ORA File?
Dec 28, 2010we have an environment with many Oracle databases in different versions (v8, V9, V10 and V11). Besides that, there are many versions of the Oracle Client in use, ranging from V6 to V11. Many of the clients have a TNSnames.ORA and as was to eb expected, many of these are old as well with a lot of (by now) invalid information in there.
Is there any reasonable maximum size to the TNSnames.ORA file?What are the consequences from going over the max size? Are there alternatives to using TNSnames.ora which you would recommend?
Update Oracle Tnsnames.ora File With Some New Entries?
Oct 5, 2011I need to Update Oracle tnsnames.ora file with the some new entries ....i was looking for ora 92, but could not find a proper link to download.now I have oracle 11 g, but i cant find tnsnames.ora file in that...is it because my installation was not proper...
View 1 Replies View RelatedNetworking And Gateways :: Purpose Of Tnsnames File
Apr 28, 2010what the purpose of tnsnames file does? Does it need to be on the client workstation and what should be it's correct location?
View 2 Replies View RelatedTnsnames.ora File Cannot Handle Connection Information For More Than One Database
Mar 12, 2007I am having problem with my tnsnames.ora file.seems the file cannot handle connection information for more than one DB. It worked fine in the beginning, after that, whenever i had to connect to a DB, i had to keep switching and renaming 5 files, with respect to whichever database I want to connect to. this is the entries in the file, for 2 D's and it wont work, with just one in each it works, but not for two...
newtpt =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp)
(PROTOCOL = TCP)
(HOST = ipadd/virtualname)
(PORT = 1521)
[code]....
I am sure, nothing wrong with teh IP/virtualname, cause with just one of these in the file, they work excellent.I tried leaving line between the connection strings for each DB, without leavin lines, etc..
Tnsnames.ora With 2 Alternative IP Server
Jan 31, 2012Is there a way to put on tnsnames.ora the alternative IP of a server that if the first dont respond it tries the ip of the second? Example:
ORA92 =
(DESCRIPTION =
(ADDRESS_LIST =
try
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))
except
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.2)(PORT = 1521))
end )
(CONNECT_DATA =
(SERVICE_NAME = tsh1.world)
)
)
ORA-01157 - Identify / Lock Data File 255?
Aug 30, 2010I'm using SAP ECC6.0, Oracle 10G, HPUX B11.23.Recently I had performed database restoration from my backup tape. However, during the process of bringing up the Oracle and SAP database, I observed that there could be some archive logs went missing. I had tried to check them from my backup tape, but could not find it.
In short, now my SAP database is up and running, but I'm having another problem when I executed a "CheckDB" job in DB13. The job is unable to complete successfully
DB13 job log:
30.08.2010 19:44:40 Job started
30.08.2010 19:44:40 Step 001 started (program RSDBAJOB, variant &0000000000061, user ID BASIS)
30.08.2010 19:44:40 Execute logical command BRCONNECT On host drqaecc
30.08.2010 19:44:40 Parameters: -u / -jid CHECK20100830194440 -c -f check
[code]...
Server Administration :: ORA-01111 / Name For Data File 636 Is Unknown - Rename To Correct File
Nov 3, 2012i have two tablespaces dictionary managed (SYSTEM,APPLSYSX) i tried to change to locally cause it will cause problem in future when trying to run OATM migration.i did it successfully on APPLSYSX,when i did it on system upon oracle procedure.i have to change all tablespaces to read only when i did that with tablespace APPLSYSD(alter tablespace APPLSYSD read only) i received errors
SQL> alter tablespace APPLSYSD READ ONLY;
alter tablespace APPLSYSD READ ONLY
*
ERROR at line 1:
ORA-01230: cannot make read only - file 636 is offline
ORA-01111: name for data file 636 is unknown - rename to correct file
ORA-01110: data file 636: '/vol5u/oracle/prddb/9.2.0/dbs/MISSING00636'
i have not this file on the OS
Backup & Recovery :: Identify Particular Archive-log File Have Backup Or Not From RMAN Catalog?
May 30, 2012How can be identify a particular archive-log file have backup or not from rman catalog?
View 2 Replies View RelatedData Guard :: ORA-01157 / Cannot Identify / Lock Data File 1
Jul 23, 2010i did everything writen but when i do *SQL>alter database recover managed standby database disconnect from session;*
i go and look in the standby database AlertLog file ,and thats whats writen
*ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:ORACLEPRODUCT10.2.0ORADATADBSYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: غير قادر على فتح الملف
O/S-Error: (OS 3) The system cannot find the path specified.
[code]....
strange thing that it realises the primary database in drive F and it goes to it but i dont understand what could be the reason of this ,although im doing this command while primary database is shutdown!
Server Administration :: UNDO In Parameter File?
Dec 9, 2011I have a question ragarding undo tablespace. I want to ask that why only undo tablespace information we need to specify in parameter file. We do not specify any other tablespace information. Not even for temporary tablespace. Then why we need to give undo tablespace name while instance is creating.
View 5 Replies View RelatedServer Administration :: ARC File Size Too Small?
Oct 2, 2012I noticed my DB is generating a lot of "small" .arc files and I am usure why. As you can see from the v$log query my log file size is set to 50MB. But yet BLOCKS*BLOCK_SIZE never adds up to 50MB.
Is there anything else I can look into to see how to make the .arc files larger?
SQL> select group#, thread#, bytes from v$log;
GROUP# THREAD# BYTES
---------- ---------- ----------
1 1 52428800
2 1 52428800
3 2 52428800
4 2 52428800
select blocks, block_size, blocks*block_size from v$archived_log where sequence# between 63876 and 72851 and thread# = 1
BLOCKS BLOCK_SIZE BLOCKS*BLOCK_SIZE
---------- ---------- -----------------
28 512 14336
28 512 14336
28 512 14336
55 512 28160
[code]...
Server Administration :: How To Check Alertlog File
Mar 3, 2012you have some 500 Db how will u check the alertlog file. do u do it manually or is their any tool to check the alertlog files. how to check it.
View 7 Replies View RelatedServer Administration :: Archive Log File Generating?
Jan 10, 2011I want to know how many archive log generating in One hour at the peak time. We have 6 nodes RAC multiplex 2.
Is there are any query through which I can achieve the above purpose.
Note: As this is a prod instance client is not happy to implement Log Miner utility.
Server Administration :: TNS Errors In Listener Log File?
Sep 11, 2012We are getting the below error messages in LISTENER LOG FILE. That too every 5 Mins.
10-SEP-2012 16:25:43 * (CONNECT_DATA=(SERVICE_NAME=dpm)(CID=(PROGRAM=W:Applicationdpm2010.exe)(HOST=ISSLDMUM01PC169)(USER=bharathi))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.80.100.39)(PORT=2241)) * establish * dpm * 0
10-SEP-2012 16:25:46 * service_update * DPM * 0
10-SEP-2012 16:25:47 * 12546
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
I am not getting the reason for it.
Server Administration :: Errors While Starting DB Using SP File
Sep 16, 2008SP file was removed during the testing and I started the database after making some changes in the pfile, and it works fine.
But when I try to start the database using the SPFILE, it gives an error.
SQL> STARTUP PFILE='D:oracleproduct10.2.0adminorclpfileINITORCL.ORA'
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 109052608 bytes
Database Buffers 171966464 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;
File created.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup
ORA-01565: error in identifying file 'D:oracleproduct10.2.0db_7/dbs/SPFILEORCL.ORA'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 1541)
The contents of the spfile in $ORACLE_HOMEdatabase are
*.SPFILE='D:oracleproduct10.2.0db_7/dbs/SPFILEORCL.ORA'
Server Administration :: Unable To Run Setup EXE File?
Mar 14, 2012when i try to install Oracle 10g (10.1.0.2) 64- bits on windows server 2003 enterprise edition 64 bits service pack1 and i try for windows server 2003 standard edition 64 bits on a pc,i am getting the below error.
the image file E: is valid, but it is for a machine type other than current machine
i need to install it as soon as possible .
Server Administration :: File Format Of DBF Files
Apr 12, 2010I want to know the file format of .dbf file.I want to open it in hex editor and want to read contents of that file from there.
View 4 Replies View RelatedServer Administration :: Create A New Control File?
Jul 12, 2012I am trying to create a new controlfile. I used "alter database backup controlfile to trace;" and then I copied and pasted the contents of the trace file into the .sql file. My sql script is
CREATE CONTROLFILE SET DATABASE "FIVESTAR" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
[code]....
Actually, the name of my database was 'STAR' and I changed it to "FIVESTAR" int this .sql script. Now when I run this script with SQL> @ <path of my sql script>, it gives me the following errors:
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01504: database name 'FIVESTAR' does not match parameter db_name 'STAR'
Server Administration :: How To Recreate Control File
Jun 12, 2012 I can not run the control file treace file,why?
[oracle@hxl oradata_bak]$ more run_sql.sql
CREATE CONTROLFILE REUSE DATABASE "ORACL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
[code]...
Server Administration :: Generation Of Redo Log File
Aug 20, 2010redo generation. As I found the below statement in another forum."Undo segment generates the redo data also, because undo segment is database changes, so it generates the redo data also."
How a Undo segment can generate Redo and Undo datas.
Server Administration :: Writing Control File
Nov 25, 2011I was doing some R&D on my test machine trying to understand how controlfile works. I started up my db and then deleted (renamed)the controlfiles at OS level. I was expecting the db to shutdown. But it dint. Moreover when i queried select name from v$controlfile; it was still reflecting the old controlfile names. To check if it was still functioning, i created a new tablespace with one file and it also got created without any error.
What i dint understand is how could the db still be running when the control file was'nt there and new tablespace and datafile get created? As i understand, whenever a new file is created, an entry is made in the control file. But when control file dint exist where was the data about new tablespace and datafile written?
Server Administration :: Move File System Datafile To ASM
Oct 23, 2012I mistakenly added a datafile to a tablespace which is asm, however the datafile was created in a default location and not the asm location:
alter tablespace pdaiidata1 add datafile '<filename>' size 2048M;
What I should have done:
alter tablepsace <tablespace_name> add datafile '+DATA1' size 2048M;
Is there any way to move this filesystem datafile into the asm tablespace? In previous Oracle versions, I've taken a tablespace offline, moved a datafile, renamed it, then brought the tablespace back online. Can I do something similar here in this situation?
