| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> ORA-02085 - Create Database link...
I should be able to figure this one out but can't ...
I am trying to replicate two servers runnning 8i. At this point I'm setting aup a db link on one of the two servers...
The servers are called qpdm and pdm8i
If I go onto qpdm and create a db link with... create public database link pdm8i.runtime.dk using 'pdm8i.runtime.dk';
But:
select * from user_tables_at_pdm8i.runtime.dk
*
The other server I did :
create public database link qpdm.runtime.dk using
'qpdm.runtime.dk';
select * from user_tables_at_qpdm.runtime.dk;
On both servers global names is set to true.
What I can't figure out is why it says ORACLE in the error message. I might of used the standard database but changed some of the parameters in my PFILE.
Here is my pfile on the offending server as you can see the dbname is pdm8i..
What's wrong???
:system> connect system/pdm_at_pdm8i
Connected.
:system> show parameters
NAME TYPE VALUE:system> set spool off
------------------------------------ ------- --------------------
O7_DICTIONARY_ACCESSIBILITY boolean TRUE always_anti_join string NESTED_LOOPS always_semi_join string standard aq_tm_processes integer 0 audit_trail string NONE background_dump_dest string D:\orant8i\admin\PDM backup_tape_io_slaves boolean FALSE bitmap_merge_area_size integer 1048576 blank_trimming boolean FALSE buffer_pool_keep string buffer_pool_recycle string commit_point_strength integer 1 compatible string 8.1.0 control_file_record_keep_time integer 7 control_files string D:\orant8i\oradata\P cpu_count integer 1 create_bitmap_area_size integer 8388608 cursor_space_for_time boolean FALSE db_block_buffers integer 3200 db_block_checking boolean FALSE db_block_checksum boolean FALSE NAME TYPE VALUE
------------------------------------ ------- --------------------
db_block_lru_latches integer 1 db_block_max_dirty_target integer 3200 db_block_size integer 2048 db_domain string db_file_direct_io_count integer 64 db_file_multiblock_read_count integer 16 db_file_name_convert string db_files integer 1024 db_name string PDM8i db_writer_processes integer 1 dblink_encrypt_login boolean FALSE dbwr_io_slaves integer 0 disk_asynch_io boolean TRUE distributed_transactions integer 500 dml_locks integer 988 enqueue_resources integer 2032 ent_domain_name string event string fast_start_io_target integer 3200 fast_start_parallel_rollback string LOW fixed_date string NAME TYPE VALUE
------------------------------------ ------- --------------------
gc_defer_time integer 10 gc_files_to_locks string gc_releasable_locks integer 0 gc_rollback_locks string global_names boolean TRUE hash_area_size integer 131072 hash_join_enabled boolean TRUE hash_multiblock_io_count integer 0 hi_shared_memory_address integer 0 hs_autoregister boolean TRUE ifile D:\orant8i\admin\PDM instance_groups string instance_name string PDM8i instance_number integer 0 java_max_sessionspace_size integer 0 java_pool_size string 20971520 java_soft_sessionspace_limit integer 0 job_queue_interval integer 10 job_queue_processes integer 2 large_pool_size string 0 license_max_sessions integer 0 NAME TYPE VALUE
------------------------------------ ------- --------------------
license_max_users integer 0 license_sessions_warning integer 0 lm_locks integer 12000 lm_procs integer 127 lm_ress integer 6000 local_listener string lock_name_space string lock_sga boolean FALSE log_archive_dest string log_archive_dest_1 string log_archive_dest_2 string log_archive_dest_3 string log_archive_dest_4 string log_archive_dest_5 string log_archive_dest_state_1 string enable log_archive_dest_state_2 string enable log_archive_dest_state_3 string enable log_archive_dest_state_4 string enable log_archive_dest_state_5 string enable log_archive_duplex_dest string log_archive_format string ARC%S.%T NAME TYPE VALUE
------------------------------------ ------- --------------------
log_archive_max_processes integer 1 log_archive_min_succeed_dest integer 1 log_archive_start boolean FALSE log_buffer integer 163840 log_checkpoint_interval integer 10000 log_checkpoint_timeout integer 1800 log_checkpoints_to_alert boolean FALSE log_file_name_convert string max_commit_propagation_delay integer 90000 max_dump_file_size integer 10240 max_enabled_roles integer 20 max_rollback_segments integer 49 mts_dispatchers string (ADDRESS=(PARTIAL=YE mts_listener_address string mts_max_dispatchers integer 5 mts_max_servers integer 20 mts_multiple_listeners boolean FALSE mts_servers integer 1 mts_service string PDM8i nls_calendar string nls_comp string NAME TYPE VALUE
------------------------------------ ------- --------------------
nls_currency string nls_date_format string nls_date_language string nls_dual_currency string nls_iso_currency string nls_language string AMERICAN nls_numeric_characters string nls_sort string nls_territory string AMERICA nls_time_format string nls_time_tz_format string nls_timestamp_format string nls_timestamp_tz_format string object_cache_max_size_percent integer 10 object_cache_optimal_size integer 102400 open_cursors integer 50 open_links integer 4 open_links_per_instance integer 4 optimizer_features_enable string 8.1.5 optimizer_index_caching integer 0 optimizer_index_cost_adj integer 100 NAME TYPE VALUE
------------------------------------ ------- --------------------
optimizer_max_permutations integer 80000 optimizer_mode string CHOOSE optimizer_percent_parallel integer 0 optimizer_search_limit integer 5 oracle_trace_collection_name string oracle_trace_collection_path string %ORACLE_HOME%\OTRACE oracle_trace_collection_size integer 5242880 oracle_trace_enable boolean FALSE oracle_trace_facility_name string oracled oracle_trace_facility_path string %ORACLE_HOME%\OTRACE os_authent_prefix string os_roles boolean FALSE parallel_adaptive_multi_user boolean FALSE parallel_automatic_tuning boolean FALSE parallel_broadcast_enabled boolean FALSE parallel_execution_message_size integer 2148 parallel_instance_group string parallel_max_servers integer 5 parallel_min_percent integer 0 parallel_min_servers integer 0 parallel_server boolean FALSE NAME TYPE VALUE
------------------------------------ ------- --------------------
parallel_server_instances integer 1 parallel_threads_per_cpu integer 2 partition_view_enabled boolean FALSE plsql_load_without_compile boolean FALSE plsql_v2_compatibility boolean FALSE pre_page_sga boolean FALSE processes integer 200 query_rewrite_enabled boolean FALSE query_rewrite_integrity string enforced rdbms_server_dn string read_only_open_delayed boolean FALSE recovery_parallelism integer 0 remote_dependencies_mode string TIMESTAMP remote_login_passwordfile string EXCLUSIVE remote_os_authent boolean FALSE remote_os_roles boolean FALSE replication_dependency_tracking boolean TRUE resource_limit boolean FALSE resource_manager_plan string rollback_segments string row_locking string always NAME TYPE VALUE
------------------------------------ ------- --------------------
serial_reuse string DISABLE serializable boolean FALSE service_names string PDM8i session_cached_cursors integer 0 session_max_open_files integer 10 sessions integer 225 shared_memory_address integer 0 shared_pool_reserved_size string 250000 shared_pool_size string 5000000 sort_area_retained_size integer 0 sort_area_size integer 65536 sort_multiblock_read_count integer 2 sql92_security boolean FALSE sql_trace boolean FALSE standby_archive_dest string %ORACLE_HOME%\RDBMS star_transformation_enabled string FALSE tape_asynch_io boolean TRUE text_enable boolean FALSE thread integer 0 timed_os_statistics integer 0 timed_statistics boolean FALSE NAME TYPE VALUE
------------------------------------ ------- --------------------
transaction_auditing boolean TRUE transactions integer 247 transactions_per_rollback_segment integer 5 use_indirect_data_buffers boolean FALSE user_dump_dest string D:\orant8i\admin\PDM utl_file_dir string
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Feb 07 2000 - 07:33:38 CST
 |
 |