Error Connecting To Database Vis Ora 10
Contents |
find the cause of
Error Connecting To Database Prod Ora 10
this error. Finally came across that APPLSYSPUP is in EXPIRED (GRACE)
Error Connecting To Database Test Ora 1
status . you can check this under dba_users cloumn account_status.I changed the status to open usingAlter user
Error Connecting To Database Ebstest Ora 10
APPLSYSPUB identified by PUB;This resolved my issue.RegardsGuru Posted by Gurtej Singh at 4:16 AM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Blog Archive ► 2008 (23) ► Jan 2008 (10) ► Feb 2008 (1) ► Mar 2008 (10) ► May 2008 (2) ► 2010 (1) ► Feb 2010 (1) ▼ 2011 (8) ▼ Jan 2011 (2) Error connecting to database ORA--1 Delete Discoverer Workbook from backend ► Mar 2011 (5) ► May 2011 (1) ► 2012 (3) ► Nov 2012 (3) ► 2013 (8) ► Sep 2013 (5) ► Oct 2013 (1) ► Nov 2013 (2) ► 2014 (3) ► Jan 2014 (2) ► Aug 2014 (1) ► 2015 (2) ► Jul 2015 (2) About Me Gurtej Singh View my complete profile Followers Site Viewers Visitors Simple template. Powered by Blogger.
100M AUTOEXTEND ON; CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE CAT1 TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON CAT1; grant connect,resource,recovery_catalog_owner to rman; Type rman RMAN> CONNECT CATALOG RMAN/RMAN connected to recovery catalog database RMAN> CREATE CATALOG; recovery catalog created Setups in TARGET database create user backup_admin identified by backup_admin default tablespace users; grant sysdba to backup_admin; [oratest@oracle http://oracleapplicationguru.blogspot.com/2011/01/error-connecting-to-database-ora-1.html 11.1.0]$ rman target backup_admin/backup_admin@test catalog=rman/rman@catalog Recovery Manager: Release 11.1.0.7.0 - Production on Tue Feb 21 23:39:22 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: TEST (DBID=2072291809) connected to recovery catalog database RMAN> register database; database registered in recovery catalog starting http://amilasanoracle.blogspot.com/2012_02_01_archive.html full resync of recovery catalog full resync complete RMAN> show all; RMAN configuration parameters for database with db_unique_name TEST are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/d03/oracle/TEST/db/tech_st/11.1.0/dbs/snapcf_TEST.f'
while creating a linked server to Oracle ★★★★★★★★★★★★★★★ SnehadeepJune 30, 201028 0 0 0 This is one of the most common errors while creating linked server to Oracle database. Today I will discuss the reason for https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/06/30/ora-12154-tns-could-not-resolve-the-connect-identifier-specified-error-while-creating-a-linked-server-to-oracle/ this error and possible resolutions.
Full error message: OLE DB provider "MSDAORA" for linked server "LINKED_ORA" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". Msg 7303, Level 16, State https://ar.scribd.com/doc/136898613/ebs-Issue 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "LINKED_ORA". First of all make sure you have reviewed the following Microsoft KB article that has error connecting a lot of good information on troubleshooting Oracle linked server issues. How to set up and troubleshoot a linked server to an Oracle database in SQL Server http://support.microsoft.com/kb/280106 Also make sure you have installed Oracle Client on the SQL server. If the SQL server is 64 bit then we need to install 64 bit Oracle provider. You can also create linked server using Oracle ODBC driver together error connecting to with Microsoft OLE DB provider for ODBC. Once again on a 64 bit SQL server you need to install the 64-Bit OLEDB Provider for ODBC (MSDASQL) and 64 bit Oracle ODBC drivers. However 64-Bit OLEDB Provider for ODBC (MSDASQL) is already there in Windows Vista/Windows Server 2008 and later OS. This particular error message is a very general error message and can happen for quite a number of reasons. For general understanding of the error, you can review oracle documentation like this http://ora-12154.ora-code.com/ In SQL Server Linked Server, it could indicate a few things (not limited to)– 1. SQL Server (and oracle net libraries) is not able to get the TNS alias from tnsnames.ora file. 2. Something is wrong with the way the alias is created in the tnsnames.ora file (incorrect syntax) 3. TNS alias could not be resolved into a connect descriptor Below is a list of things that you can try to resolve this issue. 1. Verify that the tnsnames.ora file has the alias and the service name that the customer is using. TNS entry for the Oracle database =========================== OracleDB_Dev = (DESCRIPTION = (ADDRESS_LIST = (ADDallUploadSign inJoinBooksAudiobooksComicsSheet Music You're Reading a Free Preview Pages 4 to 36 are not shown in this preview. Buy the Full Version ebs IssueUploaded by pankajhDatabaseHypertext Transfer ProtocolSqlOracle Database456 viewsDownloadEmbedDescription: ebs IssueSee Moreebs IssueCopyright: Attribution Non-Commercial (BY-NC)List price: $0.00Download as DOC, PDF, TXT or read online from ScribdFlag for inappropriate content Documents similar to ebs IssueStep-By-step Installation of an EBS 12.2 Vision InstanceOracleAppsUpgradeFrom11.5.10.2to12.1.1DBA TasksOracle Fusion HCM Bootcamp_Student Guide 1Oracle Apps DBA KvTwp SQL Plan Mgmt 12c 1963237DB Best PracticesSQL Server 2012 Why Oracle RAC Might Not Be Suitable for You Apr2012Oracle 9i Performance Tuning Student Guide Volume 2Millsap - Profiling Oracle, How It Works (Slides)Database Management - Dbms Question BankDR_switching_ by Mirza Sir32 Tips for Oracle SQL Query Writing and Performance TuningOracleIT BrochureBPEL Installation b28980Creating Standby Physical Database Without Using Data GuardSaphirGettingStartedSql_loader Faq - Oracle Faqdatagaurd intro 9i oracleOracle+Database +Urgent +ORACLE+Initialization+or+Shutdown+in+ProgressStreams10gOracle Training in Hyderabadenterprise internet twp26084303 Configuring Oracle on Linux for Peak Performanceweblogicserverintegration-1991450.pdf1 Oracle 10g FeaturesBI authentication.pdfOracle Interview Questions 1to16wp-o10g-rac-config-unx-303804Oracle Instance Basic ManualBooks similar to ebs IssueEJB 3.0 Database Persistence with Oracle Fusion Middleware 11gGetting Started with Oracle Public CloudOracle SOA Suite 11g Administrator's HandbookOracle Data Guard 11gR2 Administration Beginner's GuideAdvanced SQL:1999Microsoft SQL Server 2005 Performance Optimization and Tuning HandbookSQL in 30 PagesQuerying with SQL T-SQL for Microsoft SQL ServerLearning SQL Server Reporting Services 2012Beginners Guide to SQL Server Integration Services Using Visual Studio 2005MongoDB CookbookLearning Jakarta Struts 1.2Building Applicatio